Hi all.

Need some help please. I'm running an old vb6 front end - access mdb back end and it's been on a local device that a few guys have logged on to over the years over our local network.

Due to covid, I purchased a server with MS Server 2019 installed and my plan is to move the application over to it and RD from anywhere however I'm struggling.

I've gone to install the application but it is trying to find the mdb from wherever the front end location is. Even when I open the front end in the same location as the mdb, it still can't connect.

The system is built in dao and I'm wary that I need to re-code to ado (if someone can confirm). Any ideas please on what I need to do to successfully install on the server? I think I may need to regsvr the dao files too?

Any help owuld be much appreciated. Can copy and paste snippets of code too.

Regards