Database ACCESS 97 to linked server SQL 2000

[yfbf]

Hi,

I have a SQL SERVER 2000,
I have a Database ACCESS 97 ( db.mdb)
I use Entreprise manager for link the DB ACCESS 97 by linked servers to SQL2000.
The only choice for PROVIDER NAME I have Microsoft Jet 4.0 OLE DB but for ACCESS 97 it is not good.

I don't have the possibility for chabge the DATABASE ACCESS 97 with other.

If anyone can help me or suggest a solution. Please contact me.

Best Regards

[antares686]

First did you try the Jet 4.0 item. It does support Access 97 and I have not had issues. See here for details.

OLE DB Provider for Jet (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_6a44.asp)

If you absolutely cannot get to work then work around by creating an ODBC entry to the Access file and use the Ole For ODBC driver.