STRANGE database access error - file in use

[NeuroMancerC]

Hi,

 

I desperately need to solve this problem i'm having.

 

I've got an asp.net project with several aspx pages. now, it starts up on home.aspx, then i click on login, and login, then it redirects me back to the home page, where i click on "my account", then when that page loads, it tells me "OleDbException (0x80004005): Could not use ''; file already in use".

 

Now i have search for a solution to this error, but everyone seems to think its a permissions problem. I cant see how this is possible because my login page reads the database perfectly and even my register form accesses AND WRITES to the database perfectly.

 

If you want to look at my project, i have uploaded the files to:

http://www.dmgstudios.co.za/stark/aeas.zip

 

if u need the images, u can find them at:

http://www.dmgstudios.co.za/stark/images.zip

 

someone PLEASE tell me what the hell i'm doing wrong.

 

>>

[eramgarden]

copy and paste :

OleDbException (0x80004005): Could not use ''; file already in use

 

into google and click "groups". The first 2 search results might be of help.

[NeuroMancerC]

Thanks for replying,

 

Ive already been to those two sites, but i dont see how it could POSSIBLY be an issue regarding permissions because as i have stated previously, i'm ALREADY ABLE TO ACCESS the database!!! It just freaks out when i go from login, to home, to modify page. (the modify page doesnt modify anything yet, just reads from the db) but i get the error on the "cn.open".

 

Ive got 4 files in total that access the database, and they do it consecutively, its just this specific instance that causes a problem.

 

 

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

copy and paste :

OleDbException (0x80004005): Could not use ''; file already in use

 

into google and click "groups". The first 2 search results might be of help.

[noccy]

Hi!

 

Are you closing your connection properly when used for login etc?

[NeuroMancerC]

Hey noccy!

 

You wont believe this: I've considered that i wasnt closing the connection several times before, and after reading your comment, i went back to my code thinking "yes of course i have!" and there it was!!!! I CLOSED MY CONNECTION IN THE WRONG PLACE!!!! AARGGGHH!!! I feel like such an idiot!

 

Thanks alot! Hehhe.

 

Its pretty amazing that all the solutions offered to me had to do with permissions. (and i do mean ALL).

 

ANyways, back to the grindstone.