StellarCobol
09-09-2014, 01:37 PM
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.
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.