From: A. J. on
I tried to open an Access 2007 program, there is a Microsoft Office Access
message box appeared and said “The expression you entered has a function name
that Microsoft Office Access can't find”, after I click on the OK button,
there is an Action Failed message box, the information on the message box are
Macro name: AutoExec, Condition: True, Action Name: RunCode, Arguments:
LoadDatabase() and Error Number: 2950. After I closed the message box, none
of the form opened. When I clicked on any of the tables or forms, the error
message said “ L:\fileName.mdb is not a valid path”. I tied to open the
Forms on the Design View, and message box said “The Form is linked Form,
whose design can't be modified. I tried to link the database trough the
linked the table manager, but it did not work. Could someone help for this
problem?
Thanks.

From: Jerry Whittle on
1. Make a copy of the database file now.

2. Next try to open the database while holding down the Shift key. See if
that works. If so look for an Autoexec macro and either delete it or fix what
is wrong with it.

3. If that doesn't work, the database may be corrupt. Try doing a compact
and repair on it. If that doesn't fix it, here are some resources:

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
http://www.rogersaccesslibrary.com/forum/default.asp?C=1
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"A. J." wrote:

> I tried to open an Access 2007 program, there is a Microsoft Office Access
> message box appeared and said “The expression you entered has a function name
> that Microsoft Office Access can't find”, after I click on the OK button,
> there is an Action Failed message box, the information on the message box are
> Macro name: AutoExec, Condition: True, Action Name: RunCode, Arguments:
> LoadDatabase() and Error Number: 2950. After I closed the message box, none
> of the form opened. When I clicked on any of the tables or forms, the error
> message said “ L:\fileName.mdb is not a valid path”. I tied to open the
> Forms on the Design View, and message box said “The Form is linked Form,
> whose design can't be modified. I tried to link the database trough the
> linked the table manager, but it did not work. Could someone help for this
> problem?
> Thanks.
>
From: De Jager on

"A. J." <AJ(a)discussions.microsoft.com> wrote in message
news:0B820C6B-417D-4C41-BDD8-DF06A98112FE(a)microsoft.com...
>I tried to open an Access 2007 program, there is a Microsoft Office Access
> message box appeared and said “The expression you entered has a function
> name
> that Microsoft Office Access can't find”, after I click on the OK button,
> there is an Action Failed message box, the information on the message box
> are
> Macro name: AutoExec, Condition: True, Action Name: RunCode, Arguments:
> LoadDatabase() and Error Number: 2950. After I closed the message box,
> none
> of the form opened. When I clicked on any of the tables or forms, the
> error
> message said “ L:\fileName.mdb is not a valid path”. I tied to open the
> Forms on the Design View, and message box said “The Form is linked Form,
> whose design can't be modified. I tried to link the database trough the
> linked the table manager, but it did not work. Could someone help for
> this
> problem?
> Thanks.
>

From: A. J. on
Thanks a lot for your information. I have tried steps 1 and 2, it did not
work.

How can I do the compact and repair?

Thanks!


"Jerry Whittle" wrote:

> 1. Make a copy of the database file now.
>
> 2. Next try to open the database while holding down the Shift key. See if
> that works. If so look for an Autoexec macro and either delete it or fix what
> is wrong with it.
>
> 3. If that doesn't work, the database may be corrupt. Try doing a compact
> and repair on it. If that doesn't fix it, here are some resources:
>
> Tony Toews has an excellent web page on database corruption.
> Http://www.granite.ab.ca/access/corruptmdbs.htm
>
> Allen Brown also has excellent info on corruption.
> Http://allenbrowne.com/ser-47.html
>
> I have a white paper in a Word document named Fix Corrupt Access Database.
> Click on "Whittle, Jerry" on this page:
> http://www.rogersaccesslibrary.com/forum/default.asp?C=1
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "A. J." wrote:
>
> > I tried to open an Access 2007 program, there is a Microsoft Office Access
> > message box appeared and said “The expression you entered has a function name
> > that Microsoft Office Access can't find”, after I click on the OK button,
> > there is an Action Failed message box, the information on the message box are
> > Macro name: AutoExec, Condition: True, Action Name: RunCode, Arguments:
> > LoadDatabase() and Error Number: 2950. After I closed the message box, none
> > of the form opened. When I clicked on any of the tables or forms, the error
> > message said “ L:\fileName.mdb is not a valid path”. I tied to open the
> > Forms on the Design View, and message box said “The Form is linked Form,
> > whose design can't be modified. I tried to link the database trough the
> > linked the table manager, but it did not work. Could someone help for this
> > problem?
> > Thanks.
> >