Hi I expect this has been covered but I could not find any articles.
I have a small Snitz forum which has always been very slow. It often times out. Theres not may records, less than 300. I use an access 2000 database I would like to update and improve the site. I have tried copying and pasting the data from the old tables to the new tables but when I try to run default.asp
I get the error Type mismatch: 'recForumCount'
I wonder is copy and paste of columns OK for data transfer
What old database and what new database are you talking about? If you have an old forum version, just stick with the old database and run setup.asp for the new version code.
You should also compact the database. Do that from Access.
Thanks for the quick reply, The old and new databases are both access 2000 but I notice that the new tables included in the download have some extra fields in them.
I was trying to copy the columns from the old into the new table supplied with the download.
I will have a go at using the old tables with the new files.
Any new tables needed will be created by setup.asp, don't worry. Snitz new versions always allow for database upgrade from prior versions, so no need to do it by hand.
Topic Locked
Posted - 11 August 2004 : 06:17:43
