After Splitting Database, them what?

[Guest]

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

 

[Guest]

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?

 

[Albert D. Kallal]

I have a rather long and easy to read article that explains this whole
process:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Guest]

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.

 

[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.

 

[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

 

[Guest]

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. .....

 

[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

 

[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

 

[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

 

[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!

 

[Tony Toews [MVP]]

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.

<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