question

MeirRotfleisch-7325 avatar image
0 Votes"
MeirRotfleisch-7325 asked ZorroRonoroa-7240 answered

Access 2019 corrupt VBA

Just installed Office 2019 (office3 365) .

Access can't open Databases from previous Access 2016 give VBA Corrupt .

Access can't create new Module in VBA also gives "VBA corrupt"

Suggestions????

Meir

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MeirRotfleisch-7325 avatar image
0 Votes"
MeirRotfleisch-7325 answered

After doing "office scrub" uninstall and fresh install everythings working

Meir

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZorroRonoroa-7240 avatar image
0 Votes"
ZorroRonoroa-7240 answered

Hi,

I am glad that reinstalling the Microsoft office has worked out for. Though, this is usually a file corruption issue which is often seen in MS Access. I would recommend using the ‘Compact and Repair’ to Repair Access Database Manually:"

Steps:

1: In your MS Access database, click on ‘File’.

2: Click the ‘Compact & Repair’ option on the ‘Info’ page.
Access will create a copy of the compacted and repaired database at the same location as that of the original database.

Otherwise, If Compact and Repair does not work for you, use a professional Access database repair tool to fix database corruption. You can check out this thread: https://answers.microsoft.com/en-us/msoffice/forum/all/database-cannot-be-opened-because-vba/7fe4767d-46fa-4eec-98f1-ab91e9271133

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.