paradox

[let_me_in]

What is the database extension for Paradox databases ???? I am suppose to find out a Paradox database on a system and I do not even know if it exists there in the first place and i do not know the database file extension ??

Can somebody help me ....

[let_me_in]

ok, i figured it out on my own. but when i try to use this paradox database from vb (.db file) i get "External table is not in Expected format" error message. What does this mean ?????

[randem]

let_me_in


Being that you gave no information... How would you expect us to solve this problem? You could be using the wrong connection or the database is simply the wrong type or version for the connection.

Post code...etc...

[ECUnited]

Ok, I'm having the same problem.... here is my connection string and select statement. This code worked fine back in the Summer, and now when the user runs the program they get the [Microsoft][ODBC Paradox Driver]External table is not in the expected format. error..... HELP, please !!!:

Set UNIConnection = New ADODB.Connection
Conn = "Driver={Microsoft Paradox Driver (*.db )};" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=C:\;" & _
"DBQ=C:\;"

With UNIConnection
.ConnectionString = Conn$
.ConnectionTimeout = 0
.Open
End With

MySql = "SELECT * from Unovrec"
Set RsUnitime = New ADODB.Recordset
RsUnitime.Open MySql, UNIConnection

[randem]

ECUnited,

Many times when an app was working and there was no change to it and it stops working, this could mean one of two things.

1) Database corrupted
2) User installed something which overwrote the database components with different versions.

You can correct both:

1) Use the databases repair programs on the database
2) Reinstall the database componebts.

You can use the Automatic OS Updater to reinstall the correct database components.