-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: Wednesday, January 31, 2007 5:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Access automation
Tx Jeff
Jeff Johnson wrote:
>
> Paul: I have done this hundreds of times using ODBC.
MB Software Solutions wrote:
> Jeff Johnson wrote:
>
>> Paul: I have done this hundreds of times using ODBC. Very straight forward
>> and you can SCAN the access tables and write to the DBF.
>>
>>
>>
> So post some sample code for him, Jeff!
>
Yes, go on Jeff, please. Pretty plea
Jeff Johnson wrote:
> Paul: I have done this hundreds of times using ODBC. Very straight forward
> and you can SCAN the access tables and write to the DBF.
>
>
So post some sample code for him, Jeff!
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http
Thank you John but I did ask
> How can I get a count/list of the tables excluding the system tables
> (without iterating all of them to exclude the system tables) ?
>
>
john harvey wrote:
> I just checked the code in Access 2007 and found they are using 0 based
> arrays, so modify the code
Tx Jeff
Jeff Johnson wrote:
>
> Paul: I have done this hundreds of times using ODBC. Very straight forward
> and you can SCAN the access tables and write to the DBF.
>
That would be using SPT (SQLConnect and SQLExec) right ? And this would
be another approach - in addition to (i) ADO and (
i = 0 TO lntables-1
lctable=oacc.CurrentData.AllTables(i).name
IF OCCURS('MSys',lctable)=0
?lctable
endif
endfor
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
S
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: Wednesday, January 31, 2007 4:13 PM
To: [EMAIL PROTECTED]
Subject: Access automation
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc
if
endfor
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
Subject: Access automation
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc = CREATEOBJECT("Access.Application"
oAcc.OpenCurrentDatabase("MyDatabase.MDB")
LOCAL lnTables
lnTables = oAcc.CurrentData.AllTables.Count
This returns a value of 9 for lnTables but the MDB only contain
9 matches
Mail list logo