Did you get a chance to look into using linked tables yet? If you have your data stored on the network e.g. \\MyDataLocation\MyData.mdb which will hold all your tables, and the Forms databse with all your queries and macros that your users click on e.g. c:\temp\MyForms.mdb. Once you link the...
To make sure you are updating the correct data; I would first separate the forms from the actual data. Then have your users download the mdb/mda, MyForms.mdb that holds the forms that are linked directly to your odbc data source MyData.mdb which is stored on your server.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.