asked on

link table in Access database is locked. I can not edit the table.

I have database created in SQL server 2005 and linked tables in Access database. I can view all the link tables in access database but i can not edit any tables. If i edit table in SQL Server then i can see the changes in Access link table.

I want to be able to make changes from Access tabes. I have form that is using lunked table to edit information. I can pull up information in the form but can not make any changes.

I know it is possibel i just cant remember how to do it.

Thank you in advance.

Diveblue

are you using sql server authentication or windows authentication (Do you log into sql server with a uid/pwd) ?

does the account you are using to link the access tables have edit authority on the tables?

do the tables have primary keys defined?

jmoss111

Do the linked tables have time stamps?

Anandhi1

ASKER

I'm using SQL Server Authentication and it has dbo privileges. I created ODBC DSN and used that loging to link in Access database.

Yes. Some tables have primary key and foriegn key.

I didnt see time stpamp field in tables.

Thank You.

jmoss111

You'll need primary key and/or timestamp.

Anandhi1

ASKER

So do i need column with timestamp datatype in the table?

ASKER CERTIFIED SOLUTION

Diveblue

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Diveblue

if you open the table directly in access(not using the form), can you edit it?