Home > Archive > MS Access Multiuser > January 2006 > ODBC SQL table update









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ODBC SQL table update
Patrick Salsich

2006-01-06, 3:25 am

I have an access mdb with ODBC links to a SQL table on a remote server. I
can update records in the SQL table by just typing. I also wrote some
update queries using joins between local table and the SQL table. Works OK
but slow. So now I want a fast and easy way to update larger groups of
records in the SQL table based on matching records in the local table. Need
speed for this. Don;t want to use a stored procedure. Any ideas? Thanks

Patrick


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com