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.

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! > Yes, go on Jeff, please. Pretty plea

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

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

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 (

RE: Access automation

2007-01-31 Thread john harvey
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

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
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

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 contain