Editing and saving Access VBA code

Wondering if someone can help me figure out what should be a simple solution.  One of my departments have an older access DB that they would like to keep as is (yes they are stubborn and do not accept change well).   So when I replaced one of their workstations with a new 64 bit PC, when they try to run their reports in the DB, they get a Compile Error, "The code in the project must be updated for 64bit systems.  Please review and update Declare statements and then mark them with the PtrSafe attribute.   This seems to get me by and I have to change about 4 different modules and about 20 lines and then the report appears.

Thing is that I cannot save thee changes to the VBA code.  It is in a project called Utility (UTILITY) and the save button is always greyed out when I am editing this code.  Not sure if I am missing a simple step or trick in order to save it.  

I know we need to upgrade the DB, but these guys are so difficult, I just want to try to make this work and let them use it until it is obsolete.  Unless it already is.

Thanks for any help!
dgoldflussAsked:
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:
<<Thing is that I cannot save thee changes to the VBA code.  It is in a project called Utility (UTILITY) and the save button is always greyed out when I am editing this code.  Not sure if I am missing a simple step or trick in order to save it.  >>

 UTILITY is a MDA add-in supplied with Access by Microsoft and is used by Access for things like the Zoom box.

 You can view what's in there, but you don't have the permissions required to modify it.

 You will need to upgrade the application or switch to a 32 bit version of Office (which I'd highly recommend) on the 64 bit machine.

Jim.
0
dgoldflussAuthor Commented:
I tried saving the DB in the newer format and it did not fix anything.  I cannot install Office 2010 32 bit version on a 64 bit OS.  Should I try installing Office 2003 or 2007 (just MSAccess) 32 bit instead?  Not sure if that will work.

What steps do I need to take in order to upgrade this database to work??
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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< I cannot install Office 2010 32 bit version on a 64 bit OS.  >>

 If you have the 32 bit edition, sure you can.

<< Should I try installing Office 2003 or 2007 (just MSAccess) 32 bit instead?  Not sure if that will work.>>

 Yes, that will work.

<<What steps do I need to take in order to upgrade this database to work?? >>

 Without the ability to modify the code, your only option is to run it in a 32 bit edition of Office.

  It's the version of Office that determines if a DB runs as 32 bit or 64, not the OS and all 32 bit editions of Office will run under a 64 bit OS (jury's still out on Windows 8, but so far nothing earth shattering that I've heard).

Jim.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I agree with Jim's comments.

Another option:
For older versions of office Apps that you do not want to upgrade, I use XP Mode. Install the older version of Office/Access inside XP mode and use it to run the older database.

FWIW: I would not install the 64 bit version of Office apps unless you absolutely need it. Microsoft even recommends this.  The 32 bit version of office runs really well on 64 bit Windows versions.
0
dgoldflussAuthor Commented:
Thanks I will try this.  I swear that when i previously tried to install the 32bit version that I got an error message saying I had to ionstall the 64bit version.  I just tried installing 32 bit on another 64bit pc and it worked.  

Thanks!  Will award points after I confirm the fix!
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Thanks I will try this.  I swear that when i previously tried to install the 32bit version that I got an error message saying I had to ionstall the 64bit version.  I just tried installing 32 bit on another 64bit pc and it worked.  >>

 Note that you cannot mix and match within Office (i.e. 64 bit Word, 32 bit Access).   It must be all 64 bit or all 32 bit.

 You would get an error otherwise.

Jim.
0
dgoldflussAuthor Commented:
easy solution!
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.