Re: Access automation

2007-02-01 Thread Paul Newton
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! g Yes, go on Jeff, please. Pretty please !

RE: Access automation

2007-02-01 Thread Jeff Johnson
-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. Very straight

Access automation

2007-01-31 Thread Paul Newton
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 contains 2

RE: Access automation

2007-01-31 Thread john harvey
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 so far is oAcc = CREATEOBJECT

RE: Access automation

2007-01-31 Thread Jeff Johnson
-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

RE: Access automation

2007-01-31 Thread john harvey
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 Subject: Access automation Hi

Re: Access automation

2007-01-31 Thread Paul Newton
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 (ii)

Re: Access automation

2007-01-31 Thread Paul Newton
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 to

Re: Access automation

2007-01-31 Thread MB Software Solutions
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! g -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com