Database ACCESS 97 to linked server SQL 2000

[youssef]

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

 

[sguslan]

Microsoft Jet 4.0 OLE DB is the correct provider .. use it .

 

[youssef]

When I clicked on the Table, a message error :

Error 7373 : could not set the initialization properties for the OLEDB provider "Microsoft Jet 4.0 OLE DB "