Access97 and XP

  • Thread starter Thread starter Max Murison
  • Start date Start date
M

Max Murison

I need to link an Access97 front end to an XP back end on our network to
read-only data.
I have tried ADO and ODBC with an appropriate driver but get the error:

Unrecognised DB format

I have tried this with a local XP DB and get the same result.

Grateful for any suggestions,

Max
 
Max Murison said:
I need to link an Access97 front end to an XP back end on our network to
read-only data.
I have tried ADO and ODBC with an appropriate driver but get the error:

Unrecognised DB format

I have tried this with a local XP DB and get the same result.

Grateful for any suggestions,
Click to expand...

AFAIK it can't be done. Access can read data files from older versions but not
the other way around.
 
Few, if any, products are capable of reading the file formats of newer
versions (assuming that the file format changed). It's difficult to built
clairvoyancy into applications...
 
I have tried ADO and ODBC with an appropriate driver but get the error:

If I try ADO (or DAO 3.6), I can read an XP back end from a 97 front end.

I can't use Linked Tables to connect to an XP back end,
and
I can't connect using ODBC to an MDB of any version.
and
I can't bind a form to an XP backend.

So I guess that is probably what you meant.

However, (which is a lot more work) I can read from a DAO 3.6 recordset,
write the values to form, then read the values back from a form, and
write them to a DAO 3.6 recordset.

(david)
 
Back
Top