DB opens in read only mode

  • Thread starter Thread starter Geoff Tegerdine
  • Start date Start date
G

Geoff Tegerdine

Using Access200, I've created a DB application with a large amount of VBA
stuff in it. It runs fine on my machine, but when I copy it onto another PC
it will only open in read only mode. I've looked at the security options but
don't understand how to change them. My DB originally had a password but I
removed it. Both PCs are running on Win98 SE. Advice will be much
appreciated. TIA

Geoff
 
Did you copy it via a CD-ROM? CD-ROMs are, of course, read-only, so the file
comes across marked read-only. Find the MDB in Windows Explorer, right-click
on it, and check its properties. If the read-only box is checked, uncheck
it.
 
I transferred using a ZIP and e-mail. I've checked that the mdb file is
'archive'
 
Geoff,

The problem might be your system.mdw file, which defines your system
security privileges. Try renaming the users .MDW file, then pasting the one
from your machine in and then reopen it. See if that makes any difference.

The code you wrote in VBA should not matter, as long as you and your end
user are running the same copy of Access. It will compile either way.
Another thing you could try is to make an MDE file (Tools - Database
Utilities - Make MDE file) and transport the MDE and MDB files over. See if
the MDE file runs and if it is read-only. The MDE makes the design elements
and VBA code inaccessible.

HTH,

Gary
 
Thanks for the suggestions. It will take a few days to try, but I'll be back
with news of what happens. Thanks for your continued support.
 
Thank you for your help - it was the system.mdw file that did the trick and
the mdb file works fine.
One last question please. Is the change of the system.mdw file likely to
impact any other software? or is it's use confined only to Access files?
 
I seem to be having a similar problem. A db I created in Access 2002 (in
Access 2000 format, by default) opens fine on my computer, but when other
users attempt to open my db the database window with the db objects (tables,
queries, etc.) doesn't appear. The only indication the db is open is that
the db name appears at the bottom of the windows menu.

I can't seem to locate an MDW file on my system, and it doesn't seem
practical to substitute my MDW file (if I do find it) with other users' MDW
files. There will be many other users, not all of them at the same location.
If the MDW file is the culprit, is there something I can do to modify my MDW
file so others can open my db? Thanks.

Bob
 
Back
Top