copy of database requires password

J

Jenn F

I created a database and copy it onto my server whenever I make updates to it
and have never had a problem opeing it before, but now it is requiring me to
supply a password. There has never been a password on it. I am using Access
2003. Does anyone know what happened and how I can fix it?
Thanks for any help.
Jenn F
 
A

Arvin Meyer [MVP]

Either someone is playing with your database, or it is corrupt. I doubt that
you were able to copy it to somewhere on the server which required password
permissions that you don't have. Does the password request have an Access
titlebar, or a Windows titlebar? If Windows, you need to contact your admin.

I suggest that you take a fresh copy of the database and ask the network
admin to give you a secure place on the server that only you and he have
access to. That way you can keep out prying eyes and folks playing where
they shouldn't.
 
J

Jenn F

It appears to be an Access titlebar. I wish I could get a new copy but the
original is 300 miles away on a laptop. None of my databases have passwords
and all other databases open fine, even previous copies of that one. The
database was created and is maintained on that laptop and I just keep copies
on my server.

The only other possiblity I can think of relates to how it is normally used:
the database is usually opened by SQL code from an AutoCAD drawing. I have
had problems opening it straight out before (though never this problem).

This is a small company - there are no passwords to access the server or any
files on the server.

All of the other files that I copied at the same time (Excel, Word) are fine
- just this one has the problem.

Any ideas?
 
A

Arvin Meyer [MVP]

It sounds like the file is corrupt. That can happen if someone tried to open
it in Word or Excel with an Autosave turned on, or if the database isn't
split and multiple people are opening the same copy. Here's some tips on
trying to fix it, but if it was opened with Word or Excel, they won't work:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Top