Access odbc Issues

[StellarCobol]

Hi All,

Apologies if this is a stupid question.

I have inherited an Access application and its been a few years since I dealt with Access.

Its Access 2010 and uses linked tables against SQL Server 2008.

I have moved the mdb to a new server and relinked the tables to point at a new data source/instance.

This all seems to be fine , except I have two forms that when I try to open them, I get a SQL Server connection error which then opens a popup to select a data source,this by default seems to want to connect to the instance on the old server, and even if I select the new instance it won't connect and I get the same error.

This also happens if I try to update dependencies.


Any ideas?

Thanks for your time.

[jonh]

So all the table connections are correct?

Hovering over tables should show the connections.
or

select connect from msysobjects where connect is not null

If the old database was still available when you used the linked table manager the connections were probably only refreshed rather than updated. To force links to be changed, make sure 'Always prompt for new location' is checked.

[StellarCobol]

Thanks jonh,

All the linked tables seem fine , If I step through the code and as soon as it tries to open a particular form , this happens and I get no further. If I try and open that form in design view it also happens.

12252

[jonh]

Check queries for odbc connection string?

select * from msysqueries
should be column 'name1'