I have an Access database on a Windows Server 2003 share. This
database contains linked tables that actually reside on a SQL Server.
There are a couple of things that I've noticed recently:
1) Some users cannot open the database if another person is already in
it, but some can. The people who cannot open it do not receive any
type of messages...it just doesn't open.
2) Everyone who opens the database (after the first person) receives a
message stating that it is opening Read-Only
I can deal with the second issue, but not the first. I know I've seen
posts on this group stating that you shouldn't share the front end, but
does that still hold true if there are no tables? What are the
disadvantages of sharing the front end, and why would my people not be
able to open it?
Thanks!
Ryan