472,373 Members | 1,983 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,373 software developers and data experts.

Error "Could not save; currently locked by another user."

One of our application uses VB6 and Access97 database. Another application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read either
a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot find
the input table or query 'myTable'. Make sure it exists and that its name
is spelled correctly." Also, I got the error "The Microsoft Jet database
engine cannot find the input table or query 'myQuery'. Make sure it exists
and that its name is spelled correctly." The error happens to all the tables
and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to open a
table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the existing
tables and queries for about 15 seconds ?

Thank you.
Sep 10 '08 #1
11 4800
Was anyone modifying the table itself - or had the table opend up in design
mode with access?
Access would lock the mdb file on you like that I believe.

Might be a good test - log everyone out - go into access and open up the
file, abnd a table and then try to run your program.
Someone may have inadvertantly run something thru microsoft word or
something against your table?
"fniles" <fn****@pfmail.comwrote in message
news:eR**************@TK2MSFTNGP04.phx.gbl...
One of our application uses VB6 and Access97 database. Another application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read
either a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot
find the input table or query 'myTable'. Make sure it exists and that its
name is spelled correctly." Also, I got the error "The Microsoft Jet
database engine cannot find the input table or query 'myQuery'. Make sure
it exists and that its name is spelled correctly." The error happens to
all the tables and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to open
a table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the existing
tables and queries for about 15 seconds ?

Thank you.

Sep 10 '08 #2
On Wed, 10 Sep 2008 09:49:59 -0500, "fniles" <fn****@pfmail.comwrote:

One of our application uses VB6 and Access97 database. Another application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read either
a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot find
the input table or query 'myTable'. Make sure it exists and that its name
is spelled correctly." Also, I got the error "The Microsoft Jet database
engine cannot find the input table or query 'myQuery'. Make sure it exists
and that its name is spelled correctly." The error happens to all the tables
and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to open a
table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the existing
tables and queries for about 15 seconds ?

Is this a multi-user database located on a network or is it a single user database on a local
machine?
Paul
~~~~
Microsoft MVP (Visual Basic)
Sep 10 '08 #3
It's a multi user database located on a network.

"Paul Clement" <Us***********************@swspectrum.comwrote in message
news:m8********************************@4ax.com...
On Wed, 10 Sep 2008 09:49:59 -0500, "fniles" <fn****@pfmail.comwrote:

One of our application uses VB6 and Access97 database. Another
application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read
either
a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot
find
the input table or query 'myTable'. Make sure it exists and that its
name
is spelled correctly." Also, I got the error "The Microsoft Jet database
engine cannot find the input table or query 'myQuery'. Make sure it
exists
and that its name is spelled correctly." The error happens to all the
tables
and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to
open a
table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the
existing
tables and queries for about 15 seconds ?

Is this a multi-user database located on a network or is it a single user
database on a local
machine?
Paul
~~~~
Microsoft MVP (Visual Basic)

Sep 10 '08 #4
>Someone may have inadvertantly run something thru microsoft word or
>something against your table?
What did you mean by run something thru microsoft word ?
"Miro" <mi**@beero.comwrote in message
news:uf**************@TK2MSFTNGP03.phx.gbl...
Was anyone modifying the table itself - or had the table opend up in
design mode with access?
Access would lock the mdb file on you like that I believe.

Might be a good test - log everyone out - go into access and open up the
file, abnd a table and then try to run your program.
Someone may have inadvertantly run something thru microsoft word or
something against your table?
"fniles" <fn****@pfmail.comwrote in message
news:eR**************@TK2MSFTNGP04.phx.gbl...
>One of our application uses VB6 and Access97 database. Another
application uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read
either a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot
find the input table or query 'myTable'. Make sure it exists and that
its name is spelled correctly." Also, I got the error "The Microsoft Jet
database engine cannot find the input table or query 'myQuery'. Make
sure it exists and that its name is spelled correctly." The error happens
to all the tables and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to
open a table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the
existing tables and queries for about 15 seconds ?

Thank you.


Sep 10 '08 #5
I beleive Microsoft word treats mdb files like excel when you start using
them as a data source for data.

It locks the file and makes a file.
just like if you had a pure excel file - and open it...it creates like a
2ndary file of it. Once you close excel the 2ndary temp file disappears.
But the whole file is locked until you do.

Someone could be running something on your file thru excel or word perhaps?

It is a file on the network - thus giving everyone full rights to the file,
and you are trusting the do not go to the file and hit 'delete' or
'whatever' to it.

I am assuming you are under the assumption that the users only use your
'program' to access the data.
That assumption may be incorrect. ( If my first assumption is true :-) )

One easy idea might be to rename the mdb file to be something like
yourfilename.bla and let your program open the file.
That way if someone tries to look for mdb files to open with word, it
searches for *.mdb and it wont come up. They will have to know your 'bla'
file is an mdb file and change the search to *.* and select it. Of course -
then you are in the same boat, but it might help you find out if someone is
using an external program to access the access database.
If you change the file name...someone ( if inderectly using the access
table ) without knowing it... might ask a question like "my program stopped
working/ my word document / my excel"

Just a thought. But again - i could be totally off and I could be leading
you down the wrong path.

It may be something totally not related...but my first assumption would be
that someone did have that 'file' locked thru another program.
Perhaps ask the users what else they are running and see if something pops
up?

"fniles" <fn****@pfmail.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
Someone may have inadvertantly run something thru microsoft word or
something against your table?
What did you mean by run something thru microsoft word ?
"Miro" <mi**@beero.comwrote in message
news:uf**************@TK2MSFTNGP03.phx.gbl...
>Was anyone modifying the table itself - or had the table opend up in
design mode with access?
Access would lock the mdb file on you like that I believe.

Might be a good test - log everyone out - go into access and open up the
file, abnd a table and then try to run your program.
Someone may have inadvertantly run something thru microsoft word or
something against your table?
"fniles" <fn****@pfmail.comwrote in message
news:eR**************@TK2MSFTNGP04.phx.gbl...
>>One of our application uses VB6 and Access97 database. Another
application uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read
either a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot
find the input table or query 'myTable'. Make sure it exists and that
its name is spelled correctly." Also, I got the error "The Microsoft Jet
database engine cannot find the input table or query 'myQuery'. Make
sure it exists and that its name is spelled correctly." The error
happens to all the tables and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to
open a table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the
existing tables and queries for about 15 seconds ?

Thank you.


Sep 10 '08 #6

"fniles" <fn****@pfmail.comwrote in message
news:eR**************@TK2MSFTNGP04.phx.gbl...
One of our application uses VB6 and Access97 database. Another application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read
either
a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot
find
the input table or query 'myTable'. Make sure it exists and that its name
is spelled correctly." Also, I got the error "The Microsoft Jet database
engine cannot find the input table or query 'myQuery'. Make sure it
exists
and that its name is spelled correctly." The error happens to all the
tables
and all the queries.
Also, the VB.NET application (uses OLEDB) got an error when trying to open
a
table "Could not save; currently locked by another user."
Then, after the 15 seconds or so, everything worked fine again.

What would cause the above errors ? Why couldn't it recognize the existing
tables and queries for about 15 seconds ?
Most likely a temporary 'dead-lock'.

There may be something useful in these articles:

"How to keep a Jet 4.0 database in top working condition"
http://support.microsoft.com/kb/303528/

"Introduction to .ldb files in Access 2000"
http://support.microsoft.com/kb/208778

-ralph
Sep 10 '08 #7
On Wed, 10 Sep 2008 14:09:09 -0500, "fniles" <fn****@pfmail.comwrote:

It's a multi user database located on a network.


Do all users have full permissions to the folder where the database is located?
Paul
~~~~
Microsoft MVP (Visual Basic)
Sep 10 '08 #8
You can view which user has the file open on shared folders by using
"Computer Management" in Control Panel, or "NET FILE" from the command line.
You can obtain the same information by calling NetFileEnum. Here is a VB6
sample that shows how to call that function:

http://vbnet.mvps.org/code/network/netfileenum.htm
Sep 10 '08 #9
"Full permissions" means permission to rename and delete the file ?
I am not sure.

"Paul Clement" <Us***********************@swspectrum.comwrote in message
news:eq********************************@4ax.com...
On Wed, 10 Sep 2008 14:09:09 -0500, "fniles" <fn****@pfmail.comwrote:

It's a multi user database located on a network.


Do all users have full permissions to the folder where the database is
located?
Paul
~~~~
Microsoft MVP (Visual Basic)

Sep 11 '08 #10

"fniles" <fn****@pfmail.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
"Full permissions" means permission to rename and delete the file ?
I am not sure.
Read/Write and Execute
Sep 11 '08 #11
On Thu, 11 Sep 2008 11:41:43 -0500, "fniles" <fn****@pfmail.comwrote:

"Full permissions" means permission to rename and delete the file ?
I am not sure.

Delete and create on the folder would be required because of the associated .LDB file that is
created/deleted when the database is opened/closed.
Paul
~~~~
Microsoft MVP (Visual Basic)
Sep 12 '08 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Brian Fulford | last post by:
I am trying to deploy a web app with a deployment project since I am including Crystal Reports for .Net. I attached all the merge modules, etc but I am getting a build error when I try to build...
3
by: stash | last post by:
Help - Please! I am trying to run the V8 db2setup script *again* (maybe for the third or fourth time) and it will not re-create the sqllib directory. It always stops with this error: ERROR:Could...
11
by: MLH | last post by:
I copied the following code snippet from A97 HELP. Am getting an error at compile time suggesting there's a problem with the first line (compile error, user-defined type not defined). It is likely...
2
by: VB Programmer | last post by:
I created a simple user control and placed it on another page. Often I get this error: "Could not reformat the document due to line 27. The original format was restored." Line 27 in the...
1
by: dotNetDave | last post by:
I keep getting the following error on one of my web service pages: Parser Error Parser Error Message: Could not create type 'SyPixx.Web.ClearService.ConfigureAlarms'. Source Error: Line 1: ...
3
by: tony | last post by:
Hello! When I build an exe file that use 6 class library dll I get this error. Could not copy temporary files to the output directory. The file 'MeltPracStorage.dll' cannot be copied to the run...
1
by: amindi | last post by:
Hi, I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in...
0
by: Jon Paal | last post by:
error : "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'." using VWD 2005 with sqlexpress 2005 I am trying to create membership roles and users......
2
by: Sejoro | last post by:
Hello, I am trying to write a program that opens a file; reads through it; outputs the text; then outputs the number of lines, words, and characters. Problem is, every time I try to compile, no...
0
by: =?Utf-8?B?eHl6X2phdA==?= | last post by:
I have a winodws service which sends email using Domino. The service is installed using System Account but it is not able to send emails and gives following error - Error Message: Notes error:...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
1
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.