Access 2013 failed to create visual basic module

I have just installed Access 2013 on a Windows7 64-bit system.
Created a new blank desktop database.
Created a new form in design view.
Access will not allow me to add any controls on the form, save the form or add any event  code for the form.
I have uninstalled, rebooted and reinstalled Access 2013 and installed all Windows updates/patches ect...

I'm at a loss. I have developed in Access way back to Office 2000 version.  
And have used every version  of Access up to this one.
Any help would be greatly appreciated.

Yes... I would much rather develop in Visual Studio (C#) but I have clients that want to stay with Access.
form.jpg
Michael CAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sounds like it's getting opened read-only.

Check the directory security where the DB resides and make sure you have full rights to it.

Jim.
0
Jeffrey CoachmanMIS LiasonCommented:
Is this on all machines, or just one machine?
Is this in one database, or all databases?
Is this on one form, or all forms?
Same issue on Reports?

Whats odd is that at work I have the same software as you, and I have issue with Access freezing, ...but the same setup at home works fine...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you have more than one version of Access on the machine (post 2007, that is)? If so, you can have issues with that.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Michael CAuthor Commented:
Jim,

I am the admin on this system. The DB is is on the desktop with full read/write access
0
Michael CAuthor Commented:
Jeffrey,

Reports and Forms have the same issue. Can't add any control or view the code behind.
This is the only machine I have Access 2013 installed on.
This issue is with every DB I create with 2013. I can open older DBs but can't make changes.
If I open the older versions even with old 2k version all is fine. Even in same location.
0
Michael CAuthor Commented:
Scott,

The only versions on this system are 2000 and 2013.
I run the other versions in VMs
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
um, well try a simple test just to confirm.   In the dir where the DB was created, using explorer:

1. Right click, new, text document.
2. Save it
3. Right click on it and edit, then save
4 Right click on it and then delete.

If you can do all that, then something is wrong with the install.

One thing there to be aware of: if you have other office components (I.e. Excel 2013), then Access must be of the same edition, being 32 or 64 bit.

 You can't have 64 bit Excel and 32 bit Access.

Jim.
0
Michael CAuthor Commented:
Jim,

Thanks for the quick reply. I can complete the tasks listed below
1. Right click, new, text document.
2. Save it
3. Right click on it and edit, then save
4 Right click on it and then delete

The mixed environment may in fact  be an issue. The company I work for is still tied to XP because of a proprietary software package they use that I did not write. With that being said we still use..
1 - Office 2000 on a daily basis (Word, Excel, Acsess (w/workgroup security file))
2 - Outlook 2003 for Exchange Server

I was in the process of upgrading all apps when I ran into this issue.
Everything migrated just fine in Access 2007 accdb version. I do not have 2010 version to test with.

Michael
0
Michael CAuthor Commented:
As you can see in the image attached. I can open a form in design view from an old DB.
I can select the control but get the error about the VBA project and cannot add any controls.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The 32/64 bit problem only applies to A2010 and up, and only within a edition of Office (ie. 2010).

Multiple versions of Access/Office on the same machine are generally not a problem as long as they are installed in order and in separate directories.   For example, I have one station here that currently has A97, A2000, A2002, A2003, A2007, and A2010 all of which work fine.

 But if that wasn't done, then all bets are off.  Also if you would respond to Jeff's questions, that would be helpful, but it certainly sounds like an installation issue on just this one station.

 By the way,  I didn't see any attachment on your last post.

Jim.
0
Michael CAuthor Commented:
This was my response to Jeff..
And also the file that did not attach to the last post.

Jeffrey,

Reports and Forms have the same issue. Can't add any control or view the code behind.
This is the only machine I have Access 2013 installed on.
This issue is with every DB I create with 2013. I can open older DBs but can't make changes.
If I open the older versions even with old 2k version all is fine. Even in same location.
0
Jeffrey CoachmanMIS LiasonCommented:
Thanks for sticking with us Mike...
;-)

Is this issue confined to new .accdb databases or .mdb databases?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<This issue is with every DB I create with 2013. I can open older DBs but can't make changes.
If I open the older versions even with old 2k version all is fine. Even in same location.>>

 Most certainly the install then in some way.

 You should always be able to create a blank DB and work with it.   The fact that you can't means there is a problem with the install.

 Sounds like something with VBA7 has gotten messed up.   A couple of things though before you continue with the install:

1. Try disabling any anti-virus, then create a blank DB and some controls/code.
2. Delete all files in C:\TEMP and C:\Windows\temp.  Test again with new DB.
3. Open Access.   Do alt/F11, then click on tools/references.  Anything listed as missing or broken?

Jim.
0
Michael CAuthor Commented:
Jeff,

It is with all new accdb files.
This entire issue started when I opened a DB in accdb format that was just converted...
Here was the process.

Access 2000 MDB > Access 2003 MDB. All good
Access 2003 MDB > Access 2007 ACCDB. All Good
Opened Access 2007 ACCDB to SaveAs Access 2013 ACCDB. Error must delete VBA project .....
I have checked all references ect....

I even tried Access 2000 MBD to ACCESS 2013 ACCDB same error

I have been developing software for 28 years in 10+ programming languages.
Never had any problem like this.

Michael
0
Michael CAuthor Commented:
Jim,

Is regards to:
1. Try disabling any anti-virus, then create a blank DB and some controls/code.
2. Delete all files in C:\TEMP and C:\Windows\temp.  Test again with new DB.
3. Open Access.   Do alt/F11, then click on tools/references.  Anything listed as missing or broken?

1 - Deleted all temp files and folders
2 - Disabled VIPRE Business and created a new DB
3 - Opened access 2013 used Alt/F11 to view ref. See attached images
11-12-2015-9-36-06-AM.jpg
0
Jeffrey CoachmanMIS LiasonCommented:
OK,
Thanks.
Then I am at a loss too...
Please continue on with the other Experts...
0
Michael CAuthor Commented:
Jim,

I then tried to open a 2007 ACCDB.
See attached image.
11-12-2015-9-34-44-AM.jpg
0
Michael CAuthor Commented:
Jeff,

Thank you for your time and effort. It is greatly appreciated.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
All right, now were getting somewhere....that's definitely messed up.

You should have Microsoft Access 15.0 object library right now, not 9.0.  Something is not registered correctly.

Scroll down and see if you do have that reference.  If so (and not sure you'll be able to do this), check it, then move it above the 9.0 reference.  Close Access, re-open, and see if you can uncheck the 9.0 reference.

If you manage to do that, close Access, then re-open see if they are still correct.  If not and it's back to 9.0, then the registry is messed up.

If they stayed put, try creating a blank DB and working with it.

I think what you'll need to do is:
1. Uninstall Office/A2013
2. Reboot
3. Remove A2013 registry entries manually.
4. Uninstall any other versions of Office/Access
5. Reboot
6. Reinstall the versions in order to different directories for each version.

 But your really at the point where if the station is not used for much, it might be faster to wipe it, restore the OS, then do the office installs as needed.

 You also might want to try a repair on A2013 first to see if that straightens it out before doing the above.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michael CAuthor Commented:
Jim,

I agree... I will do the above asap.
I have another project in the IT world that needs my attention at the moment.
I will report back later today.

Again, Thank you for all your help. All of you guys have been great!!
0
Michael CAuthor Commented:
The problem was in fact registry issues.
I ultimately had to wipe a system and reinstall from scratch.

All works just as expected now.

Thanks again for all of your help.

Michael
0
Michael CAuthor Commented:
Persistent expert for sure!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.