Reasons: Access database was in excess of 600Mg, and with 9 people wanting to use the same database it was completely necessary.
Advantages, much easier to administer, backup and control. Can't really think of any obvious diadvantages, we've experienced no (very little slowdown) and no problems.
The main problem that I had when converting was getting the right owner/user permissions when creating the schema file for QARun, it depends on how reliant on security you are. Also bear in mind that every user who has access to QARun might be able to delete all your scripts, so backing up definately important.
If you hit any problems give me a shout, I've done the conversion on several databases now. firstname.lastname@example.org
<BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by coxsteph: Can't really think of any obvious diadvantages ..<HR></BLOCKQUOTE>For a single user local Access database might be significantly faster (depending on network traffic).
[This message has been edited by Yury (edited 12-17-2001).]