Access 2007 Runtime

[Ryan]

Is there a way to block an access 2007 runtime from opening up databases
other than the one it was packaged with? I've got an application running as
a 2007 runtime and I have noticed that once I install it on a machine, it
will try to open any other mdb files from within the runtime.

The biggest issue here is for the most part my company is still on access
97. I will be distributing the application I built in the 2007 runtime to
other people, but do not want them inadvertantly up-converting legacy
databases.

Any help here would be greatly appreciated.

Thanks
Ryan

 

[Douglas J. Steele]

Unfortunately, the default executable associated with an MDB file is always
changed to the last used version of Access. In other words, if your users
open Access 97, their MDB files will all be associated with Access 97, while
it'll be changed back to Access 2007 after using the runtime.

You might need to look into 3rd party software that will open the database
with the appropriate version of Access.

The ones with which I'm familiar (in order of cost from cheapest to most
expensive) are:

AccessOpener from Black and White Software
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm
Accver from David Aylott http://www.aylott.com.au/software.htm
Total Access Startup from FMS http://www.fmsinc.com/products/startup/

 

[Tony Toews [MVP]]

Accver from David Aylott http://www.aylott.com.au/software.htm

Last time I looked Accver hadn't been updated to handle A2007.

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/

 

[Tony Toews [MVP]]

The biggest issue here is for the most part my company is still on access
97. I will be distributing the application I built in the 2007 runtime to
other people, but do not want them inadvertantly up-converting legacy
databases.

One option would be to place the path of the msaccess.exe in the
shortcuts. That's obviously a PITA but maybe sufficient for your
requirements.

In the target of the shortcut you'd put something like

"C:\Program Files\Microsoft Office 2007\OFFICE12\MSACCESS.EXE" "Q:\1
access\Fleet Mgmt\Service.mdb"

But you'd also need to do the same thing for the A97 shortcuts.
Obviously this won't help you if users use Windows Explorer to open
MDB/MDEs.

Also there will be a delay as the users switch between A97 and A2007.
Ensure you have the A2007SP1 runtime installed to minimize this delay.

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/

 

[Ryan]

Thanks for your help guys.

One option would be to place the path of the msaccess.exe in the
shortcuts. That's obviously a PITA but maybe sufficient for your
requirements.

In the target of the shortcut you'd put something like

"C:\Program Files\Microsoft Office 2007\OFFICE12\MSACCESS.EXE" "Q:\1
access\Fleet Mgmt\Service.mdb"

But you'd also need to do the same thing for the A97 shortcuts.
Obviously this won't help you if users use Windows Explorer to open
MDB/MDEs.

Also there will be a delay as the users switch between A97 and A2007.
Ensure you have the A2007SP1 runtime installed to minimize this delay.

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/

 

[Nicholas Meyer]

nice radio station 97.1

Thanks for your help guys.