I have mdb file with addin-in custom menu, it was working fine in windows 7, office 2013 and shared network environment. Now I am trying to open in windows 10 Office 2019, the file open and close itself. what could be the reason?
I have mdb file with addin-in custom menu, it was working fine in windows 7, office 2013 and shared network environment. Now I am trying to open in windows 10 Office 2019, the file open and close itself. what could be the reason?
Who knows.
Use shift bypass and walk though your code from the start after setting a breakpoint.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I have tried press and hold the shift key, the navigation bar open. but I try to open form, the program close itself.
Ok, you have narrowed it down to the form.
Open the VBA window and set a breakpoint on the first executable line in the form.
Then open the form and take it from there.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Can you upload the database and see if one of us can open it?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I have tried to attach the db file here but its not uploading. so i have uploaded on this link
https://drive.google.com/file/d/1W7H...ew?usp=sharing
Post 6 was moderated, I'm posting to trigger email notifications.
It is 18MB?, I am not suprised. That probably exceeds the site limit?I have tried to attach the db file here but its not uploading. so i have uploaded on this link
https://drive.google.com/file/d/1W7H...ew?usp=sharing
Did you try and compact and then zip it?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Hi
The database had a virus which I removed.
It is missing the BE linked tables on Drive - R:\CheckUpDate.Mdb
Here fine the FE attached.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
I tried this file too, which you attached here. still its having same issue. Tried compact and repair database, same issue.
Well if it had a virus, as Mike says, then the chances are that is still on your computer.
Get an online check with https://www.trendmicro.com/en_gb/for...housecall.html as it sounds as your AV is not very good.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
well even if it had a virus, the new file which you attached I Opened on newly formatted PC with vmware environment. I am damn sure there is virus in my pc. Moreoever, its open when I press shift, there is a form called main menu which I open it it opens too. but without shift key it open and close itself.
Ok, so the shift key bypasses some code/autoexec macro?
Perhaps for whatever reason, that code is shutting down the DB?
I used to check that the FE was in the desired location, but I would at least give a warning message, THEN shutdown the DB.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Its working perfectly on Few of PC's in my network (windows 7,10,11) without doing any settings. in Windows 7 environment there is no issue.
I am not exactly impressed by your blase attitude of having a virus in your DB and happily uploading it for others to use?
Luckily for me, I only have 2007, so would never be able to open it.
I'll just bow out now as any suggestions I make, just seemed to get a 'well it works here' response?
Those working solutions *might* be passing the startup code, in the fact they satisfy the code checks.?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba