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
12  6223 
On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
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*************@cox.netwrote in message
news:eb********************************@4ax.com...
On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
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*************@cox.netwrote in message
news:eb********************************@4ax.com...
On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
On Mar 15, 1:25 pm, "Steve" <s...@private.emailaddresswrote:
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.
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" <ma********@gmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
On Mar 15, 1:25 pm, "Steve" <s...@private.emailaddresswrote:
>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.
On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:eb********************************@4ax.com.. .
>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
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*************@cox.netwrote in message
news:nu********************************@4ax.com...
On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:eb********************************@4ax.com. ..
>>On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
On Fri, 16 Mar 2007 13:10:54 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:nu********************************@4ax.com.. .
>On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:eb********************************@4ax.com ...
On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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
>
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*************@cox.netwrote in message
news:jq********************************@4ax.com...
On Fri, 16 Mar 2007 13:10:54 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:nu********************************@4ax.com. ..
>>On Thu, 15 Mar 2007 17:25:20 GMT, "Steve" <so***@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*************@cox.netwrote in message
news:eb********************************@4ax.co m...
On Thu, 15 Mar 2007 02:02:28 GMT, "Steve" <so***@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" <so***@private.emailaddresswrote in
news:WH******************@newsread1.news.pas.earth link.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.
Thanks for responding!
What is "TTBOMK"?
"lyle fairfield" <ly******@yahoo.cawrote in message
news:oh****************@read1.cgocable.net...
"Steve" <so***@private.emailaddresswrote in
news:WH******************@newsread1.news.pas.earth link.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" <so***@private.emailaddresswrote in
news:iz********************@newsread2.news.pas.ear thlink.net:
What is "TTBOMK"?
TTBOMK = "to the best of my knowledge"
--
lyle fairfield
-
Ceterum censeo Redmond esse delendam.
- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bailee220 |
last post by:
I have included the following code to open an Access database form from
within an exsisting Access database. But when I run the code, it
appears that it opens the database because in windows...
|
by: Bill |
last post by:
I have three databases running, all with a slightly different
function:
1) Shared Database where data entry is done
2) Data Inventory where information from the Shared Database is loaded
to...
|
by: Kenneth Courville |
last post by:
Hello, I'm looking for assistance with the Access object model. I know
this is VB, but I'm building an Office Add-using C# directed at Access
2002. I'm literate in VB, so you can reply in VB... I...
|
by: Macca |
last post by:
Hi,
I have an windows forms application that accesses a SQL database
I have a few questions as to connecting to the database.
This application will run 24 hours a day. It is a monitoring...
|
by: vvenk |
last post by:
Hello:
When I tried to use an Access database, I get the following exception:
Server Error in '/WebGrid' Application....
|
by: Wayne |
last post by:
Original Post:
The following problem started on my PC about a week ago and I can't
link it to any specific change. I'm using Access XP.
If I have any database open and try to open any other...
|
by: Salad |
last post by:
A97. Split database. Frontend DB1.MDB. Backend DB1BE.MDB. Tables are
linked between DB1 and DB2.
From my testing, if I open DB1 exclusively using /excl the backend
DB1BE is not opened...
|
by: existential.philosophy |
last post by:
This is a new problem for me: I have some queries that open very
slowly in design view.
My benchmark query takes about 20 minutes to open in design view. That
same query takes about 20 minutes...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
