Originally posted by Colin Atkins
Using File>Connection in Access one can connect to database of choice. My application needs to be able to switch from local MSDE database to server-based Sqlserver database.
Can this be done via VBA ?
If not, can I distribute my Access application in any (secure) way that would enable a user to do this ?
Yes it can ... All that is required is to know the provider and the path and database name ... And optionally security requirements like a userID and password.
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.