After Splitting Database, them what?

S

SailorRoy

I have split my database and saved the tables to the server. I can access
them from my computer (Computer A) but can not from other computers (B, C,
etc.). How do I get the forms to those computers and to link to the tables?
I am using version 2007 and it is loaded on all systems. I am new at this so
simple step by step instructions please. Thanks
 
D

Daniel

You now have a back-end (table - place in central location...ie server) and a
front-end (forms, query,....).

simply distribute a copy of the front-end on each computer you wish to
access the db. Each computer should have their own front-end. Do not use a
common copy.

Question for you, Have you implemented security?
 
S

SailorRoy

Thanks for your help. I got it. Where I had a problem was that the system
has different drive letters for the server on the different computers so when
I copied it over it would not access the back end because it designated the
wrong drive. I went to each computer and did a split from the original copy
leaving one copy of the back end on the server.
 
D

Douglas J. Steele

Note that you can use a UNC (\\server\share\folder\file.mdb), rather than a
mapped drive (E:\folder\file.mdb).

To do this through the Linked Table Manager, find the back-end database
through the Network Neighborhood, rather than finding it via a mapped drive.
 
T

Todos Menos [MSFT]

dude don't listen to these newbies

splitting doesn't help jack shit

move to sql server and spit on these MDB cry babies
 
S

SailorRoy

You have been of great help. I relinked it through the network instead of a
mapped drive. It works. My boss thinks I know what I am doing. :) .....
 
T

Tony Toews [MVP]

A a r o n K e m p f wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Todos Menos [MSFT]

Tony

STFU and go and play with your barbie databases

MDb is for lamers and retards; only a senile dipshit would still use
it
 
T

Todos Menos [MSFT]

Please note that Tony is not worthy of writing queries for a living
because he is a MDB WUSS

and for the record, I never claimed to be a MSFT employee, kid
 
T

Todos Menos [MSFT]

Note that Tony Toews is a MDB _WUSS_ and should not be trusted for
anything.

It's like going to ask a 1st grader for financial advice


ADP uber alles!
 
T

Tony Toews [MVP]

SailorRoy said:
You have been of great help. I relinked it through the network instead of a
mapped drive. It works. My boss thinks I know what I am doing. :)
Click to expand...

<chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top