update data on query

[Roy Goldhammer]

Hello there

i have mdb with sql tables.

After i made link table manager, all the quries becume updateable

what can cause it?

 

[Rick Brandt]

Hello there

i have mdb with sql tables.

After i made link table manager, all the quries becume updateable

what can cause it?

If you create links to ODBC source tables that have no primary key you are
prompted by Access at link creation time to pick one or more fields that Access
can use to build a local unique index on. That is required to allow edits. If
you later refresh your links that local index information is discarded.

The best solution is to have PKs on all of the source tables and then the local
index is not required. Otherwise you will need to delete the links and
re-create them from scratch or run code to build the local indexes every time
you refresh the links.

 

[Roy Goldhammer]

Whell Rick

The problem is that on some of the tables on sql server there isn't primary
key. and it is not time now to add them

What i did is do delete the old tables and create them again from older
version of access