Access97 and XP

[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

 

[Rick Brandt]

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,

AFAIK it can't be done. Access can read data files from older versions but not
the other way around.

 

[Max Murison]

I thought as much. Yet another ploy from Microsoft to force users to
upgrade.

Max

 

[Douglas J. Steele]

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...

 

[Max Murison]

Very frustrating, since it can read various versions of other database
tables.

Max

 

[Douglas J. Steele]

True, but only versions that existed at the time it was created.

 

[david epsom dot com dot au]

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)

 

[Max Murison]

I have overcome this using ODBC.

Max

True, but only versions that existed at the time it was created.