runtime issues when linking tables

[greg]

hello. i've made a simple access 2007 database which has all of 3 linked
tables in it. i used the developer option to 'package a solution' so i can
put it (along with access runtime) on a cd and get it into the hands of other
users in my company. i used the code from
http://www.mvps.org/access/api/api0001.htm and
http://www.mvps.org/access/tables/tbl0009.htm in order to link the tables
because the linked table manager doesn't work with this package solution. i
attached these two pieces of code, verbatim, to the main form of the program,
which is set to open when the file is opened. so here's the problem...

when the file is first opened, an security warning pops up cautioning that
the file is from an unknown source. if you open it anyway, an error message
indicates that i can't find the file that the tables used to be linked to (an
expected error, i'm guessing). at that point you can only click ok or help
and if you click ok, the message closes and nothing happens. the form never
opens up. any ideas?

 

[Alex Dybenko]

Hi,
you can add trusted location during setup, look here:
http://www.granite.ab.ca/Access/developeredition2007faq.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[kaosyeti via AccessMonster.com]

first off, thanks for your help. this is where i was guessing the problem was.
.. if a pc doesn't have access, how can the macro security be set to 'low'
to allow my code to run -- access runtime 2007 doesn't work that way. so the
whole trusted locations thing sounds like the right answer. however, i know
next to nothing about registries, keys etc.. and don't want to screw up
anyone's pc. when i use ADE to package the solution, i'm adding an
additional registry key that looks like this (my root install folder is
program files for all users and my install path is c:\Program Files\
<<FolderName>>\<<FileName>>.accdr)

root: "all users"
key: "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\
Trusted Locations\Location0"
name: "path"
value: "C:\Program Files\<<FolderName>>\"

i really have no sense if this is correct or not.

greg

Hi,
you can add trusted location during setup, look here:
http://www.granite.ab.ca/Access/developeredition2007faq.htm

hello. i've made a simple access 2007 database which has all of 3 linked
tables in it. i used the developer option to 'package a solution' so i

[quoted text clipped - 20 lines]

never
opens up. any ideas?

 

[Alex Dybenko]

Hi,
well, I don't have PDW around to check, but I think should be:

root: "current user"
key: "Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0"
name: "path"
value: "C:\Program Files\<<FolderName>>\"


have a lok here also:
http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

first off, thanks for your help. this is where i was guessing the problem
was.
. if a pc doesn't have access, how can the macro security be set to 'low'
to allow my code to run -- access runtime 2007 doesn't work that way. so
the
whole trusted locations thing sounds like the right answer. however, i
know
next to nothing about registries, keys etc.. and don't want to screw up
anyone's pc. when i use ADE to package the solution, i'm adding an
additional registry key that looks like this (my root install folder is
program files for all users and my install path is c:\Program Files\
<<FolderName>>\<<FileName>>.accdr)

root: "all users"
key: "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\
Trusted Locations\Location0"
name: "path"
value: "C:\Program Files\<<FolderName>>\"

i really have no sense if this is correct or not.

greg

Hi,
you can add trusted location during setup, look here:
http://www.granite.ab.ca/Access/developeredition2007faq.htm

hello. i've made a simple access 2007 database which has all of 3
linked
tables in it. i used the developer option to 'package a solution' so i

[quoted text clipped - 20 lines]

never
opens up. any ideas?

 

[kaosyeti via AccessMonster.com]

i'm having a logic problem with this. what can i put as the value of "path"
if i set up my install package to just the current user, not all users. how
do i know what the name of the user is? is there a wildcard i can use for
this?

Hi,
well, I don't have PDW around to check, but I think should be:

root: "current user"
key: "Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0"
name: "path"
value: "C:\Program Files\<<FolderName>>\"

have a lok here also:
http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations

first off, thanks for your help. this is where i was guessing the problem
was.

[quoted text clipped - 29 lines]

 

[Alex Dybenko]

Hi,
if you would use current user as root - then this will be a user, who
running setup.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

i'm having a logic problem with this. what can i put as the value of
"path"
if i set up my install package to just the current user, not all users.
how
do i know what the name of the user is? is there a wildcard i can use for
this?

Hi,
well, I don't have PDW around to check, but I think should be:

root: "current user"
key: "Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0"
name: "path"
value: "C:\Program Files\<<FolderName>>\"

have a lok here also:
http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations

first off, thanks for your help. this is where i was guessing the
problem
was.

[quoted text clipped - 29 lines]

never
opens up. any ideas?

 

[kaosyeti via AccessMonster.com]

i'm sorry, but i still don't understand. don't i have to know what the full
path is before i publish the runtime version of the database? for example,
if the path is on my pc at work, the path is:

C:\Documents and Settings\Greg\Documents\...etc...

what would i put as the path name that will allow anyone to install this on a
pc, no matter what the user name is? is there a wildcard (or a prompt) i can
put in for "Greg"?? thanks again.


greg

Hi,
if you would use current user as root - then this will be a user, who
running setup.

i'm having a logic problem with this. what can i put as the value of
"path"

[quoted text clipped - 21 lines]

 

[Alex Dybenko]

Hi,
Look at PDW documentation, I think there is a "variable" like $user, which
substituted with current user when he run a setup. Do not have PDW around,
can check at Monday only

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

i'm sorry, but i still don't understand. don't i have to know what the
full
path is before i publish the runtime version of the database? for
example,
if the path is on my pc at work, the path is:

C:\Documents and Settings\Greg\Documents\...etc...

what would i put as the path name that will allow anyone to install this
on a
pc, no matter what the user name is? is there a wildcard (or a prompt) i
can
put in for "Greg"?? thanks again.


greg

Hi,
if you would use current user as root - then this will be a user, who
running setup.

i'm having a logic problem with this. what can i put as the value of
"path"

[quoted text clipped - 21 lines]

never
opens up. any ideas?

 

[kaosyeti via AccessMonster.com]

um... what, exactly, is PDW? it's not ringing a bell with me...

greg

Hi,
Look at PDW documentation, I think there is a "variable" like $user, which
substituted with current user when he run a setup. Do not have PDW around,
can check at Monday only

i'm sorry, but i still don't understand. don't i have to know what the
full

[quoted text clipped - 21 lines]

 

[Robert Morley]

PDW = Packaging & Deployment Wizard (or words to that effect). It's the
thing you used in your initial post when you said you "package[d] a solution".


Rob

um... what, exactly, is PDW? it's not ringing a bell with me...

greg

Hi,
Look at PDW documentation, I think there is a "variable" like $user, which
substituted with current user when he run a setup. Do not have PDW around,
can check at Monday only

i'm sorry, but i still don't understand. don't i have to know what the
full

[quoted text clipped - 21 lines]

never
opens up. any ideas?