Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Unable to directly change Table Contents MS Access

Author  Topic 

SHARDIK-GUARDIAN
Starting Member

20 Posts

Posted - 2009-10-06 : 11:52:59
Hi All! :)

For the past few years I have been using MS Access and Enterprise Manager (E.M. more frequently) to administrate some content in a MSSQL DB. EM was recently replaced with MS SQL Server Management Studio Express.

Today I connect to the DB using Access and I am unable to change anything in the tables. Everything appears to be read only.

I have tried it on two PC's, both have the same issue.

Luckily I can use Remote Desktop to connect to the server directly and use the old version of EM which has not yet been upgraded :)

I really need to be able to make changes to the DB content without always have to connect to the Servers desktop.

I hope someone can help me find the source of the problem.

1,000 thanks all :) have a groovy evening.

------------------------------------------------------------
Was there ever a trap to match the trap of love?
   

- Advertisement -