We run SQL 7.0 on Win2k Adv Server for a small forum - 50 members. After a hardware problem last week, we had to reinstall the o/s and everything again. The SQL reinstall was a PITA so we are considering ditching the SQL 7.0 server and going with an Access database for the forum.
Is it simple enough change the connection string, export the SQL database into Access format and everything will work ?
I did a search and people seem to go Access to SQL, not the other way around :-)
Install a clean Snitz forum in an Access DB. Then use DTS to export the SQL Server data, making sure that for all tables the transform column is set to delete existing records and enable identity insert is checked. I've posted about it before as well, so you can follow Doug's suggestion and try a search.
Topic Locked
Posted - 06 November 2003 : 00:59:34
