edit odbc connections on .mde (1 Viewer)

supmktg

Registered User.
Local time
Today, 06:38
Joined
Mar 25, 2002
Messages
360
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
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:38
Joined
Oct 29, 2018
Messages
21,358
Hi. You should be able to edit the connection string to the tables in an mde. I don't have one to do any testing right now, but it should be possible.
 

isladogs

MVP / VIP
Local time
Today, 11:38
Joined
Jan 14, 2017
Messages
18,186
Also, you can definitely transfer the MDE local tables to another MDB database
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:38
Joined
May 7, 2009
Messages
19,175
you can't Change the Connection string in an MDE.
Either directly or from separate db.

you can copy the tables right, how about the forms/reports?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 11:38
Joined
Feb 19, 2013
Messages
16,554
not sure about .mde but in a .accde you can use the external data>odbc to link to your sql server tables (not relink, create a new one). Then delete the original linked tables and rename the new ones. Or just rename the new ones which should delete the old ones automatically.

Do this on a copy of the .mde and if successful replace the original with the copy.

But probably simpler just to import the mde access tables to your mdb.

Surprised your app is not split - usual practice is for the front end to not have any tables, certainly not vital data
 

isladogs

MVP / VIP
Local time
Today, 11:38
Joined
Jan 14, 2017
Messages
18,186
you can't Change the Connection string in an MDE.
Either directly or from separate db.
Yes you can do so easily using the linked table manager. For example:

1627460466967.png


Or you can use the method described by @CJ_London
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:38
Joined
Feb 19, 2002
Messages
42,981
More importantly supmktg, you need to pay someone to produce an .mdb from your .mde. I don't have the link handy but someone will post it. You will have to prove that you are the developer.
 

Users who are viewing this thread

Top Bottom