I have built a portable Access app to use for our sales team. Because of the security needed our app must be an executable (no linked tables). When our sales staff return from the road I would like to update their app with the new commodities pricing on our SQL server. Is there a simple routine to mirror the sql server tables, updating the app, or is the only option to link all the tables and write a ton of sql update queries?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql Checkout, table update
- Thread starter jibberski
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question