Cannot open the Access 2007 database
in [General]
|
Prev: Counting Days between two Dates excluding weekends
Next: emailing multiple forms w/one command button
From: A. J. on 11 Mar 2010 15:01 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 11 Mar 2010 15:57 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 13 Mar 2010 12:25 "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 16 Mar 2010 09:58
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. > > |