Access --> SQL 2000 (Read only)

[Charlo]

I converted an Access 2003 Database to run on SQL 2000. However, it is
apparent that the database is being opened in exclusive mode by the first
user.
I know how to resolve this when the back-end is also Access 2003 but how do
I resolve this as it is on SQL 2000.

 

[Douglas J. Steele]

You've got an Access front-end talking to a SQL Server backend. Each user
should have his/her own copy of the front-end, preferably on their hard
drive.

Now, your subject mentions Read only, as opposed to exclusive. If the
problem actually is read-only, do you have primary keys defined for each of
the tables in SQL Server.

 

[Jeff Boyce]

In addition to Doug's suggestions, can you confirm that the permissions have
been properly set on the SQL Server back-end?

Regards

Jeff Boyce
<Office/Access MVP>