Opening Access with 97

[Guest]

Hello.

I have some users who have access 97 and 2000 on their computer. Database is
created in 2000. I have a batch file which opens the database, but because
their computer is default to open wiht 97, they get "unrecongized format"
error.

in my batch file the code is :
start "MSACCESS.EXE" "C:\My Documents\Test.mdb

How can I make it where everyone's computer will open with accesss 2000?

Thank you

 

[tshillam]

Hello.

I have some users who have access 97 and 2000 on their computer. Database is
created in 2000. I have a batch file which opens the database, but because
their computer is default to open wiht 97, they get "unrecongized format"
error.

in my batch file the code is :
start "MSACCESS.EXE" "C:\My Documents\Test.mdb

How can I make it where everyone's computer will open with accesss 2000?

Thank you

Georgia,

You can't. Microsoft Access 97 users cannot open a 2000 format file.
However, 2000 can open a 97 file. Although, 2000 will likely prompt
these users to convert--not what you want.

What you do is save the 2000 file backwards to a 97 format (backup your
data before-hand). Now make a copy of the 97 file. In the copy, delete
all the tables and link to the original 97 file--you'r splitting the
database into two parts (a front-end and back-end file).

The front-end is installed on the user's computer. Meanwhile, the
back-end is saved to a network file server in a shared folder.

Do a little more searching on 'front-end' and 'back-end'.

gotta run,

Todd

 

[tshillam]

Hello.

I have some users who have access 97 and 2000 on their computer. Database is
created in 2000. I have a batch file which opens the database, but because
their computer is default to open wiht 97, they get "unrecongized format"
error.

in my batch file the code is :
start "MSACCESS.EXE" "C:\My Documents\Test.mdb

How can I make it where everyone's computer will open with accesss 2000?

Thank you

Georgia,

You can't. Microsoft Access 97 users cannot open a 2000 format file.
However, 2000 can open a 97 file. Although, 2000 will likely prompt
these users to convert--not what you want.

What you do is save the 2000 file backwards to a 97 format (backup your
data before-hand). Now make a copy of the 97 file. In the copy, delete
all the tables and link to the original 97 file--you'r splitting the
database into two parts (a front-end and back-end file).

The front-end is installed on the user's computer. Meanwhile, the
back-end is saved to a network file server in a shared folder.

Do a little more searching on 'front-end' and 'back-end'.

gotta run,

Todd

 

[Graham Mandeno]

Hi Georgia

Todd *was* in a hurry, wasn't he? I don't think he read your question

Specify the full path to the msaccess.exe program file for Access 2000.

You don't need a batch file for this - just create a shortcut and set its
target to:

"C:\Program Files\Microsoft Office\Office9\msaccess.exe" "C:\My
Documents\Test.mdb"

You may need to modify the path to suit the actual location where Access
2000 is installed.

 

[dallas.freeman]

You should be able to include the shortcut with your AccessDB, however
different users may have a different installation path, you should be
able to find a CONSTANT (ie: like %SystemRoot%) that will point to the
installation directory of Office 2000.

Otherwise include a README.txt file will your AccessDB that specifies
to the user to open the AccessDB within Office Access 2000

Hi Georgia

Todd *was* in a hurry, wasn't he? I don't think he read your question

Specify the full path to the msaccess.exe program file for Access 2000.

You don't need a batch file for this - just create a shortcut and set its
target to:

"C:\Program Files\Microsoft Office\Office9\msaccess.exe" "C:\My
Documents\Test.mdb"

You may need to modify the path to suit the actual location where Access
2000 is installed.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello.

I have some users who have access 97 and 2000 on their computer. Database
is
created in 2000. I have a batch file which opens the database, but
because
their computer is default to open wiht 97, they get "unrecongized format"
error.

in my batch file the code is :
start "MSACCESS.EXE" "C:\My Documents\Test.mdb

How can I make it where everyone's computer will open with accesss 2000?

Thank you

 

[Tony Toews]

you should be
able to find a CONSTANT (ie: like %SystemRoot%) that will point to the
installation directory of Office 2000.

There's no system variable for any version of Office.

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