Search results

New little problem... On my development machine. it's all perfect. BUT when I deploy, it fails to connect and I think the culprit is an additional "Network = DBMSSOCN" added to the connection string when converting to DSN-less connection. When running the VBA procedure FixConnections...

Perfect! Thank you very much for your help guys. This community is truly amazing! :D

It is a "System DSN". It's been a long time since I created the initial table links so I don't remember how it looked. For the recent linked tables, I was forced initially to create a (system) DSN. Since then, I just refer to it again and again. But when copying to my user workstation, it...

I have a MS Access database (2013) that I created many years ago which accesses SQL Server tables (2016) through linked tables. Recently I added a couple of linked tables and seemed forced to use a DSN file in the process. When deploying my new version to my customer, the link tables fail...

All sorted. Many thanks! :D

Cool, I think this solves part 1 of my problem! The runtime is indeed available still. Now, I just need to figure out how to change the connection properties of my ADP file without the menu system, but I hope this should be easy to find. Thanks :)

Dear all, I have developed an MS Access 2010 .adp project (a few years ago) that I would like my customer to use but they didn't have MS Access installed. They bought MS Access 2013 because they could not buy 2010 any more but I have since discovered that there would be a lot of work...