ODBC to Jet OLEDB

[OJM]

Hi,

I've just been told about this topic - http://support.jodohost.com/showthread.php?t=3146

What I was hoping would be that someone might be so kind enough to point out what changes I need to make in one of my Access DB connecting files, please?

The file I wish to change is the one attached.

Thanks so much for your time!

Oli

 

[JoCald]

Replace the following:

Line 33:
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0; "

Line 36:
DSNtemp=DSNtemp & "Data Source=" & server.mappath("guestbook.mdb")

 

[OJM]

Ah right, it's like that!

Thank you!

Just for anyone who has the same query...I had to upgrade the mdb to Access 2000, and it all works fine!