Access, SQL and VB

[EscapeUK]

I have a VB app (uses MTS) which saves data to a SQL DB with no problems at all. However when I run a long MS access Query against the DB and try to save using my VB app the VB app bombs out.

Seems to be a problem in running the MS Access (uses SQL ODBC connetion) and the VB app at the same time. I guess people must do this all the time.

Any ideas

 

[MichaelRed]

Can't say I "do this" all the time. In fact, there appears to be little reason to instantiate the entire Ms. Access process just to run a query against the table. Just defining the db and tbl is sufficient, as the Jet db enging (basis of Ms. Access) is seperate from Ms. Access and is actually available directly from VB. SQL ODBC being the sloooooooooooest of all possible methods probably puts a strain on the entire chain, and may be the cause of the problem.

I generally use the 'direct' connection for Ms. Access tables, however RDO or ADO connections would probably be better than the SQL ODBC process.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[EscapeUK]

Ok how do I do the above. I am new to this