ADO + MSAccess problem

[Gigatech]

Hi, I use Delphi 7 and MSAccess 2002. I'm trying to connect to my database using ADO. I created the ADOConnection (ADOConnection1) and it works fine when I test it. When I add an ADOTable, I set the connection property to ADOConnection1 and when I select the table changing the TableName Property an error message appears: Invalid ENum Value and the aplication crashes. What is it ?

Best regards.

 

[RyanEK]

Hi,

Does your connection string look like the following?

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=files/customers.mdb;Mode=ReadWrite|Share Deny None;Persist Security

If so... delete the mode string.

Ryan