Access 2002 connection to Paradox using ADO
Posted on 2003-12-07
Okay, I am trying to connect to a Paradox table with Access 2002 and would like to use ADO to do it, but I am not to familiar with ADO and can not find many sources of very useful information on ADO.
First of all the folder that I am using is: P:\ForACC and the folder and file that I am trying to connect to is: P:\Fleet\Fleet.db and another table I need to connect to is: P:\Fleet\lert.db. Can someone show me some sample code for connecting, copying records from these two tables, and then closing the connection? The records I need are from the Fleet table: VIN, Agency, Year, and lert and from the lert they are: Index and lert.
These two tables are on a Novel Network. Is it possible for me to create a user with access rights to all of the above folders and then have the ado connection use the username and password to gain access to the tables and records that I need brought in? Thanks for the help...