Need help opening a database that only opens in read only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a database here that opens only in read only.
I checked folder/subfolder/database properties and none is set at read only.
It says, "The database New Products is read only"
I try opening it direct and through a shortcut and to no avail. It was on a
shared network drive and never had this problem before. I tried copying it
off the network and putting it on my PC. The boss and I checked permissions
and everything looks fine. He's counting on me to find a solution. I browsed
here once before about a similiar situation and found an answer. It told me
to go to start/run path of access and something else after that. I searched
for 2 hours now and can't find an answer!
Please help!
 
jeridbohmann said:
We have a database here that opens only in read only.
I checked folder/subfolder/database properties and none is set at
read only. It says, "The database New Products is read only"
I try opening it direct and through a shortcut and to no avail. It
was on a shared network drive and never had this problem before. I
tried copying it off the network and putting it on my PC. The boss
and I checked permissions and everything looks fine. He's counting on
me to find a solution. I browsed here once before about a similiar
situation and found an answer. It told me to go to start/run path of
access and something else after that. I searched for 2 hours now and
can't find an answer!
Please help!
Click to expand...

Do you have create file permissions on the network folder? If you don't
have permissions to create, modify, and delete new files in the folder then
Access cannot properly manage the LDB file that accompanies the use of an
MDB file. When the LDB file cannot be created you end up with a read-only
session.
 
Rick, thanks for answering. I double checked and all permissions on the
folder are correct. I have full permissions. I even tested it by creating a
new database in the folder. Then I deleted it. I even took a copy of it and
am trying to work on this problem locally to no avail.
 
It sounds *awfully* as if the mdb file has "read only" ticked, in its
Windows properties. Make sure you're checking that property of the mdb
file - not the shortcut to the mdb file.

HTH,
TC
 
TC,
I check the actual folder and the MDB database and neither is checked as
read only in the properties. I have another database in the same folder and I
can open that okay. I did actually check the real time mdb and not my
shortcut. Thank you.
 
jeridbohmann said:
I check the actual folder and the MDB database and neither is
checked as read only in the properties. I have another database in
the same folder and I can open that okay. I did actually check the
real time mdb and not my shortcut. Thank you.
Click to expand...

Is this database secured? What is in the target of the shortcut?
 
i am having the same problem as well. i created the database and it's put on
our server. i can open, modify, delete whatever i want on the database.
however, if another user open the database, it says the database is read
only, and when he clicks on the switchboard, it says cannot locate the file.
please help!!!
 
Michelle said:
i am having the same problem as well. i created the database and it's
put on our server. i can open, modify, delete whatever i want on the
database. however, if another user open the database, it says the
database is read only, and when he clicks on the switchboard, it says
cannot locate the file. please help!!!
Click to expand...

Check the windows permissions on the folder where the mdb is. Users need
read/write/create/delete permissions on the folder, in order to create and
delete the associated ldb file.
 
Did you ever get your problem solved?
I have sort of the same thing... If I open my secured, front-end back-end
networked database on my system or one colleage's, (me 2000 and she xp, both
with access 2003), logged into the network as me and logged into the database
as me (my username and password), the database runs properly. But, a third
person's system (xp w/ access 2003) if I log in to the network and then log
into the database as me, a window pops up and says... Read-only.... Is this
an access 2003 option ? What do you think?
Thanks..
Steve

PS I am not trying to double post, but maybe the individual users have
"Notify me of Replys" checked.
 
Did you ever get your problem solved?
I have sort of the same thing... If I open my secured, front-end back-end
networked database on my system or one colleage's, (me 2000 and she xp, both
with access 2003), logged into the network as me and logged into the database
as me (my username and password), the database runs properly. But, a third
person's system (xp w/ access 2003) if I log in to the network and then log
into the database as me, a window pops up and says... Read-only.... Is this
an access 2003 option ? What do you think?
Thanks..
Steve

PS I am not trying to double post, but maybe the individual users have
"Notify me of Replys" checked.
 
Back
Top