Shared database/database spliiter/copy of front end

[Becky]

Hello-
Here's the situation I created. The "raw" data resides in tables in a
database on a server. I created a second database with table links to the
data in the raw data database. 5 end users share/input and viow the data in
the linked table database using forms. Is this design OK? Should I have a
copy of the linked table database on each users computer? If so, how do I
copy the linked table database so the links update properly. In effect, did
I really split the database? Should all my 5 end users be opening and using
the same form? Thanks for your help - Becky

 

[Douglas J. Steele]

Each user should have his/her own copy of the second database.

I'm afraid I don't understand your query about "how do I copy the linked
table database so the links update properly". Are you concerned that the
users might not have their drives mapped the same way? Link using a URL
(\\server\share\folder\file.mdb) rather than a drive letter
(F:\folder\file.mdb)

 

[Becky]

Hi Doug-
How do I make a copy of the second database for each users computer? Thanks
for your help - Becky

 

[Douglas J. Steele]

It's a file. Give each user a copy of it!

You might find the Auto FE Update that Tony Toews has for free at
http://www.granite.ab.ca/access/autofe.htm to be useful.