Problem running mdb file in Access 2007

[L.A. Lawyer]

I have a Access 2000 mdb file that will be shared with computers running
Access 2007.

I have been testing this file in Access 2007 in a standalone mode. Access
2007 finds and opens the file but seems to ignore all of the programming
behind the forms. I haven't a clue where to begin to diagnose the issue.
What I should be doing?

 

[Dale Fye]

Access 2007 has a more robust macro/vba security feature, so you have to
enable macros (there should be an option button on the Ribbon Bar).

But you can also accomplish this by going to the button in the upper left of
the Access window, and selecting Access Options.
Once in the Access options, select the Trust Center option.
Then click the "Trust Center Settings" button.
Then click the "Trusted Locations" button.

Then click the Add New Location button and enter the path to the mdb file on
the users computer.

The down side of this is that it will allow any Access VBA that is in that
folder to run without first being checked.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Tony Toews [MVP]]

The down side of this is that it will allow any Access VBA that is in that
folder to run without first being checked.

Which is the same behavior found in A2003 and earlier.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Dale Fye]

Another way to do this is by digitally signing the application, then, from
the users machine, accepting the digital signature as a trusted source.
This is simple for me, since I am currently working for the Dept of Defense,
and we all have CAC cards for our login proceedures, ensuring that we each
have our own digital signature. I've never tried to get a personal digital
signature, but I'm sure you could Google that or search this forum for
digital signatures.

Dale

 

[Tony Toews [MVP]]

Another way to do this is by digitally signing the application, then, from
the users machine, accepting the digital signature as a trusted source.
This is simple for me, since I am currently working for the Dept of Defense,
and we all have CAC cards for our login proceedures, ensuring that we each
have our own digital signature. I've never tried to get a personal digital
signature, but I'm sure you could Google that or search this forum for
digital signatures.

I was recently told that someone in Eastern Europe used a personal
certificate to create a generic device driver that anyone could use to
install their unsigned drivers. So Microsoft put pressure on outfits
who were selling personal certificates to stop doing so.

How true this is I do not know.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/