I am using MS access 2003 to use several files with an Pervasive ODBC client.

Many files i can use, but some of them reject with the in the title mentioned error.

Can anyone tell me what is te problem here?

Thank you in advance.

Wkr.

WLangevoort

I haven't seen that before. A few questions:
- What version of PSQL are you using?
- What are you doing when the error occurs?
- Is there anything else to the message?
- Can you open the table in the Pervasive Control Center? If not, what error is returned?
- Make sure you use a User or System DSN. Access doesn't like a "File DSN".

- The version we use is v10.10.125
- The error does not come with every table. Only with some of the tables I get this error. For example when I connect a table to the database, but not every table in the database gets this error. If I open the table, I get the message: 'ODBC--call failed.' In every field I see '#name?' (in dutch) '#naam?'.
- No this is the complete message.
- Yes, I can open the tables that give an error in the PCC.
- I am using an User DSN.

Since it only happens on some tables, what's different about those tables?

Try selecting one field at a time until the error occurs.

It happens allready when i try to open those tables. So i can not select any field.

We moved our IT from servers at home to a new hosted environment.

Al tables have been rebuild to V10. and some of them, the bigger files, are compressed.

In the old environment I had no problems.

Thank you for your answers.