Access Version

  • Thread starter Thread starter Lizzy
  • Start date Start date
L

Lizzy

Hi All!

Currently at work we have a dual operating system in which
we run Access 2000 and Access 97. (I know ! we are behind
the times but are slowly converting all programs to 2000)I
was told there is a way to open up the correct version of
access for an application by implying in the path which
Access version to open the program in. Is this correct? If
it is, how would you word that?
say the path is:
H:\EmployeeFolder\Employee.mde
Thanks for any help!

Lizzy
 
Hi Lizzy,

you can create a desktop shortcut that includes the path
to the correct version of Access followed by the path to
the datbase. For example:

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "c:\MyDB.mdb"

hth

chas
 
Thanks that worked Great!

Lizzy

-----Original Message-----
Hi Lizzy,

you can create a desktop shortcut that includes the path
to the correct version of Access followed by the path to
the datbase. For example:

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "c:\MyDB.mdb"

hth

chas

.
Click to expand...
 
When you double click on an MDB it will open the default (or last
used) version of Access which is not always what you want.

You may like to try this shareware utility:

ACCVER - Allows you to work with
multiple versions of MS Access databases.
Detects the version of Access used to create
your MDB, MDE or MDA files and either reports
the version number or starts the appropriate
version of MS Access.
An additional option allows you to compact
the database from a right-click menu item.
Windows Software from Aylott Computing.

Pick up a copy from:

http://www.aylott.com.au/software.htm

You may also be interested in LISTMDB. This lists all databases on
networks together with their version numbers. Invaluable for your
situation. Get it from the same site.

Lizzy said:
Hi All!

Currently at work we have a dual operating system in which
we run Access 2000 and Access 97. (I know ! we are behind
the times but are slowly converting all programs to 2000)I
was told there is a way to open up the correct version of
access for an application by implying in the path which
Access version to open the program in. Is this correct?
Click to expand...


,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ (e-mail address removed) (Melbourne, Australia)
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/
 
Lizzy:

You need to create a desktop shortcut with a target looks
like the following, substituting of course the location of
MSACCESS.EXE for Access 2000 and the name/location of your
database (all of this should be on one line):

"C:\Program Files\MS Office
2K\Office\MSACCESS.EXE" /wrkgrp "H:\EmployeeFolder\Employee
..mde" "C:\My Documents\Access
Databases\EmployeeFrontEnd.mdb"

A couple of free tips:
--I usually recommend against using mapped drives for the
location of files, because if there are differences
between different computers it becomes a headache. Use
the UNC instead
(\\NTSERVER\Shared\EmployeeFolder\Employee.mde, for
example.)

--You can make a shortcut similar to the one above that
makes compacting the database easier. Just change the
location of the database from your front end database to
the back end (on the server) and use the switch "/compact"
a the end (w/o quotes). When you double-click the
shortcut, you'll be prompted for the user name and
password. As long as you have administrative privileges,
Access compacts the database and does all the work for
you. You can use the same shortcut text as the line of a
batch file, if you wanted to include compacting as part of
a backup routine.
 
I just realized that I misread your e-mail a bit when
sending your response--you have an 'mde' listed instead of
an 'mdw.' That means you don't need the /wrkgrp switch or
the ensuing portion of the shortcut. Sorry for the
confusion. You should point your shortcut directly to the
mde.

PS--For a significant performance boost, turn your
application into a client-server application instead of
having everyone run the same file off the H: drive.
 
Back
Top