Link to home
Create AccountLog in
Avatar of John Wilson
John WilsonFlag 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?
Avatar of trbaze
trbaze

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

ASKER

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

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Could you post the SQL statement for one of the forms?
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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?
I appreciate your help.  I don't know that there is a solution to this problem.
Did you try the Decompile *on* the machine with the issue ?

mx
I did.