MS Visual Basic Runtime Error 3001

John Wilson
John Wilson used Ask the Experts™
on
I have a split Access Database, both sides are house on a network drive.  It is used by me and one other person.  I can run it fine on my desktop, but I recently had to reload the other user's system and since then that user has been unable to run the application.  The app has several forms used for entering data that will not execute and she gets the error "MS Visual Basic Run time Error 3001: The Microsoft Office database engine could not find '1'.  Make sure the object exists and that you spell its name and the path correctly".  

Again, if I run this from my system or any other system, it runs fine.  I only get this error on this particular user's system.  I have checked and made sure the front end and back end are linked.  I know this is probably a duhhh kind of problem, but I am stumped.  Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Is '1' the name of a table?
Is the back-end SQL or MSAccess?
John WilsonVP of Administration, Safety, & HR

Author

Commented:
1 is not the name of anything in this setup.  It is a MSAccess database on the back-end
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
On that system, open the VBA editor, the Tools>>References. Look for any that are listed as:

**MISSING <SomeReferenceName>

mx
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
Could you post the SQL statement for one of the forms?
Database Architect / Application Developer
Top Expert 2007
Commented:
Also, on that system ... if there are no missing references, then run this procedure - again, on that system:

Follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

AND ...
Once you get familiar with the Decompile idea (and ALWAYS make a BACKUP first!) ... you can add both Decompile and Compact/Repair to the Right Click menus in Windows Explorer, which I use multiple times daily:

Getting the Decompile and Compact context menu options
http://access.mvps.org/access/modules/mdl0039.htm (note:link my be temporarily broken - if so, let me know and I can upload).

mx
John WilsonVP of Administration, Safety, & HR

Author

Commented:
Ok,  I tried mx's procedure.  Still getting the same error.  I feel like this is something higher level, something global on this particular machine.  As I've said, I can run this fine on my machine and any other machine.  Thoughts?
John WilsonVP of Administration, Safety, & HR

Author

Commented:
I appreciate your help.  I don't know that there is a solution to this problem.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Did you try the Decompile *on* the machine with the issue ?

mx
John WilsonVP of Administration, Safety, & HR

Author

Commented:
I did.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial