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