Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-16-2017, 06:20 PM   #1
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Microsoft access run time error 3044

I am getting a runtime error while starting my database file as follows:

MICROSOFT ACCESS RUN TIME ERROR 3044

C:\Hayes Server\Data\yes4\yeshaeya.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server onto which the file resides.

I get an option to debug, end and cancel.

If I use debug--> Opens VBA which I have no idea.

End will close the database file and cancel will also do the same...

This file, however, opens good on other systems which are also Windows XP and have office 97 Pro installed.

This system too has Windows XP and has Office 97....

It used to open good earlier however now since two weeks it is not working good....

Have tried to delete the file from this system copy it from other system and then try to run.... Still no go...

Have tried to create new user account... Still same issue...


NOTE: THE FILE EXISTS ONTO THE C: ITSELF AND NOT ON Z: As the error states

Any help would be greatly appreciated.


Last edited by Ace Brendon; 06-16-2017 at 06:26 PM. Reason: skipped an important note
Ace Brendon is offline   Reply With Quote
Old 06-16-2017, 11:34 PM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,397
Thanks: 0
Thanked 517 Times in 503 Posts
Ranman256 is on a distinguished road
Re: Microsoft access run time error 3044

you should have opened in vba, captured a screen shot, and posted it,
but
IS that a valid path?
when does it happen, when you open the db?, when you click something while open?
is this path hardcoded into a form or used in code?
Ranman256 is offline   Reply With Quote
Old 06-19-2017, 10:52 AM   #3
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

Hi Ranman,

I will do it now....

Sorry for that....

Will post the error in next reply....

Thanks....

Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 11:43 AM   #4
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

Here is the screenshot of the same...

The error happens when I try to open the Access database....

The file opens good on other two systems but unfortunately not on mine...

It is in the zip file as the size was exceeding the limit...

Also, i am attaching the VBA code as well however we haven't used any VBA script as well...
Attached Files
File Type: zip Error Code.zip (24.0 KB, 12 views)
File Type: zip VBA code.zip (88.2 KB, 11 views)
Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 02:03 PM   #5
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

the reference to the z drive is not made up by access, it will be there in your code or perhaps you have linked tables to a file on a z drive.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 03:08 PM   #6
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

As I mentioned earlier that we do not use any coding and it just a database file.....

For the very same reason have attached both the error code and the VBA script as well.....

So if you can please go through it and then let me know....

I would not be able to check the linking of the table as the file does not load itself.....

I get this message the moment I try to open the database file.....

Last edited by Ace Brendon; 06-19-2017 at 03:09 PM. Reason: Notes
Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 03:23 PM   #7
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 10,627
Thanks: 31
Thanked 1,691 Times in 1,643 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Microsoft access run time error 3044

I agree with what CJ said. The reference to Z must be somewhere in code or set up procedures or a previous link or ???, but Access doesn't just make up drive letters.

What happened 2 weeks ago when things no longer worked as expected??

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 06-19-2017, 03:24 PM   #8
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

Code:
So if you can please go through it and then let me know....
No because -

1. you say you don't use any coding, but attach a screenshot of some.
2. I cannot check linked files only you can
3. the error screenshot does not match the text in your post

if it works on other machines, but not yours, it has to be to do with the setup of your machine.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 03:26 PM   #9
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

Quote:
I get this message the moment I try to open the database file.....
try holding down the shift key whilst opening the db
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 04:10 PM   #10
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

Hi Please find the file attached when i try to open the database file while holding down the shift key....

Also In reply to the below queries are my responses:

1. you say you don't use any coding, but attach a screenshot of some.

This VBA comes up when i press debug if i press end....

2. I cannot check linked files only you can.....

If you can guide me how to check the linked file that would be great.....

3. the error screenshot does not match the text in your post

the first screenshot in the zipped format is the error I get and the second zipped file is the VBA that opens up when i click debug....
Attached Files
File Type: zip ts 1.zip (56.4 KB, 9 views)
Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 04:28 PM   #11
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

Quote:
If you can guide me how to check the linked file that would be great.....
see post #9
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 04:30 PM   #12
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

yes i followed that step and that is what is the screenshot i have attached....
Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 04:34 PM   #13
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

holding down the shift key prevent the vba code from running. So perhaps it has been disabled.

Next choice is to open a new blank copy of the db and import the tables from the one you can't use. You can then see if they are linked and if so, what they are linked to - my gues would be to a database on a z drive
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 06-19-2017, 04:52 PM   #14
Ace Brendon
Newly Registered User
 
Join Date: Jun 2017
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
Ace Brendon is on a distinguished road
Re: Microsoft access run time error 3044

Ok I was in the process of importing the tables when i got this message that :

Z:\hayess~1\Data\Yes4\yeshayea.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server onto which the file resides...

I hit Ok 3 -4 times and then it gave me two names:

yescalendaricons
yescalendaricons1

Last edited by Ace Brendon; 06-19-2017 at 05:01 PM. Reason: Note
Ace Brendon is offline   Reply With Quote
Old 06-19-2017, 05:04 PM   #15
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,435
Thanks: 36
Thanked 3,048 Times in 2,963 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: Microsoft access run time error 3044

well that is telling you that the table is linked to one in a z drive you don't have. You either need to map the relevant drive to z (go look at your colleagues setup) or find a way to open the database without triggering the code.

One other thing to try to do this. In your first post you said

Quote:
I get an option to debug, end and cancel.

If I use debug--> Opens VBA which I have no idea.
1. choose debug and see the code
2. from the menus at the top, choose run, then reset

it might leave you with the code stopped and you have access to the database.

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Reply

Tags
access97 , database error , runtime error 3044 , windows xp

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP PLEASE! (run-time error 3044: invalid path) Anticephalous Forms 3 10-12-2015 05:51 AM
[SOLVED] Run-time error '3044' MNM Forms 10 05-08-2015 04:06 PM
Run-time error '1004' : Microsoft Excel cannot access the file ... RickRo Modules & VBA 2 04-17-2013 02:34 PM
Error Trapping 3044 help please james_halliwell Modules & VBA 1 09-24-2012 07:49 AM
Error 3044 vbbbmom Macros 4 11-16-2011 10:00 AM




All times are GMT -8. The time now is 10:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World