Hello - I've been migrating an Access 365 application back end to SQL Server 2019. So far, I have:
1) Installed SQL Server 2019 on a HyperV server running Windows Server 2016 (where I am the administrator).
2) Migrated the application backend to to a database in that instance.
3) Created a File DSN on my development pc (where I am the administrator) that successfully connects to the SQL Server db.
4) Used that DSN to to re-link the tables in the application front end
Everything seems to be working fine.
But now when I copy that re-linked FE and DSN over to a user pc (where I am logged as the pc's user), the tables no longer show up in the FE.
When I edit the DSN, the "Change default database to:" check box is not checked, although it seems to remember the database name.
When I re-check it, and re-select the database, the connection test is successfull, I save the DSN, go back into it, and the default db is gone again.
What's happeneing here?
(I set up the Domain User Login with the "Public" role and membership)
Thanks in advance.