Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / June 2008

Tip: Looking for answers? Try searching our database.

2007 Packaging Wizard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Valentine - 30 Apr 2008 07:54 GMT
Group:

I am having trouble with the 2007 Packaging Wizard when I install my
application on a computer running Vista. When my application is installed in
the Program Files Folder my application is Read Only. I can't have my
program run in Read Only mode. Is there a way to have the Packaging Wizard
install the front-end database in the Program Files folder on a Vista
computer and not restrict it to running in Read Only mode?

The 2007 Packaging Wizard will allow me to install my front-end in the root
director of the local drive and it is not restricted to run in Read Only
mode, but why does it restrict my application to run in Read Only mode when
it is installed in the Program Files folder? This doesn't make sense to me.

Thanks,
Bob Valentine
Albert D. Kallal - 30 Apr 2008 10:42 GMT
> Group:
>
[quoted text clipped - 4 lines]
> install the front-end database in the Program Files folder on a Vista
> computer and not restrict it to running in Read Only mode?

This is not a restriction of the package wizard, but a general restrciton of
Vista. Even worse, to get aroudn the locked up program files, Vista will in
fact Virtualize the program files directory. What this means is that for
compatibility purposes, and for security reasons, even if your programs do
in fact start writing to the program files directory, vista actually makes a
virtualized copy and dir attached to the "user" to preserve and
protect the actual the original files installed. What this really means is
then if you actually were to physically copy another access database file to
the directory, you would actually not be able to update the file, but only
be updating a ***copy*** of it. You are for the most part NOT allowed to
make changes to the program dir.

To make a really long complex story short, if you need a writable file, you
cannot install it reliably in the program directory. Simply put, being able
to write into the program directory is what virus heaven is all about.
Allowing user code to update and write data to the program files directory
is a complete thing of the past.

I should point out that several years ago some of my clients had already
locked down the program directory files even in Windows XP, and I found my
access applications failing quite rapidly (in fact, they stopped install
altogether).

In other words, it's not a new thing that some companies and
organizations have 100% locked down any updates to the program directory
area, even with windows xp. The program dir file is considerd fresh meat
for virus stuff, and thus it simply not alloed anymore.

Thus, you have two choices:

Use the application data dir

C:\Documents and Settings\All Users\Application Data

So, you wind up with a path like:

C:\Documents and Settings\All Users\Application
Data\Custmailing\CustomersMailingList.mde

> The 2007 Packaging Wizard will allow me to install my front-end in the
> root director of the local drive and it is not restricted to run in Read
> Only mode, but why does it restrict my application to run in Read Only
> mode when it is installed in the Program Files folder? This doesn't make
> sense to me.

It is not a package wizard issue, it is a issue of security. If you don't
like the application data dir, then your idea to use a c:\directory is quite
a good idea.

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Bob Valentine - 30 Apr 2008 14:29 GMT
Albert:

Thank you for your timely response. When I use my 2002 SageKey installer
scripts for Wise, I am able to install my 2002 Access application in the
Programs File folder on a Vista computer and it is not restricted to running
in Read Only mode. For that reason, I am surprised that I can't do the same
thing with the 2007 Packaging Wizard.

I don't like the new 2007 Ribbon either that is associated with my
application when I use the 2007 Packaging Wizard to install my Access
application. I wish there was the option to use the new Ribbon or to use the
old style menus and toolbars from earlier versions of Access. It seems to be
too difficult to create a custom ribbon for my application.

BobV

>> Group:
>>
[quoted text clipped - 61 lines]
> quite
> a good idea.
Alex Dybenko - 01 May 2008 05:45 GMT
Hi,
sorry, but there is no way to get rid of ribbon, you have to build one.
Agree - it should be option, but no one

Signature

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

> Albert:
>
[quoted text clipped - 83 lines]
>> quite
>> a good idea.
Tony Toews [MVP] - 02 May 2008 02:26 GMT
>Thus, you have two choices:
>
[quoted text clipped - 6 lines]
>C:\Documents and Settings\All Users\Application
>Data\Custmailing\CustomersMailingList.mde

In Vista that's actually C:\Users instead of C:\Documents and Settings

Also Vista won't let users use my Auto FE Updater create shortcuts in
the All Users Desktop.  Thus I suspect other portions of All Users are
also secured.   So you may have to go into
C:\Users\<userid>\Application Data

Tony
Signature

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/

Daisypoo - 16 Jun 2008 00:50 GMT
Whath are you talking bat.
> Group:
>
[quoted text clipped - 13 lines]
> Thanks,
> Bob Valentine

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.