MDB database open and close itself in office 2019, windows 10

[Kashif Shahzad]

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?

[Welshgasman]

Who knows.
Use shift bypass and walk though your code from the start after setting a breakpoint.

[Kashif Shahzad]

I have tried press and hold the shift key, the navigation bar open. but I try to open form, the program close itself.

[Welshgasman]

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.

[mike60smart]

Can you upload the database and see if one of us can open it?

[Kashif Shahzad]

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

[pbaldy]

Post 6 was moderated, I'm posting to trigger email notifications.

[Welshgasman]

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

It is 18MB?, I am not suprised. That probably exceeds the site limit?
Did you try and compact and then zip it?

[mike60smart]

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.

[Kashif Shahzad]

I tried this file too, which you attached here. still its having same issue. Tried compact and repair database, same issue.

[Welshgasman]

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.

[Kashif Shahzad]

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.

[Welshgasman]

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.

[Kashif Shahzad]

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.

[Welshgasman]

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.?