I have a database that has an SQL Server backend and MsAccess front end. I load the front locally to the users PC's. In the front end when I make the ODBC connection should I save it as a File or Sytem DSN on the server? I am in the process of setting up an auto update feature on the Front Ends that would keep the users local versions in sync with the Master Front End on the Server. I want to make sure I don't loose the ODBC connection each time it is updated. Can this be done?
Thanks,
Phil
Thanks,
Phil