473,769 Members | 3,350 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How come I sometimes get this?? "Run-time error 3211: can't lock table. "

My app is giving me this error.

Run-time error 3211:
The database engine could not lock table 'Sorted_Templat e' because it is
already in use by another person or process.

When I run the app the first time through, it runs fine. I get this when I
run a make-table query that tries to write out the table called
"Sorted_Templat e". I tried using a TableDefs.Delet e command thinking that
make using the docmd.openquery was causing the problem. But it cannot
delete the table either - I get the same error msg.

The table at this point should not be in use by another process and I am the
only user. So what gives? I am using this in an automation project but at
this point I am not calling any other MS Office apps. But I do establish a
recordset variable early in the code. It is closed and the var set to
nothing when the sub ends so I do not see how that is the problem.

Any ideas?

Thanks
Nov 13 '05 #1
0 4353

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

Similar topics

4
2688
by: SiuLoBow | last post by:
Hi, Is there anyway to detect the ActiveX control is able to run on the browser or not? After I installed the ActiveX control to my system, user sometimes switch the secruity setting to "not able to run ActiveX control". So, the ActiveX control just show on the broswer, but not able to run it. I want to find a way to detect it. And prompt the user a message telling
0
1032
by: cilorentson | last post by:
I would like to be able to do this. Run two printers on one computer, in reality one would be a backup. I have a printer that prints very well, and then a printer that is a 'copier,scanner,printer', and I would just like to be able to use one or the other as need arises. I just plug in the older printer, and then did the 'default' thing, but the printer is not printing. ?? When I try to delete/cancel the job, it will not. ?? The...
6
1827
by: ajikoe | last post by:
def f(x,y): return math.sin(x*y) + 8 * x I have code like this: def main(): n = 2000 a = zeros((n,n), Float) xcoor = arange(0,1,1/float(n)) ycoor = arange(0,1,1/float(n))
1
1109
by: Carlos Gomez | last post by:
I'm using Visual Studio .NET to make a C++ DirectX application. My problem is that sometimes when I hit RUN, the application begin loading but doesn't show on the desktop, almost as if I had set the Visible attribute to False. It isn't the code because to make it show all I have to do is hit STOP and RUN again and most probably it will run fine, without changing a single line of code. Has anyone encountered a similar problem? Btw, I...
1
993
by: Brett | last post by:
Is there a way to disable the run in VS.NET 2003 for ASP.NET apps? Everytime I run an ASP.NET app, it freezes my machine. I avoid the run but sometimes I do it by accident so I need it disabled. Or if I could have the preview change from localhost to 127.0.0.1 that would be nice. It works that way. Any suggestions? Thanks, Brett
2
988
by: Jarod | last post by:
Hello I've a strange problem when I try to start a program using F5 or using menu start debug the program starts or it looks like it was started but no form is shown. Sometimes all thing works fine but sometimes they not.I did't find any rule for it.It just happen. When I press stop and then run again it usually works fine. I am using VB.Net 2002 professional. Jarod
7
1472
by: jw | last post by:
//it sometimes crashes sometimes not why? #include<iostream> #include<fstream> #include<vector> #include<string> #include<ctime> using namespace std; #ifndef NULL #define NULL (short) 0 #endif
2
1157
by: Grant Merwitz | last post by:
Hi I am currently offering a download of an executable. This is linked directly through HTML: <a href='/downloads/install.exe'>DOWNLOAD</a> Now, we have some problems when a user clicks "RUN" and not "SAVE". Is it possible to disable this run option?
7
1830
by: Brian Shafer | last post by:
I have VS2005 installed on my destop and on my laptop. I created this app with my desktop and i don't get this. Run the IDE on my laptop and this is what I get? Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.
10
2199
klarae99
by: klarae99 | last post by:
I am working on an Inventory Database in Access 2003. I am having trouble with a report I designed to show current inventory in stock. I have a form (frmInventory) that is unbound. There are four combo boxes on this form that allow the user to select Location, Vendor, Category and SubCategory. These selections (or blank fields) are then passed on to a query (see SQL below) and a report opens to show the inventory. This worked really well...
0
10223
Oralloy
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...
0
10051
jinu1996
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...
1
10000
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,...
0
8879
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7413
isladogs
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...
0
5310
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5448
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3571
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
bsmnconsultancy
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...

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.