R
Rob Hofkens
Hello everyone ,
First time for me to use Access with SQL server and got problems starting.
I am trying to use Access 2000 on a client with SQL Server 2000 on a server.
For testing I created a Test database on the SQL Server and set the right
permissions with Windows Authentication.
Next I started Access 2000 on a Win XP client and made a new Project with an
excisting database.
I gave it a name and saved the project to a local folder on the client.
After this I got the connection window and I selected the SQL server, set
Windows Authentication and selected the Test database.
Then I tested the connection wich turned out ok!
After pressing Ok I find myself looking at the database , ready for usage.
BUT evertime I want to create something I get this error:
You don't have exclusive access to the database. Changes won't be saved.
(translated from Dutch).
I found an option to open the project exclusive but that doesn't change
anything.
Some help would be appreciated.
Thanx in advance.
Rob.
First time for me to use Access with SQL server and got problems starting.
I am trying to use Access 2000 on a client with SQL Server 2000 on a server.
For testing I created a Test database on the SQL Server and set the right
permissions with Windows Authentication.
Next I started Access 2000 on a Win XP client and made a new Project with an
excisting database.
I gave it a name and saved the project to a local folder on the client.
After this I got the connection window and I selected the SQL server, set
Windows Authentication and selected the Test database.
Then I tested the connection wich turned out ok!
After pressing Ok I find myself looking at the database , ready for usage.
BUT evertime I want to create something I get this error:
You don't have exclusive access to the database. Changes won't be saved.
(translated from Dutch).
I found an option to open the project exclusive but that doesn't change
anything.
Some help would be appreciated.
Thanx in advance.
Rob.