Can't change or add something to an ADP ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.




.

Relevant Pages

  • Re: Reaching Access 2003 datas via SQL Server 2005 64 bits
    ... even with the procedure to create the invoice number I still ... One client enters in the store and asks for a product. ... formats of Access database files known as MDB and ACCDB and/or Access JET. ... (I have no problem to reach Sql Server 2005 tables from Microsoft ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Quick Question on SQL Server 2005 Express
    ... you can't attach a database in a remote machine in your network as Andrew has already mantioned. ... One database can be used only by one SQL Server instance and as far as I understand the database in question is already attached to a SQL Server instance. ... Why not installing only SQL Server Management Studio and connect to your remote instance and perform actions this way? ... The Client can live anywhere as long as it has TCP access to the server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... use SQL Server authentication instead. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
    (microsoft.public.windows.server.sbs)
  • Re: Quick Question on SQL Server 2005 Express
    ... I have not seen any documentation yet that states connecting other editions of SQL Server using SSMSE would break any license agreement. ... As Ekrem stated they should have a licensed edition of the full client tools and then all they have to do is register the server in the registered servers dialog and they should be all set. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)