Forum Discussion

NoPainNoGlory's avatar
NoPainNoGlory
Copper Contributor
Nov 04, 2022

Problem to migrate simple Access mde app and Microsoft Sql Database to another PC

Hello there,

Im struggling to move an old Access app, which runs on a windows server 2003, to my Windows 10 PC, The app is run from the Server desktop via mde file and is connected to a microsoft SQLEXPRESS database installed locally on the server, I installed locally on my pc windows 10 Microsoft Sql express, and changed the hostname of my PC setting "SERVER".

I can access the tables and the database seems to work, but when I launch the "example.mde" file from my computer the application fails and cannot find the database asking me for the path..

if i click continue with trusted authentication it ask me again for every move i make .. I don't know how to specify the data source or connection string for the database on the new machine, I believe this is about the ODBC driver, attached the error I get.

this is the Image of the error i get 


 Thanks in advance for the help

No RepliesBe the first to reply

Resources