Read Only tables?

[colin ashley]

I am using a SQL 2000 Database with an Access 97 front end linked via an
ODBC file DSN. Operating system is NT 4 sp6. Yesterday I created a couple of
SQL tables and linked them into my Access database. I was able to read,
write and delete from Access on both tables. I opened my Access front end
this morning, and, the tables are read only!

I can open the tables from SQL, and update them at will. I have tried
deleting and re-linking the tables, deleting and replacing the file DSN, but
these tables remain stubbornly read-only. Other tables in the Access DB
using the same ODBC links are working OK.

Suggestions would be warmly welcomed

thanks

colin

 

[Sylvain Lafontaine]

Try the /decompile switch following by a compress and repair of the
database.

If this doesn't work, go to the references options in the VBA windows (open
any module to get there), add any new reference, close the dialogue window
by click OK, re-open it again et delete the reference that you have just
added. This will force Access to recompile all internal modules. Select
"Recompile all modules" from the Debug option and recompress/repair your
Access database.

Also, verify that all of your SQL tables have a primary key and that the
name of each of the primary key begin with something like "aaaaPK..."; as
Access 97 use alphabetical order to distinguish beetween a primary key and
others index and constrains that may be defined for each SQL table.

If nothing of this work, then create a new and empty database and import all
your work (tables, forms, modules, menus, etc.) from the old file to the
new.

Also, as you have created new SQL tables yesterday, it is possible that you
have used another account to create them and that you have changed account
today.

S. L.

 

[colin ashley]

Thanks Sylvain

it was the lack of a Primary Key in the SQL table that did it. I can't
imagine how the key got removed, but I don't care now....its fixed!

thanks again

colin