Change in MSysObjects..?

[Kent Johnson]

Hi all,

I have this in the 'Connect' column in 'MSysObjects':

Description=MyDb;DRIVER=SQL Server;SERVER=MyServer;APP=Microsoft Data Access
Components;WSID=MYSERVER;DATABASE=MyDb

...an all I want to do is to change the server name.

I have tried to open the Access Database in 'Exclusive' mode but I'm not
allowed to change.
How can I change a record in the system table 'MSysObjects'?

 

[Douglas J. Steele]

You can't (or, more accurately, you shouldn't)

Instead, delete the connected table and recreate it, setting its Connect
property to what you want.