473,473 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Row Handle Invalid

Hi,

What exactly does the above (subject) error mean? I'm getting it from an
adp file when used by a few people at the same time (each user has the
file in their own filespace though). Access is through windows
authentication and it only seemed to occur during an update of a
specific table.. The problem is it didn't happen to everyone and I
can't recreate it at all on my own, so am wondering if it was something
to do with the level of traffic to/from the server at that specific time.

Any clues?

Cheers,
Chris
Jul 20 '05 #1
4 4080
"Not Me" <no****@nowherefake.addr3s.com> wrote in message
news:cc**********@ucsnew1.ncl.ac.uk...
Hi,

What exactly does the above (subject) error mean? I'm getting it from an
adp file when used by a few people at the same time (each user has the
file in their own filespace though). Access is through windows
authentication and it only seemed to occur during an update of a
specific table.. The problem is it didn't happen to everyone and I
can't recreate it at all on my own, so am wondering if it was something
to do with the level of traffic to/from the server at that specific time.


Further to this, we seem to be getting strange occurences of the subform
jumping between records. For example we're on one record, we tick a checkbox
then suddenly we're on a different record and it's that records' checkbox
that's been edited! This is all on the same table in the same subform....

Please help!!

Chris
Jul 20 '05 #2
Not Me (cl*********@toofgib.moc) writes:
"Not Me" <no****@nowherefake.addr3s.com> wrote in message
news:cc**********@ucsnew1.ncl.ac.uk...
What exactly does the above (subject) error mean? I'm getting it from an
adp file when used by a few people at the same time (each user has the
file in their own filespace though). Access is through windows
authentication and it only seemed to occur during an update of a
specific table.. The problem is it didn't happen to everyone and I
can't recreate it at all on my own, so am wondering if it was something
to do with the level of traffic to/from the server at that specific time.


Further to this, we seem to be getting strange occurences of the subform
jumping between records. For example we're on one record, we tick a
checkbox then suddenly we're on a different record and it's that
records' checkbox that's been edited! This is all on the same table in
the same subform....


Is that the exact error message? Or does it come with some mumbo-jumbo
around it? In such case, please post the mumbo-jumbo.

However, I don't really think this is an SQL Server problem, but more
likely to be some accident that happens in Access, so you might better
off asking in comp.databases.ms-access.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3
Erland Sommarskog wrote:
Not Me (cl*********@toofgib.moc) writes:
"Not Me" <no****@nowherefake.addr3s.com> wrote in message
news:cc**********@ucsnew1.ncl.ac.uk...
What exactly does the above (subject) error mean? I'm getting it from an
adp file when used by a few people at the same time (each user has the
file in their own filespace though). Access is through windows
authentication and it only seemed to occur during an update of a
specific table.. The problem is it didn't happen to everyone and I
can't recreate it at all on my own, so am wondering if it was something
to do with the level of traffic to/from the server at that specific time.


Further to this, we seem to be getting strange occurences of the subform
jumping between records. For example we're on one record, we tick a
checkbox then suddenly we're on a different record and it's that
records' checkbox that's been edited! This is all on the same table in
the same subform....

Is that the exact error message? Or does it come with some mumbo-jumbo
around it? In such case, please post the mumbo-jumbo.


Yep, the error is just "row handle invalid", it is sometimes accompanied
by another error 'you tried to access a record which has been, or is
currently marked for deletion'

Cheers for your help,
Chris

Jul 20 '05 #4
Not Me (no****@nowherefake.addr3s.com) writes:
Yep, the error is just "row handle invalid", it is sometimes accompanied
by another error 'you tried to access a record which has been, or is
currently marked for deletion'


Sound like Access messages to me, so I would recommend trying an
Access newsgroup. Those are not messages from SQL Server.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #5

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

Similar topics

0
by: nek | last post by:
Would anyone have any ideas or come across the 'invalid handle' problem? Even after setting diaglevel=4, I could not get much out of the db2diag.log to diagnose the problem. The only thing I...
3
by: Frank Perry | last post by:
Howdy, I'm trying to write data out the com port. I have taken the code from the sample on the MSDN Library CD and used the parts that seem relevant. I can open the com port with CreateFile...
1
by: Daniel | last post by:
does the windows file handle change? are file handles unique to the whole operating system or just the current directoy? if a file is opened then closed then opened again, does the file handle...
3
by: Ajay Choudhary | last post by:
Hi, If the client tries to access a web service with invalid namespace, it gets a SOAP exception as invalid SOAPAction. The invalid namespace will happen because the proxies on the client side...
1
by: Gabe Garza | last post by:
In the following code snippet: Microsoft.Web.Services.Security.Signature sig; try { sig = new Signature(x509Token); } catch(Exception ex) { txtStatus.Text = ex.Message + "-" +...
0
by: Jay | last post by:
Hey There, When I run the code below, I get the error "The handle is invalid." .. This is output in the 2nd fprintf. The first one gives me a success message. What could be causing this? -Jay...
1
by: sranger | last post by:
When I try to use a System.IO.Ports.SerialPort object to read from a serial port, half of the time I have no problems. However, after I successfully read from the serial port, then close the...
6
by: MIUSS | last post by:
Hello I got an unusual problem and I don't know how to solve it out. I need to get success with the handle variable hFile. It's not problem 'til I use wcscpy(...). I mean, when I take out...
5
by: Grant Edwards | last post by:
I'm trying to use the py-gnuplot module on windows, and have been unable to get it to work reliably under Win2K and WinXP. By default, it uses popen(gnuplotcmd,'w'), but in some situations that...
8
by: Lambda | last post by:
When I call the standard strncpy function, I provide it a negative argument, such as: strncpy(s, ct, -1) I compile the code with gcc, when I run, it says "Segmentation fault". Do you think...
0
marktang
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,...
0
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...
0
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,...
0
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...
1
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...
0
tracyyun
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...
0
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,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
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...

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.