Database is down using Access but connection string is correct

If you have already made sure that the FogBugz user has permissions on the database, then it is possible that you are experiencing a temp directory permissions error.

Follow the steps below to correct the problem.

Part I

Right-click My Computer, and then click Properties.
Select the Environment tab, and then click on any of the existing variables in the System section. Both the variable name and value appear in the text boxes of the System Properties dialog box (at the bottom of the dialog box).
Delete the variable name in the Variable text box and type in TEMP.
Delete the text in the Value text box and type C:\TEMP.
Click the SET button, and the variable is added to the System section.

Part II

Again, select any of the existing variables in the System section.
Delete the value in the Variable text box and replace it with the word TMP
Delete the value in the Value text box and replace it with C:\TEMP
Click the SET button, and the variable is added to the System section

Part III

Go to the C:\TEMP directory. Right click and choose properties. Select permissions. Ensure that your FogBugz account has Read, Write, and Change access. If the FogBugzis not listed, add it.

Part IV

You will need to REBOOT the server for these changes to take affect.