Could not use ''; file already in use in access database

Question

hi

i have site with access database
that work very good on local
but when i send it on host , when i want add a test or picture i see the error :

 Operation must use an updatable query

i set permisson of my database to full
ofcourse my database is beside the root of my site not in a folder

and also i set permission to folder include database that means wwwroot because my database is beside root of my site

and that error be disappear but now i see another error :

  Could not use ''; file already in use

i search my codes of any page and i find any opened connection that don't close

then how must i do for this error ?

thx

Kirtan Patel · Answer

Friend Do like Below to resolve the Problem ...

sam richard · Answer

This error occurs generally due to corruption or damage in MDB Access database. If you are willing to fix this by your own get download third party MDB FiX Software on your system right now. To read more; http://www.mdbfix.net

theLizard · Answer

This is the reason you are having problems http://support.microsoft.com/kb/289681 -- My advice is that you move away from access databases hosted on a remote server try MySql or MS SQL you will get much better performance.

Kirtan Patel · Answer

Friend I see your Site is Hosted on remote Computer you need to Get Help of your WebHost in this case to change that IUSER permission.

Bahar Jalali · Answer

ohh i setup iis and IUSER be appear and i do the security works and then upload my database on the host but the error is appear too.. don't solve how can i do? mysite : www.mardavij-pet-special-clinic.com for example u can go too register page and test it and see the error that 's name is ?????

Kirtan Patel · Answer

Friend Actually IUSER_PCNAME is the user type which views the site on Internet .so we have to set permission of IUSER account follow the below article for more info . http://support.yessoftware.com/kb_article.asp?article_id=4

Bahar Jalali · Answer

hi thx i do that work and i find security tab but i don't find IUSER there isn't this record in the advance (find in advance) how can i do ? can i set the other users? and second my question is that my site be successful in local and when i put this on the net this error appear! now if i set the security tab  and then reupload the database  the error will disappear??

Kirtan Patel · Answer

So to see and unhide the Security tab just use the following steps: Launch Windows Explorer or My Computer. Click on the Tools at the menu bar then click on Folder Options. Click on View tab. In the Advanced Settings section at the bottom of the list uncheck and unselect (clear the tick) on the Use simple file sharing (Recommended) check box. Click OK. Security tab is available only to Administrator or users with administrative rights. So make sure you login as one. And security can only be set in an NTFS partition.

Bahar Jalali · Answer

my database is on host on the net! how can i set this properties to that??! in local too my database property has no security tab just General and summery tab how can i do?

Lalit M · Answer

this type error may be cause database security . try to right click->your database->properties->security tab and add IIS user in the security permission to have write full /read/write access control.

Raghavendra U · Answer

me also faced same problem then i change the access database file directory into another localdrive(D)