I have been running WWF ( www.socweb.co.uk ) for around 2 years now and it is great.
Background: We have now around 65000 posts from 2600 registered users and the Access DB we have been using is now grown to 70mb is size. We changed hosts around 3 months ago to www.oneandone.co.uk and they are very quick - but the server keeps crashing. I am assuming we are taking up all our allocated resource
So I took the plunge and as we get a SQL DB with our package, I have installed a new SQL version of the forum (v7.6) . I hvae run the MSSQL setup script and can set up a blank database with no problems.
However, when I use the oneandone Access Import facility (you put the Access DB into a particular folder and it gets imported automatically) I end up with two copies of each table.
The tables are supposed to be overwritten if they have the same name, but they don't, and when I delete one copy of each table I am left with the blank ones from the set up script.
So I set up the blank wwwfDB again (deleting the whole SQL DB and starting with and empty DB), and then before I import the Access DB, I delete the tables.
However I then get the error messsage
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblConfiguration'.
This is really bugging me as I have spent the last week trying to sort it.
help?
Topic Options
Post Options
Thanks(0)
