Have few MS Access frontends - mdb's, which has many SQL Server tables as linked tables, and MS Access tables inside. I have to migrate them (SQL Server tables) from one SQL server to another and to change linked tables properties in MS Access, related to MS SQL Server's tables.
The easy way is to move your sql server tables, click "Linked Table Manager", select all (or just the moved tables) and tick the "prompt for new location" box. Press ok and you will be asked to relink the tables.
Tools > Database Utilities > Linked Table Manager
This would be the perfect solution.
Just have to have administrator privileges (if the menu option Linked Table Manager is not active), cause the database is read only for all other but admin group, and few users.
you have to let that computer that is storing the data know how the use can us the file read/write talk to you IT person
tell then Your would like all user to have read/write and delete on that folder
Get them to share it with the $ at the end of the name
This will make i hidden What people can't see they can't delete.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.