Problem running mdb file in Access 2007 "L.A. Lawyer" <kapplaw[ at ]linkline.com> 11/26/2008 6:34:22 PM 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?

RE: Problem running mdb file in Access 2007 Dale Fye 11/26/2008 7:59:00 PM 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. "L.A. Lawyer" wrote: [Quoted Text] > 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? > > >

Re: Problem running mdb file in Access 2007 "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 11/26/2008 8:18:02 PM Dale Fye <dale.fye[ at ]nospam.com> wrote: [Quoted Text] >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/

Re: Problem running mdb file in Access 2007 "Dale Fye" <dale.fye[ at ]nospam.com> 11/27/2008 1:17:06 AM 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 "L.A. Lawyer" <kapplaw[ at ]linkline.com> wrote in message news:eFRgVX$TJHA.1908[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >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? > >

Re: Problem running mdb file in Access 2007 "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 11/27/2008 2:14:52 AM "Dale Fye" <dale.fye[ at ]nospam.com> wrote: [Quoted Text] >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/