Access database designed on a MAC virtual PC

[bdm1]

I have an MS access 2007 database designed on the windows virtual machine on a MAC. Everything works just grand if it is running on the MAC but when I load it on a Windows XP PC, the macros and event procedures do not work. I have checked all references and all are the same. Code also compiles on both computers. I cannot figure out what is happening. Any ideas about what is happening will be GREATfully appreciated.

 

[PHV]

Seems like you haven't enable code execution for this db on your pc.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bdm1]

Thanks PHV for your fast response. And how would I accomplish enabling code execution on the pc/

 

[kjv1611]

I think he's talking about Macro security. You'll either need to sign your database, or else just change the Macro level security to Low (easiest)... just don't open any databases on that PC which you don't trust - should be common sense.

In Access 2007, it's under The Office button -> Access Options ->Trust Center....

In prior versions, go to Tools -> Macros -> Macro Security (I think)

If that's not 100% correction the location, you can Google for the location.. just look for "Access macro security"

--

"If to err is human, then I must be some kind of human!" -Me