Acc2007 potential security risk

[Luke Bellamy]

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

 

[Arvin Meyer [MVP]]

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.

 

[Luke Bellamy]

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

 

[Maurice]

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.

 

[Arvin Meyer [MVP]]

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.

My second suggestion is to try signing your code with a certificate. There's
no guarantee that will work either, because it may still be a Vista problem.

 

[Luke Bellamy]

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