Avatar of John Wilson
John Wilson
Flag for United States of America asked on

MS Visual Basic Runtime Error 3001

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?
Microsoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment
John Wilson

8/22/2022 - Mon
trbaze

Is '1' the name of a table?
Is the back-end SQL or MSAccess?
John Wilson

ASKER
1 is not the name of anything in this setup.  It is a MSAccess database on the back-end
SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
trbaze

Could you post the SQL statement for one of the forms?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
John Wilson

ASKER
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 Wilson

ASKER
I appreciate your help.  I don't know that there is a solution to this problem.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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

mx
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
John Wilson

ASKER
I did.