Can Not Open Database

[Steve]

I have a database that raises an error when you try to open it and it
doesn't open. Trying to open the database with the OpenDatabase method
raises the same error. Trying to import any objects (tables, queies, forms,
etc) from the database raises the same error. Trying to link to the tables
in the database raises the same error. I am guessing there is an autoexec
macro or code in the open event of the opening form that contains the error.
Holding down the shift key does not seem to bypass the startup settings.

1. Is there any way from an external database to look at the properties of
the problem database to see if the AllowBypassKey is disabled?

2. Is there a way from command line parameters or an external database to
reset AllowBypassKey if it is disabled?

3. Any ideas on how to break into the problem database?

Thanks!

Steve

[lyle fairfield]

"Steve" <so***@private. emailaddresswro te in
news:WH******** **********@news read1.news.pas. earthlink.net:

Do you know any way to look at the properties of the problem database
from an external database?

Yes, but this is very unlikely to work in the case you have described. It
opens the database from an automated instance of Access, and you have
pointed out that your database will not open.

An example can be found at
http://www.ffdba.com/downloads/Reset...Properties.htm

If I were faced with this problem I would try:

a) a compact (TTBOMK a repair is implicit in this operation) of the
database from another Access Application;
b) a request for the source (of the database that will not open)
organization or person to provide me with a copy that will open;
c) making a zipped copy of the db available on the net (assuming it's not
huge) in hopes that someone who had some spare time and found the problem
interesting or challenging mught solve it;
d) building the database anew; 99.44% of all Access databases are just crap
(example nwind.mdb) so why worry about one that's trashed?;
e) paying an Access recovery service to repair the database; I expect Peter
Miller could solve the problem in a few seconds but I have not seen any
mention of him or his business for quite a long time and I do not know if
his recovery business is active.

[Steve]

Thanks for responding!

What is "TTBOMK"?

"lyle fairfield" <ly******@yahoo .cawrote in message
news:oh******** ********@read1. cgocable.net...

"Steve" <so***@private. emailaddresswro te in
news:WH******** **********@news read1.news.pas. earthlink.net:

>Do you know any way to look at the properties of the problem database
from an external database?

Yes, but this is very unlikely to work in the case you have described. It
opens the database from an automated instance of Access, and you have
pointed out that your database will not open.

An example can be found at
http://www.ffdba.com/downloads/Reset...Properties.htm

If I were faced with this problem I would try:

a) a compact (TTBOMK a repair is implicit in this operation) of the
database from another Access Application;
b) a request for the source (of the database that will not open)
organization or person to provide me with a copy that will open;
c) making a zipped copy of the db available on the net (assuming it's not
huge) in hopes that someone who had some spare time and found the problem
interesting or challenging mught solve it;
d) building the database anew; 99.44% of all Access databases are just
crap
(example nwind.mdb) so why worry about one that's trashed?;
e) paying an Access recovery service to repair the database; I expect
Peter
Miller could solve the problem in a few seconds but I have not seen any
mention of him or his business for quite a long time and I do not know if
his recovery business is active.

[lyle fairfield]

"Steve" <so***@private. emailaddresswro te in
news:iz******** ************@ne wsread2.news.pa s.earthlink.net :

What is "TTBOMK"?

TTBOMK = "to the best of my knowledge"

--
lyle fairfield
-
Ceterum censeo Redmond esse delendam.
-