Unrecoginzed Data Base

G

George

I have a data base that I am running on an office LAN. It
was created on my home computer using Office 2000 and the
LAN is running Office 2000. When I try to open the file by
double clicking on the file or using a Desk Top icon on
our LAN I get a "Unrecognized Database" error message. If
I first open Microsoft Access and then surf to my file and
select open it starts and runs ok. I posted this question
the other day and it was susgested that I may have Office
97 and Office 2000 loaded on the same computer, I checked,
we don't. The following was suggested from our computer
group

"Access 2000 is different. U have to create a commandline
in the shortcut icon your using which opens access first
then points to your file. Or you can seal the program into
an executable.

Not sure how to perform either step or if this is even a
valid solution. Does this sound right ? How do you convert
an Access database into an Executable File ?

Thanks - George
 
D

Douglas J. Steele

Your computer group is wrong.

It's not possible to "seal the program into an executable" with Access
(never has been), and there's no actual requirement to create a shortcut:
double-click on the MDB file will open it fine.

However, there's no reason not to try the shortcut approach. You'll need
"full path to msaccess.exe" "full path to your application" in the shortcut:

"C:\Program Files\Office\Office\MSAccess.exe"
"C:\Documents\Applications\MyApp.MDB"
 
6

'69 Camaro

Hi, George.

When you double-click the icon, you're ordering the operating system to
"open this file using only the default settings on this computer." Your
computer's defaults are set to a version of Access prior to Access 2K, which
is why you receive the "Unrecognized database format" error message when the
database was created in Access 2K. Your computer's default is probably
Access 97.

Either use commands that tell the operating system which version of Access
to use (such as the Help Desk's suggestion to use a shortcut explicitly
identifying the path and file name of the executable) or change your
computer's default settings (not recommended, unless you own the computer
_and_ you know what you are doing).

Find the path for your Access 2K executable file and use that for your
Windows shortcuts to open the Access 2K databases, whether they are located
on the LAN or your hard drive.
Or you can seal the program into
an executable.
Click to expand...

This is overkill. Just use a Windows shortcut.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
B

Brendan Reynolds

There is definitely an earlier version of Access involved here, George,
either retail, or runtime. Which edition of Office 2000 are you using at the
office - Standard, Professional, Small Business ... ?

What is happening is that the most recent version of Access to run on the
system makes itself the default version associated with MDB files, and when
you double click the MDB file, Windows attempts to open it using that
version of Access. If the most recently used version was the earlier
version, it will be unable to open the Access 2000 MDB.

Using a shortcut icon would work. The easiest way to create a shortcut icon
is to find the correct version of the main Access executable, MSACCESS.EXE,
right-click it, and drag it to your desktop. When you release the right
mouse button, choose the option "Create Shortcut Here". Now right-click the
shortcut, and choose Properties. In the Properties dialog box, the Target
text box will contain the full path to MSACCESS.EXE, enclosed in double
quotes. At the end of that line, *after* the closing double quotes, you need
to add a space, then the full path to the MDB you want to open. This path
will also need to be enclosed in quotes if there are any spaces in the
folder names or file name. The whole thing will end up looking something
like this ...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\TestFolder\TestMDB.MDB"

The phrase 'seal the program into an executable' has no meaning.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
G

George

-----Original Message-----
There is definitely an earlier version of Access involved here, George,
either retail, or runtime. Which edition of Office 2000 are you using at the
office - Standard, Professional, Small Business ... ?

What is happening is that the most recent version of Access to run on the
system makes itself the default version associated with MDB files, and when
you double click the MDB file, Windows attempts to open it using that
version of Access. If the most recently used version was the earlier
version, it will be unable to open the Access 2000 MDB.

Using a shortcut icon would work. The easiest way to create a shortcut icon
is to find the correct version of the main Access executable, MSACCESS.EXE,
right-click it, and drag it to your desktop. When you release the right
mouse button, choose the option "Create Shortcut Here". Now right-click the
shortcut, and choose Properties. In the Properties dialog box, the Target
text box will contain the full path to MSACCESS.EXE, enclosed in double
quotes. At the end of that line, *after* the closing double quotes, you need
to add a space, then the full path to the MDB you want to open. This path
will also need to be enclosed in quotes if there are any spaces in the
folder names or file name. The whole thing will end up looking something
like this ...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\TestFolder\TestMDB.MDB"

The phrase 'seal the program into an executable' has no meaning.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E- mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e- mail, you'll find
a useable e-mail address at the URL above.





.
Click to expand...
 
Top