Sharing a Db

[Vadimbar]

When I use Access I seperate out the table from the forma and queries.
I then make multiple copies of my MDB file that stores the forms and
queries.I do this when I need multiple users to access my tables at the same
time. I know there is a better way such as using SQL can anyone direct me to
a site that can explain this simply with out having to read an entire novel?

 

[Jeff Boyce]

I think you've given a very good explanation of how (and why) you would
split an Access database.

The tables-only portion goes on a LAN server that all users can connect to.

The forms/queries/... all the rest gets copied and place on each user's PC.

Even if you were using SQL-Server, you could still use this approach (data
on the LAN, user-interface on each PC).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Vadimbar]

Thank you Jeff. Is it possible to have the send MDB file with forms and
queries accessed at the same time by multiple users. In case of a change to a
form or query---> in a case were we are using a large user group then we
would need to modify and re-assign a file for each user. Isn' there a better
way?

 

[Douglas J. Steele]

Check out the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

 

[Vadimbar]

Thank you,
Vadimbar

Check out the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm