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

[Rob Hofkens]

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.

 

[Haris Rashid]

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,

 

[Rob Hofkens]

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.