MS Access data conversion - Access --> SQL 2000 (Read only)

Author

Access --> SQL 2000 (Read only)

Charlo

2005-11-09, 1:25 pm

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

2005-11-09, 8:25 pm

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.

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

"Charlo" <Charlo@discussions.microsoft.com> wrote in message
news:9537A568-58A1-4F3A-84D5- 92348FA2C4EF@microso
ft.com...
>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.

Jeff Boyce

2005-11-09, 8:25 pm

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>

"Charlo" <Charlo@discussions.microsoft.com> wrote in message
news:9537A568-58A1-4F3A-84D5- 92348FA2C4EF@microso
ft.com...
>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.

Sponsored Links