runtime issues when linking tables

G

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?
 
K

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


Alex said:
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?
 
A

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

kaosyeti via AccessMonster.com said:
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


Alex said:
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?
 
K

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?

Alex said:
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]
 
A

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

kaosyeti via AccessMonster.com said:
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?

Alex said:
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?
 
K

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



Alex said:
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]
 
A

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

kaosyeti via AccessMonster.com said:
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



Alex said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top