MS SQL Server Connectivity - ReadOnly Tables from Access 2003

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ReadOnly Tables from Access 2003

Jim McDonald

2006-04-01, 9:23 am

Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.connect:48724

Hi all
I used the import utility to move some access tables to a SQL Svr db, and
while it all seemed to go AOK, whatever I do the resultant SQL tables appear
to be read-only. There are other tables in the SQL db that will read & write
OK.
Can any one help and tell me how to make the SQL tables writable??
thanks

Jimbo

Sponsored Links