Prev: Intermittent problem in data transfer MSAccess to Oracle using VB
Next: Problem automating page in IE 8
From: Carl on 28 Jul 2010 10:15
Here's the latest...

I compacted and repaired the MSAccess database after backing it up and
also checked the 'Compact on Close' option under Tools>Options>General.
It's a fairly small database so the compact runs in under 5 seconds. My
VB routine ran to completion this morning, so will continue to monitor
it, but thanks for everyone's suggestions and for the links provided.
While it's working I will incorporate your suggestions so that if and
when it breaks again it may be easier to track down the underlying cause.

Again, your help is greatly appreciated, as always.
Carl
From: Carl on 29 Jul 2010 10:12
Very cool Paul. I didn't know you could do that. Thanks for the tip!

Paul Clement wrote:
> On Tue, 27 Jul 2010 14:24:08 -0400, "Phil Hunt" <aaa(a)aaa.com> wrote:
>
> � Paul, I am curious what the SQL stmt looks like with connect striing in it .
> �
> �
>
> With a connection to the Access database this worked for me:
>
> INSERT INTO [ODBC;Driver={Microsoft ODBC For
> Oracle};Server=ServerName;Uid=userID;Pwd=password;].[ORDERS] (ORDERID, CUSTOMERID, EMPLOYEEID)
> SELECT ORDERID, CUSTOMERID, EMPLOYEEID FROM ORDERS
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
First  |  Prev  | 
Pages: 1 2
Prev: Intermittent problem in data transfer MSAccess to Oracle using VB
Next: Problem automating page in IE 8