Sharing a database...please help!!!

[zmenloans]

Hi,

I have a database with 10 tables (all have their own form as well) and one
union query that connects the ten tables. I want this database to be
available to 10 users at once. They will all be working in the ten separate
tables, and they might look at the union query every once in a while.

I've read information regarding splitting to a FE and BE database, but I
have run into a problem. The database is on a shared drive (titled Bbc), but
the shared drive is different for each person. For example, some employees'
Bbc drive is located on the (G drive and some are on the (H drive, etc.
depending on the various employees. I'm not positive why it was set up like
this but it was and I can't change that. Therefore, the Backend database
splitting thing wouldn't work because linked tables aren't really an option.

I have the advanced options already set to 'shared' (not exclusive), but
when someone tries to open it on another computer it says that it is locked
by me. I'm just lost with options...please help.

Thanks!

 

[Douglas J. Steele]

You can link using a UNC (\\servername\sharename\folder\file.mdb) instead of
a mapped drive letter.

 

[zmenloans]

Thanks Doug! How is that done?

You can link using a UNC (\\servername\sharename\folder\file.mdb) instead of
a mapped drive letter.

 

[Jeff Boyce]

?? each user has his/her own table ?? If that's your data/table structure,
both you and Access will have to work overtime to overcome that design.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

If you're going through the Linked Table Manager, navigate to the database
through Network Neighborhood (or whatever it's called in your version of
Windows) rather than navigating via the mapped drive.