Setting an Access DB Back end to read-write, set as read only now 2

[gchaves]

Greetings!

I have an Access 2000 database which I have split to keep my back-end separate from the front end. Today, somehow, it has been set to read-only and I think this is what is causing some of my queries/macros (especially those that run delete and append queries) to not work any more.

I've looked at the Microsoft site and read the help files in Access and can't seem to figure out how to set the back end to read-write from read only? Any help would be greatly appreciated.

Thanks,
Greg

 

[traingamer]

Do you or your users have 'write' access to the directory where the back-end is located?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Hakala]

Find the back end file in Windows Explorer (or similar program), right-click on it, choose Properties, and uncheck Read-Only?




Michelle Hakala

http://www.winebird.com/

 

[gchaves]

I have access to it and it is still coming up read-only. Any ideas?

 

[gchaves]

I did right click and select properties. Read-Only is not checked.

 

[Hakala]

Hmm....

If you haven't already, copy the file onto your own drive, re-link your tables and see if your copy is Read-Only.


Michelle Hakala

http://www.winebird.com/

 

[gchaves]

it's going to take 43 minutes to copy over, especially over a wireless connection...but I will give it a shot.

 

[Hakala]

That should tell you if it's really the file, or the server. Good luck!


Michelle Hakala

http://www.winebird.com/