Re: Deploying Access 2007 Runtime / developer extensions / basic MSI installer questions

lgeastwood@xxxxxxxxx wrote:

I'm kinda like Andy there with some homework to do on NT.
However I think I can get my app deployed OK to the alluser Dir with
the INNO Compiler using the environment variable path method.

Sure however can the user then do updates to the FE? That is pulling down a new copy
of the FE from the server into that folder? What if there are temp tables in the
FE? That folder might be a read only folder to regular users.

The next hurdle now is linked tables.
How does Access treat varying environment variables for the linked BE?
Currently I link to C:\MyAppFolder\MyBE.accdb.
If I set linked tables in Access to C:\Documents and Settings\All Users
\Application Data\MyBE.accdb will Vista users run into problems?

1) You would have to use the API call to ensure you had the correct folder because
Vista uses a totally different folder name. User as I recall.

2) I would use a routine which looks for all MDBs within the specified folder,
attempts to open a table within the MDB, ensures it isn't a FE and the link to that
MDB. This way the user doesn't have to do any thinking. And novice users need all
the hand holding they can get.

3) Again the the All Users folder might be read only to the users.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • RE: Backups
    ... This is Steven from Microsoft Access Technical Support replying to your ... You may want to consider reposting your question to the following newsgroup: ... Monday folder, and so on. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: new developer needs help
    ... I then have another database that contains forms/queries/modules. ... the My Documents folder. ... and drop that file in to the above mentioned My Documents sub folder. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Splitting Access 2007 dB on Citrix network
    ... What is the best way to split the dB for a Citrix network? ... 'Home' folder that only they have access to. ... file server, which could be thousands of miles from the Citrix/Terminal Server ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Replication as a Performance Enhancer?
    ... specific folder on the same file folder as the backend. ... MDB in your app. ... very temporary data such as parameters for a report. ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Package installation location and VISTA
    ... considered a "sensitve" location on VISTA I need to find another location to ... My Auto FE Updater got caught in such a problem a number of years ago ... data folder and it is a hidden folder so it makes troubleshooting with the ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)