I developed an Access app 10 years ago using an ODBC connection to a hosted SQL Server database. My host has just updated their servers and has changed the url of the server. I need to update the ODBC connection to attach the approx 30 tables.
Here's my problem:
I have a much older copy of my mdb in which I can edit the ODBC connection. However, there are also a number of Access tables that contain vital data.
My "working" version of the app is an mde, and the Access tables contain up to date vital data.
Is there a way for me to edit the ODBC connections in an mde?
Or, is there a way to transfer the current data in my non ODBC tables to my mbd?
Any advice will be much appreciated!
Thanks,
Sup
Here's my problem:
I have a much older copy of my mdb in which I can edit the ODBC connection. However, there are also a number of Access tables that contain vital data.
My "working" version of the app is an mde, and the Access tables contain up to date vital data.
Is there a way for me to edit the ODBC connections in an mde?
Or, is there a way to transfer the current data in my non ODBC tables to my mbd?
Any advice will be much appreciated!
Thanks,
Sup