ADP with MS SQL Server 2000

[MarkWright]

Hello, I have a problem ( ha ha) We have an SQL 7 Server and we are updating to a 2000 server. So my problem is--
I do not have full access to the ADP datenbank from a client computer. I have all rights but somewhere I have missed a check box or something. I can not change any tables in the ADP outside the Server.I can only look at the tables but can not change the inhalt. If I am on the Server I can do everything. I have checked and rechecked but I can not find the problem. I did everything like I did on our SQL 7 Server and I have no problems with accessing and changing the ADP Datenbank from a client computer. Does anyone have any Ideas ??
Thanks for your time
Mark

 

[chrissie1]

if you mean you cant add or delete records then you need to set a primary index on your table.

if you mean you cant change the table properties and
if you are using access 2000 then try the service packs or upgrade to access 2002.


Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong