Unrecognized database format

[carlosparedes]

Hi guys

Sorry

I have tried Set rs = conn.Execute(SQL) still getting the same error. Changed the connection to ADO OLE DB and the error is now:
Error Type:
Microsoft JET Database Engine (0x80004005)
Unrecognized database format 'C:\Testlocation\data\TEST.db'.
Reformat database to paradox 4 but still getting the same error.

Thanks
Sandra

 

[xwb]

You are probably using the wrong ODBC driver or the paradox ODBC driver is not installed.

Click Start/Control Panel/Administrative Tools/Data Sources

Check if Paradox (*.db) is in the User DSN list.

If it isn't, you need to add it. Click Add... and select the Paradox driver. I don't really know what happens after that.

 

[tsuji]

To read-write paradox v4, you still need to install jet 4 service pack 5. Check out kb230126

http://support.microsoft.com/kb/230126

and the links therein.