Open up Access and create new database and do right click and open up linked database, and use the odbc and your have the table in access . Look up linked databases.
Is there a way to use ms access 2003, 2007 with read uncommitted record so that it does not lock SQL with updates.
Anyone know of a way to set this up.
We currently use sql replication and rather not have to use this.
For example if im in SQL doing mass update and open up table in access i...
We have about 30 applications and ODBC installed all over place for accessing database.
Trying to use SQL 2005 snapshots which is great however when users use ODBC and i rebuild snapshot we get errors with disconnects because the spid in sql has been removed.
Anyone know of a way to prevent...
Im trying to use snapshot in sql 2005 this works great the only thing is if someone is in Cognos impromptu looking at a report and at the exact minute the SQL builds the new snapshot which only takes 1 minute i get the error in cognos
Driver DBMSLPCN general network error which is caused...
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.