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  6252 
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.c om...
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.c om...
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.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.
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********@gma il.comwrote in message
news:11******** **************@ 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.
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.c om...
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***** *************** ************@4a x.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.c om...
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**** *************** *************@4 ax.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
>>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
>>
>
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 explorer I can see
the database has the .ldb file extension. So it appears that it's open,
but I can't see the database or the form that I've tried to open. What
am I doing wrong. The following is the code:
'This is in the declaration part of...
|
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 throughout the day
3) Top Level database which grabs information from the inventory for
processing
Now, my dilema is that I use 'OpenCurrentDatabase strDB,TRUE' in
|
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 think my problem
mainly lies in knowing the quirks of the Access object model.
Basically, I'm looking for a method of determining if an Access database
is open yet. AND I'm looking for a method that doesn't not require
checking for an...
|
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 application and
will store events that happen in the database (These events happen randomly
without pattern, between 10-50 a day) .
There are a number of situations where the database is accessed.
|
by: vvenk |
last post by:
Hello:
When I tried to use an Access database, I get the following exception:
Server Error in '/WebGrid' Application.
--------------------------------------------------------------------------------
The Microsoft Jet database engine cannot open the file 'D:\Program
Files\Infragistics\NetAdvantage 2005 Volume
2\ASP.NET\Samples\Data\samplebrowser.mdb'. It is already opened exclusively
| | |
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 database by
double clicking its file in Explorer, it takes about 5 seconds to open.
Previously the second database would open almost instantaneously, as
one would expect on a reasonably fast machine.
|
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 exclusively.
If I open DB1 but have no tables open and then open up DB1BE
exclusively, DB1BE will open exclusive. But if I then attempt to open a
linked table in the frontend DB1 I'm informed I can't use the table
because the file is in use.
|
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 to open in datasheet view. As an
experiment, I deleted all rows in all tables; after that, the query
took only seconds to open in both design view and datasheet view. From
these facts, I conclude that Access is evaluating the query when I go
to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
