FAQ: Which Access Database Ships With This Forum? - Posted (1961 Views)
Average Member
heptite
Posts: 547
547
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. <
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Average Member
heptite
Posts: 547
547
Question: Is there somewhere I can download an empty Access 2000 database to use with Snitz Forums?
Answer: Yes. A link to an Access 2000 database to use with your forum can be found on: http://www.snitz.info

http://www.snitz.info/mods/sfv33_access2000.zip


Additional support files - http://www.snitz.info
<