No Permissions to Add, Delete, or Modify Records (1 Viewer)

[Doctor Dave]

I created an Access Project as the front end of my web hosting service’s SQL Server. I am able to create tables and import tables to this SQL database from other Access databases. However, I can not add, delete, or modify any records of any table. Essentially, I am in read only mode other than the ability to create tables. Note that I can add, delete, and modify the SQL database records via Visual Studio 2005 server control panel.

What am I missing?

Windows XP
Access 2003
SQL Server 2000

Thanks - Dave

 

[johanbr]

permission

Dave,

We had a simular problem. The Sqlserver table didn't have a primary key, after changing the table i could in access update and insert records in this sqlserver table.


Regards,
Johan