Override Data Link Between MS Access File and SQL Server

I have a fairly standard database sitting on SQL Server. To manage the data (instead of building a solution using the IDE), I connected to the database using MS-Access (4 users showed up in the beginning. I'm testing the concept and a complete solution can be developed once there is enough data).

* MS-Access> New File> Project Using Output ... * Specify SQL Server * Create Forms, etc. The data is now available / editable in Access.

Considering sql database won't always work on my laptop, the link to the access server file should change.

How do you change / override the link between the access file and the SQL server? Is it possible?

0


a source to share


1 answer


Go to File> Connection to open the Select Data Source window.



+1


a source







All Articles