it is possible to add a custom interface for msaccess that links it to sql server, so users can do this directly. I don;t know how to do this as I don;t do VBA, but we have a customer that does this very thing. He runs msaccess locally and uses it to conenct to his hosted database and manage data and sync with his local access db
On Mon, Aug 13, 2012 at 6:12 PM, Captain Obvious <[email protected]>wrote: > > Maybe this: > > - have end-users upload entire MDB. > - in uploaded MDBs insert links to SQL Server tables. > - execute a set of Insert queries to copy data from MDB tables to SQL > Server tables. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
