I have moved a Access 2007 database from on computer to another and now I am receiving a 'The SetValue' macro action cannot be executed in disable mode.' I have Trusted the path where the database now resides and enabled macros but still receive this error. It was working fine on the original computer. Any ideas?:(

Right-click on the accdb or mdb file itself and select PROPERTIES. You should see a checkbox on one of the tabs that says something about trust and running the db - uncheck it. I just can't remember the actual wording.

I am running XP Home edition and when I right-click on the ACCDB I don't see any of the options that you mentioned.

After Right-clicking, did you click on PROPERTIES?

Yes, I did. All it gives me is the file sizes,location, mod, create dates and such.

You don't have a SECURITY, or SHARING AND SECURITY, or ADVANCED tab?

There is one at the folder level but not at the file level. Do I have something turned off maybe on XP side?

Not that I'm aware of. The symptoms you describe would be that a file copied from another computer and put on your computer will have that security checkbox that disables running the file until you uncheck it. I had that occur with a client of mine when I copied a db file from my computer to his and then it took quite a bit for us to finally figure it out. I had to see the file on his computer and then I finally found the checkbox which, after unchecking, made everything fine. That's what your problem sounded like to me. If there is no checkbox then I'm not sure what it could be.

I can open the ACCDB and it runs the forms fine and it even rruns certain macros just fine. I am just a little confused why it doesn't run all the macros.

And I do think it is trusted because I know longer get the Trust Message on the Message Bar when I open it.

Did you maybe click YES when it originally asked you if you wanted Access to disable unsafe code?

Right now it is set to Enable macros under the Trust Center. But I am getting a little closer, the only macros that error are the ones that use SetValue in them. Is there something specific about this particular action that I am missing?

Could the problem also be I am using the evaluation version of Office 2007 Evaluation Version?

Right now it is set to Enable macros under the Trust Center. But I am getting a little closer, the only macros that error are the ones that use SetValue in them. Is there something specific about this particular action that I am missing?

See if this helps:

http://msdn2.microsoft.com/en-us/library/bb177384.aspx

Could the problem also be I am using the evaluation version of Office 2007 Evaluation Version?

I guess it could be. I don't know why it would though.