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...b;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...b;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
"Jenn F" <(E-Mail Removed)> wrote in message
news:3EBB0AFB-2869-4A2D-B033-(E-Mail Removed)...
> 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?
>
> "Arvin Meyer [MVP]" wrote:
>
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> "Jenn F" <(E-Mail Removed)> wrote in message
>> news:E1A62C80-BC35-4EEB-9299-(E-Mail Removed)...
>> >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
>>
>>
>>
Similar Threads
