473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Error 3219 Operation not allowed in this context

6
Hi,

I'm getting this error when trying to requery. Any suggestions on where this is coming from?
Aug 7 '07 #1
2 3943
Dököll
2,364 Expert 2GB
Hi,

I'm getting this error when trying to requery. Any suggestions on where this is coming from?
Greetings, LOCAFO!

What are you querying? What language are you using?
Aug 8 '07 #2
LOCAFO
6
I'm using vb6. It is so strange. The application works in one building without problems but in another building down the street they are getting this error (they are running the same files and on the same SQL Server database.


When the users pull down the data and make modifications to the form, they receive this error. The code in the user control (ctlPropLandTab) requery routine is as follows.
-----------------------------------------------------------
Public Sub Requery()
On Error GoTo Requery_Error

m_CasePropLand.Requery


Requery_Exit:
Exit Sub

Requery_Error:
Beep
msg = "ctlPropLandyTab: Requery_Error - BK-ER-" & Format(X, "000") & ": " & Err & vbCrLf & Error
MsgBox "Critical Error - BK-ER-" & Format(X, "000") & ": " & Err & vbCrLf & Error, vbCritical, "Critical Error - ctlPropLandTab: Requery_Error"
Resume Next
End Sub

------------------------------------------------------

m_CasePropLand is linked to a class module (clsCasePropLand)

This is the code for the Requery routine in the class module (clsCasePropLand)

Public Sub Requery()
adoPrimaryRS.Requery
DataMemberChanged "Primary"
End Sub



Thanks
Aug 8 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
3
by: Steve - DND | last post by:
I was wondering if anyone can point me to some articles or practices they use for dealing with errors in their applications; particularly in an n-tier design. I am trying to find one way to...
1
by: Dave | last post by:
I have a ASP.net application that work fine with IIS 5.0. I'm trying to put it on IIS 6.0. And getting the following error. ASP is enable It is in a virtual directory - I also follow the...
0
by: HKSHK | last post by:
This list compares the error codes used in VB.NET 2003 with those used in VB6. Error Codes: ============ 3: This Error number is obsolete and no longer used. (Formerly: Return without GoSub)...
3
by: doomster | last post by:
Hi, Recently we upgraded our Windows 2000 servers to Windows 2003. One of our websites which was working fine previouslyis now displaying ... 'Server Error in '/' Application' along with with...
669
by: Xah Lee | last post by:
in March, i posted a essay “What is Expressiveness in a Computer Languageâ€, archived at: http://xahlee.org/perl-python/what_is_expresiveness.html I was informed then that there is a academic...
4
by: stephen | last post by:
Hi, I am getting an error while trying to create an excel file. "Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the...
2
by: Spam Catcher | last post by:
Anyone know what this error means? The Undo operation encountered a context that is different from what was applied in the corresponding Set operation. The possible cause is that a context was...
0
by: ajoealex | last post by:
Server Error in '/' Application. -------------------------------------------------------------------------------- Security Exception Description: The application attempted to perform an...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.