Acces 97 with Access 2000
Ed Walters
we are not far from ending this, I would like to find the solution to
a couple of problems we have had
Each user generally uses two databases one in 97 and one in 2000, on
occassions with no real pattern the Icons all go to Access 2000 and on
opening the shortcut the Access 97 database trys to convert which it
can't and the database cannot be opened apart from within the
applicaton itself.
We have tried "Open with", but point it to the Access 97 .exe doesn't
seem to have any effect whatsoever.
Any ideas how to force each database to open in the correct version?
Many thanks Ed
Peter Russell
file it will open with the last version of Access you used.
To overcome this you need to create a shortcut which starts the specific
msaccess.exe file with the database name as an argument.
For example: (all on one line )
"D:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"H:\MyFolder\mydatabase.mdb"
Regards
Peter Russell
David Aylott
You may like to try this shareware utility that will solve your
problem:
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
e...@ikosam.com (Ed Walters) wrote:
>We have Access 97 and Access 2000 running on the same PC and although
>we are not far from ending this, I would like to find the solution to
>a couple of problems we have had
>
>Each user generally uses two databases one in 97 and one in 2000, on
>occassions with no real pattern the Icons all go to Access 2000 and on
>opening the shortcut the Access 97 database trys to convert which it
>can't and the database cannot be opened apart from within the
>applicaton itself.
,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ ng...@bigfoot.com (Melbourne, Australia)
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/
Larry Linson
has a command line that opens the proper MSACCESS. On another machine, I
have separate icons for Access 2.0, Access 97, and Access 2000, and that
works, as well. Would that work for you?
Larry Linson
Microsoft Access
"Ed Walters" <e...@ikosam.com> wrote in message
news:f8a83906.03071...@posting.google.com...
Omey Samaroo
I had the same challenge (two versions of access) but always thought that it
was a silly question and had to work with it . Thank goodness for people
like Ed who asks questions and for people like yourself who share their
wisdom, on forums like these.
I tried and it worked for me. Thanks very much
One of the things that I did was create a shortcut for MSAccess and copied
the line from the Target path then created a shortcut for the database and
pasted the line in front of the Target path for the database allowing a
space between double quote marks and that worked like a charm.
Many thanks Peter and Ed.
Omey
"Peter Russell" <prus...@russellscott.co.uk> wrote in message
news:memo.2003071...@russellscott.btinternet.com...
David Aylott
That method only works if you know which version of Access created the
MDB so you know which shortcut to drag it to.
If you want the process to be totally automatic, 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
"Larry Linson" <larry....@ntpcug.org> wrote:
>I have separate icons on my desktop for Access 97 and Access 2002... each
>has a command line that opens the proper MSACCESS. On another machine, I
>have separate icons for Access 2.0, Access 97, and Access 2000, and that
>works, as well. Would that work for you?
Wayne Gillespie
This works on Windows 2000 and Windows XP, I don't know about other OS's.
Open Access 97 and close it again. (To make A97 the current default version)
Open Windows Explorer and go to Tools / Folder Options then click on the File
Types tab.
Find the MS Access file type "*.MDB" Click it to highlight the line.
=====================================================
Click the Advance button then click New... (possibly Add...)
In the Action field put Open (Access97)
Use the Browse button and navigate to the Access97 exe file. In my case
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
Click in the field containing this path and move to the end of the path string
and add [space] /nostartup "%1"
Click OK to save the option.
======================================================
Repeat the above enclosed section but this time call it Open (Access 2000) and
browse to the location of the Access 2000 exe.
Repeat again if you also have Access 2002.
Close the edit file type form. Now when you right click an mdb in windows
explorer / my computer the shortcut menu will show your Open 97 and Open 2000
options.
I also have additional options for Compact A97 / A2000 / A2002
eg "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "%1" /compact
and Decompile A97 / A2000 / A2002
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "%1" /decompile
Once you have all the options you want, you need to open Access 2000 and close
it to make it the current default version, then repeat all of the above again.
If you don't do this your new shortcuts will only be seen when A97 is the
current default version.
If you also have A2002 open and close it and repeat again.
The whole operation takes about 5-10 minutes to complete (depending on how many
options you create) but when done, you can open / compact / decompile any mdb
with whatever version you require directly from explorer.
It is not the perfect solution to your problem, but it is very handy none the
less, especially for developing in various versions.
Wayne Gillespie
Gosford NSW Australia
Omey Samaroo
"David Aylott" <ng...@bigfoot.com> wrote in message
news:01dhhv03sej2pm7ng...@4ax.com...