I wrote a ASP script (updateDB.asp) for upgrading Access database from version 7.x to version 8 beta1. I have not tested with SQL Server or other versions, I think it will probably fail with them.
You can download the script from
here
Update procedure:
1. Install version 8 beta1 package and test if it works ok with the default db.
2. Put your old 7.x mdb file in the forum8\database folder. Make sure you have a backup copy of your old database before proceeding.
3. Open forum8\includes\database_configuration.asp and edit the variable strDbPathAndName to refer to the 7.x mdb file.
4. Put updateDB.asp file in the root of your forum folder (forum8\updateDB.asp).
5. Run forum8\updateDB.asp , the script will change the structure of the db and insert some required data.
6. After the script finishes, you will have a working v8 forum.
7. Probably you won't be able to see the forum titles on the main page especially as a guest. This is because the permissions system is changed.
You will need to examine and set group permissions on the forum administration area manually.
I have upgraded my v7.96 database successfully, hope it works for you too.
Edited by Cem Alacayir - 16 January 2006 at 10:29am
Topic Options
Post Options
Thanks(0)
I will referer my 
I well test today
Microsoft JET Database Engine (0x80040E07)