Errors with Windows Server

[webboy1]

I recently took over the development of a website. The website has a forum on it, and did so when i took over. The forum is a downloaded script, which the previous developer edited to look like the site.

Anyway, the whole site is now finshed and seemed to be working fine..........until we shipped it onto the clients server. Suddenly the forum doesn't work. And, it i'm finding it hard to find a cause, as i didn't write the script..........and its a bit on the messy side.

My intial thoughts are that it is not to do with the script, but with the setup of the windows server. My reason for thinking this is that i have had the site running fine both locally from my harddrive and also from our company windows server online.

We initally got errors saying:
'Operation Must Use an Updateable Query' - The microsoft site says the most common reason for this is server permissions. The permissions have now been fixed, but now we get 2 errors:

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

and

Provider error '80004005'
Unspecified error

has anyone come across these before, and know of any fixes?

All help appreciated.

Cheers
Webboy

[txbakers]

I think it's still a permissions issue.

Make sure the database has permissions for IUSER and the tree above also has the permission.

Other than that, it's the old standby MS remedy - reboot.

[korkus2000]

>>[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

That error is most commonly caused by having the database open while trying to run the asp. If you are viewing the database while you are getting this error. Close it.

[txbakers]

Yes, I remember that one. If the DB was open in design view it would get that error, but the table view worked fine and you can see your changes instantly.

[webboy1]

Cheers Guys, we managed to get it fixed. I had read about the error somtimes being caused because the Database was already open on the server when an internet user is trying to access it.

This turned out not to be the problem, but i do have a question about it ........... if the database being opened stops any users accessing it, does this not mean that only one user can use it at a time? Probably not, but i thought i would just check?

The problem we were having was permissions. We had only given access to the sub folder where the DB was being held. We had forgotten to allow access to the folder where the sub folder was being saved.

Problem solved........thans though, your help is appreciated.

Webboy