Can Not Open Database

**Tom van Stiphout** · Mar 15 '07, 02:55 AM

Re: Can Not Open Database

On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
wrote:

Just curious: what would it take for you to divulge the exact error
message? Rather have us guess at it?

-Tom.

>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
>

**Steve** · Mar 15 '07, 05:35 PM

Re: Can Not Open Database

No Problem!

Error# 3197

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

Note: the database is a single user application.

Thanks!

"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
news:ebchv2purq lktiqpj4afmk3qn um036v4g9@4ax.c om...

On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
wrote:
>
Just curious: what would it take for you to divulge the exact error
message? Rather have us guess at it?
>
-Tom.
>
>
>

>>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
>>

>

**Steve** · Mar 15 '07, 05:35 PM

Re: Can Not Open Database

No Problem!

Error# 3197

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

Note: the database is a single user application.

Thanks!

"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
news:ebchv2purq lktiqpj4afmk3qn um036v4g9@4ax.c om...

On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
wrote:
>
Just curious: what would it take for you to divulge the exact error
message? Rather have us guess at it?
>
-Tom.
>
>
>

>>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
>>

>

**ManningFan** · Mar 15 '07, 07:25 PM

Re: Can Not Open Database

On Mar 15, 1:25 pm, "Steve" <s...@private.e mailaddresswrot e:

No Problem!
>
Error# 3197
>
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."
>
Note: the database is a single user application.
>
Thanks!

See if there's an LDB file in the same directory. If there is, delete
it and then try to open the file.

**Steve** · Mar 16 '07, 03:45 AM

Re: Can Not Open Database

Thanks for responding!

I have not been able to open the database since I received it so no LDB file
has ever been created.(I cheched - there is no LDB file.)

Steve

"ManningFan " <manningfan@gma il.comwrote in message
news:1173986274 .882418.234970@ b75g2000hsg.goo glegroups.com.. .

On Mar 15, 1:25 pm, "Steve" <s...@private.e mailaddresswrot e:

>No Problem!
>>
>Error# 3197
>>
>"The Microsoft Jet database engine stopped the process because you and
>another user are attempting to change the same data at the same time."
>>
>Note: the database is a single user application.
>>
>Thanks!

>
See if there's an LDB file in the same directory. If there is, delete
it and then try to open the file.
>
>

**Tom van Stiphout** · Mar 16 '07, 03:45 AM

Re: Can Not Open Database

On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <sorry@private. emailaddress>
wrote:

This can happen when you have two forms open, both in edit mode on the
same table. Going into edit mode could be caused by (typically bad)
code, rather than the user.

-Tom.

>No Problem!
>
>Error# 3197
>
>"The Microsoft Jet database engine stopped the process because you and
>another user are attempting to change the same data at the same time."
>
>Note: the database is a single user application.
>
>Thanks!
>
>
>
>
>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>news:ebchv2pur qlktiqpj4afmk3q num036v4g9@4ax. com...

>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
>wrote:
>>
>Just curious: what would it take for you to divulge the exact error
>message? Rather have us guess at it?
>>
>-Tom.
>>
>>
>>

>>>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
>>>

>>

>

**Steve** · Mar 16 '07, 01:55 PM

Re: Can Not Open Database

That's what I originally said I thought the problem is. 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

"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
news:nuvjv2hvco nvljaojm5sghshi m0j9su7gs@4ax.c om...

On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <sorry@private. emailaddress>
wrote:
>
This can happen when you have two forms open, both in edit mode on the
same table. Going into edit mode could be caused by (typically bad)
code, rather than the user.
>
-Tom.
>
>

>>No Problem!
>>
>>Error# 3197
>>
>>"The Microsoft Jet database engine stopped the process because you and
>>another user are attempting to change the same data at the same time."
>>
>>Note: the database is a single user application.
>>
>>Thanks!
>>
>>
>>
>>
>>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>>news:ebchv2pu rqlktiqpj4afmk3 qnum036v4g9@4ax .com...

>>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
>>wrote:
>>>
>>Just curious: what would it take for you to divulge the exact error
>>message? Rather have us guess at it?
>>>
>>-Tom.
>>>
>>>
>>>
>>>>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
>>>>
>>>

>>

>

**Tom van Stiphout** · Mar 16 '07, 01:55 PM

Re: Can Not Open Database

On Fri, 16 Mar 2007 13:10:54 GMT, "Steve" <sorry@private. emailaddress>
wrote:

Oh, right, I had forgotten about that. I re-read your OP and it seems
to me you should not get this error when trying to link to the tables.
Therefore I think the db is corrupt, and it may be quicker to restore
a backup.
You might want to try /readonly as a command line switch.
There is no special MDW involved here, right?
You have the same problems on another PC?

-Tom.

>That's what I originally said I thought the problem is. 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
>
>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>news:nuvjv2hvc onvljaojm5sghsh im0j9su7gs@4ax. com...

>On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <sorry@private. emailaddress>
>wrote:
>>
>This can happen when you have two forms open, both in edit mode on the
>same table. Going into edit mode could be caused by (typically bad)
>code, rather than the user.
>>
>-Tom.
>>
>>

>>>No Problem!
>>>
>>>Error# 3197
>>>
>>>"The Microsoft Jet database engine stopped the process because you and
>>>another user are attempting to change the same data at the same time."
>>>
>>>Note: the database is a single user application.
>>>
>>>Thanks!
>>>
>>>
>>>
>>>
>>>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>>>news:ebchv2p urqlktiqpj4afmk 3qnum036v4g9@4a x.com...
>>>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
>>>wrote:
>>>>
>>>Just curious: what would it take for you to divulge the exact error
>>>message? Rather have us guess at it?
>>>>
>>>-Tom.
>>>>
>>>>
>>>>
>>>>>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
>>>>>
>>>>
>>>

>>

>

**Steve** · Mar 17 '07, 12:35 AM

Re: Can Not Open Database

Regarding trying to link to the tables - anything that tries to open the
database raises the error.

There is no special MDW involved here!

Same problem on other PCs.

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

Steve

"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
news:jq7lv29fs3 qo1inqg4qtpa15s g3r422t58@4ax.c om...

On Fri, 16 Mar 2007 13:10:54 GMT, "Steve" <sorry@private. emailaddress>
wrote:
>
Oh, right, I had forgotten about that. I re-read your OP and it seems
to me you should not get this error when trying to link to the tables.
Therefore I think the db is corrupt, and it may be quicker to restore
a backup.
You might want to try /readonly as a command line switch.
There is no special MDW involved here, right?
You have the same problems on another PC?
>
-Tom.
>
>
>

>>That's what I originally said I thought the problem is. 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
>>
>>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>>news:nuvjv2hv convljaojm5sghs him0j9su7gs@4ax .com...

>>On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <sorry@private. emailaddress>
>>wrote:
>>>
>>This can happen when you have two forms open, both in edit mode on the
>>same table. Going into edit mode could be caused by (typically bad)
>>code, rather than the user.
>>>
>>-Tom.
>>>
>>>
>>>>No Problem!
>>>>
>>>>Error# 3197
>>>>
>>>>"The Microsoft Jet database engine stopped the process because you and
>>>>another user are attempting to change the same data at the same time."
>>>>
>>>>Note: the database is a single user application.
>>>>
>>>>Thanks!
>>>>
>>>>
>>>>
>>>>
>>>>"Tom van Stiphout" <no.spam.tom774 4@cox.netwrote in message
>>>>news:ebchv2 purqlktiqpj4afm k3qnum036v4g9@4 ax.com...
>>>>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <sorry@private. emailaddress>
>>>>wrote:
>>>>>
>>>>Just curious: what would it take for you to divulge the exact error
>>>>message? Rather have us guess at it?
>>>>>
>>>>-Tom.
>>>>>
>>>>>
>>>>>
>>>>>>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
>>>>>>autoexe c
>>>>>>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
>>>>>>setting s.
>>>>>>
>>>>>>1. Is there any way from an external database to look at the
>>>>>>propertie s
>>>>>>of
>>>>>>the problem database to see if the AllowBypassKey is disabled?
>>>>>>
>>>>>>2. Is there a way from command line parameters or an external
>>>>>>databas e
>>>>>>to
>>>>>>reset AllowBypassKey if it is disabled?
>>>>>>
>>>>>>3. Any ideas on how to break into the problem database?
>>>>>>
>>>>>>Thanks!
>>>>>>
>>>>>>Steve
>>>>>>
>>>>>
>>>>
>>>

>>

>

**lyle fairfield** · Mar 17 '07, 01:45 PM

Re: Can Not Open Database

"Steve" <sorry@private. emailaddresswro te in
news:WHGKh.1343 3$tD2.1731@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_Start_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** · Mar 17 '07, 02:05 PM

Re: Can Not Open Database

Thanks for responding!

What is "TTBOMK"?

"lyle fairfield" <lylefair@yahoo .cawrote in message
news:ohSKh.7226 $Sm.4209@read1. cgocable.net...

"Steve" <sorry@private. emailaddresswro te in
news:WHGKh.1343 3$tD2.1731@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_Start_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** · Mar 17 '07, 02:55 PM

Re: Can Not Open Database

"Steve" <sorry@private. emailaddresswro te in
news:izSKh.1283 38$_73.97695@ne wsread2.news.pa s.earthlink.net :

What is "TTBOMK"?

TTBOMK = "to the best of my knowledge"

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

Can Not Open Database

Can Not Open Database

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment