 |
|
|
|
Next: Creating a composite key
|
| Author |
Message |
External
Since: Oct 06, 2008
Posts: 5
|
(Msg. 1) Posted: Sat Oct 11, 2008 7:25 pm
Post subject: Acc2007 potential security risk
Archived from groups: microsoft>public>access (more info?)
|
|
|
Hi - my application creates access database files like they are word
documents, for example.
When I create these files I export the tables and then link them into the
front end.
Problem is with access2007 on vista I get a "potential security risk" when
exporting the
tables using:
DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
........
Anyone know how to get around this?
I have tried turning warnings off but this did not help.
Note is works fine with Acc2002 on vista or acc2007 on XP. It's the acc2007
and vista combo
that causes this issue.
Thanks,
Luke |
|
| Back to top |
|
 | |
External
Since: Oct 02, 2008
Posts: 144
|
(Msg. 2) Posted: Sat Oct 11, 2008 11:26 pm
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I'm not sure it will help, because I suspect that it's a Vista problem, but
you can try using a Trusted Location. To do that create a folder, and go to
the Office Orb in the upper left corner. Then Choose Options, and Trusted
Locations.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Luke Bellamy" <Luke.DeleteThis@CashWhiz.com.au> wrote in message
news:eYbqmZ$KJHA.3756@TK2MSFTNGP05.phx.gbl...
> Hi - my application creates access database files like they are word
> documents, for example.
> When I create these files I export the tables and then link them into the
> front end.
>
> Problem is with access2007 on vista I get a "potential security risk" when
> exporting the
> tables using:
> DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
> .......
>
> Anyone know how to get around this?
> I have tried turning warnings off but this did not help.
>
> Note is works fine with Acc2002 on vista or acc2007 on XP. It's the
> acc2007
> and vista combo
> that causes this issue.
>
> Thanks,
> Luke
>
> |
|
| Back to top |
|
| |
External
Since: Oct 06, 2008
Posts: 5
|
(Msg. 3) Posted: Sun Oct 12, 2008 3:25 am
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks Arvin - this is testing Acc2007 runtime so there is no place for the
user to select "options" and trusted locations on the Office Orb.
Luke
"Arvin Meyer [MVP]" <arvinm.RemoveThis@mvps.invalid> wrote in message
news:epbiapBLJHA.1012@TK2MSFTNGP04.phx.gbl...
> I'm not sure it will help, because I suspect that it's a Vista problem,
but
> you can try using a Trusted Location. To do that create a folder, and go
to
> the Office Orb in the upper left corner. Then Choose Options, and Trusted
> Locations.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Luke Bellamy" <Luke.RemoveThis@CashWhiz.com.au> wrote in message
> news:eYbqmZ$KJHA.3756@TK2MSFTNGP05.phx.gbl...
> > Hi - my application creates access database files like they are word
> > documents, for example.
> > When I create these files I export the tables and then link them into
the
> > front end.
> >
> > Problem is with access2007 on vista I get a "potential security risk"
when
> > exporting the
> > tables using:
> > DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
> > .......
> >
> > Anyone know how to get around this?
> > I have tried turning warnings off but this did not help.
> >
> > Note is works fine with Acc2002 on vista or acc2007 on XP. It's the
> > acc2007
> > and vista combo
> > that causes this issue.
> >
> > Thanks,
> > Luke
> >
> >
>
> >> Stay informed about: Acc2007 potential security risk |
|
| Back to top |
|
| |
External
Since: Jan 11, 2008
Posts: 122
|
(Msg. 4) Posted: Sun Oct 12, 2008 5:58 am
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
My guess would be that the UAC of Vista is also playing part here. Try
adjusting that just for testing purpose. If that's bugging than ask
permission to change these settings.
--
Maurice Ausum
"Luke Bellamy" wrote:
> Thanks Arvin - this is testing Acc2007 runtime so there is no place for the
> user to select "options" and trusted locations on the Office Orb.
>
> Luke
>
> "Arvin Meyer [MVP]" <arvinm.RemoveThis@mvps.invalid> wrote in message
> news:epbiapBLJHA.1012@TK2MSFTNGP04.phx.gbl...
> > I'm not sure it will help, because I suspect that it's a Vista problem,
> but
> > you can try using a Trusted Location. To do that create a folder, and go
> to
> > the Office Orb in the upper left corner. Then Choose Options, and Trusted
> > Locations.
> > --
> > Arvin Meyer, MCP, MVP
> > http://www.datastrat.com
> > http://www.mvps.org/access
> > http://www.accessmvp.com
> >
> >
> > "Luke Bellamy" <Luke.RemoveThis@CashWhiz.com.au> wrote in message
> > news:eYbqmZ$KJHA.3756@TK2MSFTNGP05.phx.gbl...
> > > Hi - my application creates access database files like they are word
> > > documents, for example.
> > > When I create these files I export the tables and then link them into
> the
> > > front end.
> > >
> > > Problem is with access2007 on vista I get a "potential security risk"
> when
> > > exporting the
> > > tables using:
> > > DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
> > > .......
> > >
> > > Anyone know how to get around this?
> > > I have tried turning warnings off but this did not help.
> > >
> > > Note is works fine with Acc2002 on vista or acc2007 on XP. It's the
> > > acc2007
> > > and vista combo
> > > that causes this issue.
> > >
> > > Thanks,
> > > Luke
> > >
> > >
> >
> >
>
>
> >> Stay informed about: Acc2007 potential security risk |
|
| Back to top |
|
| |
External
Since: Oct 02, 2008
Posts: 144
|
(Msg. 5) Posted: Sun Oct 12, 2008 10:30 am
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
|
Chris O'C via AccessMonst
|
External
Since: Apr 17, 2008
Posts: 484
|
(Msg. 6) Posted: Sun Oct 12, 2008 1:25 pm
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
It's a potential security risk on Vista and not Windows XP because the Vista
pc doesn't have the folder where the db is in set as a trusted location. Set
the trusted location on the Vista pc or digitally sign the db file and accept
the certificate on the Vista pc.
Chris
Microsoft MVP
Luke Bellamy wrote:
>Hi - my application creates access database files like they are word
>documents, for example.
>When I create these files I export the tables and then link them into the
>front end.
>
>Problem is with access2007 on vista I get a "potential security risk" when
>exporting the
>tables using:
>DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
>.......
>
>Anyone know how to get around this?
>I have tried turning warnings off but this did not help.
>
>Note is works fine with Acc2002 on vista or acc2007 on XP. It's the acc2007
>and vista combo
>that causes this issue.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200810/1 >> Stay informed about: Acc2007 potential security risk |
|
| Back to top |
|
| |
External
Since: Oct 06, 2008
Posts: 5
|
(Msg. 7) Posted: Mon Oct 13, 2008 8:27 am
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks for your answers all.
Chris - I know what your saying but from a user perspective setting up
trusted
locations and digitially signing are just another layer thats prone to
error.
I looking at the following registry tweak:
http://bytes.com/forum/thread764640.html
Also there is a regedit on msdn where I can turn "SandBoxMode" off, but I'm
still testing that.
Luke
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:8b9044074cdf7@uwe...
> It's a potential security risk on Vista and not Windows XP because the
Vista
> pc doesn't have the folder where the db is in set as a trusted location.
Set
> the trusted location on the Vista pc or digitally sign the db file and
accept
> the certificate on the Vista pc.
>
> Chris
> Microsoft MVP
>
>
> Luke Bellamy wrote:
> >Hi - my application creates access database files like they are word
> >documents, for example.
> >When I create these files I export the tables and then link them into the
> >front end.
> >
> >Problem is with access2007 on vista I get a "potential security risk"
when
> >exporting the
> >tables using:
> >DoCmd.TransferDatabase acExport, "Microsoft Access", FileName, acTable,
> >.......
> >
> >Anyone know how to get around this?
> >I have tried turning warnings off but this did not help.
> >
> >Note is works fine with Acc2002 on vista or acc2007 on XP. It's the
acc2007
> >and vista combo
> >that causes this issue.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/200810/1
> >> Stay informed about: Acc2007 potential security risk |
|
| Back to top |
|
| |
|
Chris O'C via AccessMonst
|
External
Since: Apr 17, 2008
Posts: 484
|
(Msg. 8) Posted: Mon Oct 13, 2008 3:25 pm
Post subject: Re: Acc2007 potential security risk [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Don't turn sandbox mode off. Turn it off for Access and keep it on for all
other Office apps.
Chris
Microsoft MVP
Luke Bellamy wrote:
>Thanks for your answers all.
>
>Chris - I know what your saying but from a user perspective setting up
>trusted
>locations and digitially signing are just another layer thats prone to
>error.
>
>I looking at the following registry tweak:
>http://bytes.com/forum/thread764640.html
>
>Also there is a regedit on msdn where I can turn "SandBoxMode" off, but I'm
>still testing that.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200810/1 >> Stay informed about: Acc2007 potential security risk |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
