update data on query

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

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?
 
Roy Goldhammer said:
Hello there

i have mdb with sql tables.

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

what can cause it?
Click to expand...

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.
 
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
 
Back
Top