Migration from Access 2010 .adp to Access 2016 .accdb

[code]

Hi All,

I need some help. I'm not an access expert yet! I am upgrading an access 2010 .adp database with an sql backend. I imported all of the forms, reports, etc created linked tables into an access 2010 .mdb then imported into an access 2016 database. now my issues is all of the forms use the currentproject.connection. I tried to create a global module and in the first form I set the connection for the project, but it is not working or is there a different way I should be doing this? help!

[June7]

You are still using SQL backend (SQLServer)? https://support.office.com/en-us/art...2-77bc6089b84e

[code]

thank you very much for responding, yes, it has a sql server 2012 backend and I linked the tables with a DSN file, but how to I update the forms to look at the new linked tables? currently for forms are using the old connection and error out when I open them

[June7]

Unfortunately, I am not well-versed in methods of connecting to SQLServer as I have never had to. Only link to Access backend and as long as forms/reports can find table and query names in Navigation pane, they work. So if you have code behind form that sets connection, provide the code for analysis. Sounds like need to replace CurrentProject.Connection with a valid connection string. Review https://accessexperts.com/blog/2011/...rosoft-access/