Access 2007 Sharing a Database with Multiple Users

[Yvon]

I have a pc and a laptop that are networked through an adsl router. I have
managed to share printers and have created a shared directory on the PC. The
laptop has full access to the dirctory and there is an access database in the
directory. I am able to open the access database on both the pc and the
laptop successfully (one at a time) but I cannot open the database on both at
the same time. I have vista ultimate and office 2007 on the pc and vista
business and office 2007 on the laptop. What do I do to be able to open and
work in the database from both pc's
Plse help!

 

[a a r o n _ k e m p f]

Access doesn't inherently support multiple users.. it's just not
reliable enough for real world usage.

i'd reccomend upsizing to SQL Sever and using the 'ADP dialect' of MS
Access

 

[Bill Mosca]

Yvon

Perhaps you are opening it in exclusive mode? If you are opening the
database by double-clicking it in Windows Explorer or have a shortcut that
does not explicitly have msaccess.exe in the target line, the file is
opening in exclusive mode. The shortcut should have the full path to the
Access executable in the target line as in:
"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
"C:\MyFolder\MyDatabase.mdb"

But it is not a good idea sharing the database. If you have multiple users,
the database should be split with the tables in one file (back end) and
everything else in another file (front end). Each user should have his own
front end linked to the tables in the back end.

 

[BruceM]

You are incorrect. Access supports multiple users. Splitting is a good
idea, especially in a multi-user environment, and is not at all difficult to
do.

Access doesn't inherently support multiple users.. it's just not
reliable enough for real world usage.

i'd reccomend upsizing to SQL Sever and using the 'ADP dialect' of MS
Access

 

[a a r o n _ k e m p f]

Access was not designed-- from the ground up-- for multiple users.

It doesn't support 80% of the real world networks out there.
If your database doesn't support:

Wireless
VPN
WAN

then it is time for a new database!
Especially if the dorks around here blame it on the network!!