Forum Moderators: open
The error I get from the page I've set up to test the connection is:
"The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."
Doing some research I saw this solution ...
"This is the server side problem. You need to contact your ISP about this problem. To fix this problem on server, NT administrator needs to set the database to read/write attribute for browser."
Now, i have no idea if this is applicable or not, but if it is, how do i do this (set the attributes of the DB)?
Otherwise, what could the problem/solution be?
I set up a DSN for the connection thinking that that may simplify things, but it is still the same problem.
A disclaimer: I am very very new to asp/database programming, so if an answer seems too obvious to mention...it just may be right (i have no idea what i'm doing! ^^).
TIA!
Are you using XP? if so then this is how i solved the problem (after some painstaking research)
1st.....
navigate to the folder where the database is stored, and then on the top bar go to
Tools.....Folder Options......View......
Then navigate to the bottom of the list, there should be an option 'Use Simple file sharing'
this should be checked, but you want it UNCHECKED. click ok.
What this does is create a new Tab called 'security' when you right click in a window where
your files are stored.
2nd......
Right click in the window, Properties, click the Security Tab
In the window there will be a section called 'Group or user names' click on your name, then
in the window below titled 'Permissions to administrators' you will see what permissions you have.
When i did first looked, i didn't even have read/write permissions on my own PC
What you want to do is allow yourself full control. This solved it for me, if this is the same for you then it might well solve it for you
too, you might need to allow full control or whatever you wish for the other names in there aswell.
Hope this helps, if it doesn't you can easily put them all back to what they were
Tom
