Sharing a Db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vadimbar - 08 Aug 2007 17:48 GMT

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?

Reply to this Message

Jeff Boyce - 08 Aug 2007 20:21 GMT

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

> 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
[quoted text clipped - 4 lines]
> a site that can explain this simply with out having to read an entire
> novel?

Reply to this Message

Vadimbar - 08 Aug 2007 21:12 GMT

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?

> I think you've given a very good explanation of how (and why) you would
> split an Access database.
[quoted text clipped - 19 lines]
> > a site that can explain this simply with out having to read an entire
> > novel?

Reply to this Message

Douglas J. Steele - 08 Aug 2007 22:34 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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
[quoted text clipped - 31 lines]
>> > a site that can explain this simply with out having to read an entire
>> > novel?

Reply to this Message

Vadimbar - 09 Aug 2007 14:52 GMT

Thank you,
Vadimbar

> Check out the free Auto FE Updater Tony Toews has at
> http://www.granite.ab.ca/access/autofe.htm
[quoted text clipped - 34 lines]
> >> > a site that can explain this simply with out having to read an entire
> >> > novel?

Reply to this Message