Access 2000 + SQL Server 2000 : Cannot add or change tables ?

Greetings,

Real noob here trying to use Access with SQL Server.
I have a local access database and want to use it with the SQL Server.
What I did was this:
Created a new project and connected to the SQL Server to an empty database.
Then I imported the data from the existing local access database to the SQL
Server.
As a result I got all tables on the SQL Server but I cannot change or add
another table.
Every time Access comes with the same message:
You don't have exclusive access to the database !

I tried opening the project in exclusive mode but I cannot tell if it realy
is in exclusive mode but I can tell it still doesn't work.

Some help would be appreciated.

Thanx in advance.

Rob.

hi,

IN MS SQL create an account with priviliges to alter the schema. Use this
account to connect to the SQL Server database thorugh MS Access.

Regards,
---------------------------
Haris

http://www.Designing-Systems.com
-------------------------------------------


"Rob Hofkens" wrote:

Greetings,

Real noob here trying to use Access with SQL Server.
I have a local access database and want to use it with the SQL Server.
What I did was this:
Created a new project and connected to the SQL Server to an empty database.
Then I imported the data from the existing local access database to the SQL
Server.
As a result I got all tables on the SQL Server but I cannot change or add
another table.
Every time Access comes with the same message:
You don't have exclusive access to the database !

I tried opening the project in exclusive mode but I cannot tell if it realy
is in exclusive mode but I can tell it still doesn't work.

Some help would be appreciated.

Thanx in advance.

Rob.

Hello Haris,

I have a login account on the MS SQL server named Domain Users and my
Windows login account belongs to that domain.
So I should have the same rights as the Domain Users have ...right?
To make sure I have enough rights I even enabled every option in the Domain
User account on MS SQL.
But this still doesnt work.

You think that the message I get about not having exclusive rights is
somehow related to the lgoin account on the MS SQL Server ?

Thx.


"Haris Rashid" schreef in bericht
...
hi,

IN MS SQL create an account with priviliges to alter the schema. Use this
account to connect to the SQL Server database thorugh MS Access.

Regards,
---------------------------
Haris

http://www.Designing-Systems.com
-------------------------------------------


"Rob Hofkens" wrote:

Greetings,

Real noob here trying to use Access with SQL Server.
I have a local access database and want to use it with the SQL Server.
What I did was this:
Created a new project and connected to the SQL Server to an empty
database.
Then I imported the data from the existing local access database to the
SQL
Server.
As a result I got all tables on the SQL Server but I cannot change or add
another table.
Every time Access comes with the same message:
You don't have exclusive access to the database !

I tried opening the project in exclusive mode but I cannot tell if it
realy
is in exclusive mode but I can tell it still doesn't work.

Some help would be appreciated.

Thanx in advance.

Rob.