Basic way to make basic databases work on Access2007?
in [General]
|
From: Fred on 8 Apr 2010 08:08 I tried the Microsoft info on this questions and it was really worthless. Let's say a "little guy" makes some unsplit Access 2003 databases with Macros and code which a friend wants to run on Access 2007 without "security" related hassles, including without wanting to have to click through warnings every time it is opened. Is there a simple way to do this? Thanks in advance Sincerely, Fred
From: Jeff Boyce on 8 Apr 2010 08:23 Fred If you trust your friend, you can tell Access/Windows to trust the location in which the file runs. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Fred" <Fred(a)discussions.microsoft.com> wrote in message news:9A26FD02-ECD2-491F-88E8-EAF8E16DB555(a)microsoft.com... >I tried the Microsoft info on this questions and it was really worthless. > > Let's say a "little guy" makes some unsplit Access 2003 databases with > Macros and code which a friend wants to run on Access 2007 without > "security" > related hassles, including without wanting to have to click through > warnings > every time it is opened. > > Is there a simple way to do this? > > Thanks in advance > > Sincerely, > > Fred >
From: Daniel Pineault on 8 Apr 2010 08:55 Firstly, if a "little guy", as you put it, create a simple db in 2003, it should run fine in 2007. That said, you may encounter a message relating to enabling content.... caused by the trust center, MS new improved, very questionable, security measure. You can eliminate the prompt very easily by simply placing you db within a trusted location or, defining the db directory as a new trusted location. See: http://office.microsoft.com/en-us/help/HA100319991033.aspx#11 -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Fred" wrote: > I tried the Microsoft info on this questions and it was really worthless. > > Let's say a "little guy" makes some unsplit Access 2003 databases with > Macros and code which a friend wants to run on Access 2007 without "security" > related hassles, including without wanting to have to click through warnings > every time it is opened. > > Is there a simple way to do this? > > Thanks in advance > > Sincerely, > > Fred >
From: Fred on 8 Apr 2010 09:18 Thank you Daniel & Jeff, Just what I was looking for. Sincerely, Fred
From: Dorian on 8 Apr 2010 11:19
That link for Microsoft was very funny. They don't recommend using a network share as a trusted location? How do they expect anyone to use Access on that basis? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Daniel Pineault" wrote: > Firstly, if a "little guy", as you put it, create a simple db in 2003, it > should run fine in 2007. > > That said, you may encounter a message relating to enabling content.... > caused by the trust center, MS new improved, very questionable, security > measure. You can eliminate the prompt very easily by simply placing you db > within a trusted location or, defining the db directory as a new trusted > location. See: > > http://office.microsoft.com/en-us/help/HA100319991033.aspx#11 > -- > Hope this helps, > > Daniel Pineault > http://www.cardaconsultants.com/ > For Access Tips and Examples: http://www.devhut.net > Please rate this post using the vote buttons if it was helpful. > > > > "Fred" wrote: > > > I tried the Microsoft info on this questions and it was really worthless. > > > > Let's say a "little guy" makes some unsplit Access 2003 databases with > > Macros and code which a friend wants to run on Access 2007 without "security" > > related hassles, including without wanting to have to click through warnings > > every time it is opened. > > > > Is there a simple way to do this? > > > > Thanks in advance > > > > Sincerely, > > > > Fred > > |