Question: Which version of Microsoft Access .mdb file ships with the forum? Access 97 or Access 2000?
Answer: The .mdb file that ships with the forum is a Microsoft Access 97 file. You can convert it to Access 2000 and use it with no additional modifications to the database.
NOTE: Your provider may not have the proper settings to use the strConnString for Microsoft.Jet.OLEDB.4.0
Example strConnStrings:
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\forum.snitz.com\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/dbroot/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
The third example may not work, but the first should after you uncomment out the line and put in the path to your database file.
<