473,245 Members | 1,583 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,245 software developers and data experts.

Q: Concurrent access to a local DB file

I wrote a Delphi application that accesses a local Access database
using 2 instances of the TADOQuery class. Unfortunately, when I
traverse the DB records using the first TADOQuery instance, the
pointer to the active record maintained by the second TADOQuery
instance is also affected. Is there a way I can force Delphi to use a
seperate pointer to the DB for each instance of my class?

I'm truely a beginner in DB programming, so I apologize if my question
is lowly.

Thanks heaps,
John Fine
Nov 12 '05 #1
3 4429
No, there is no such thing as a lowly question. ;-)
I am not familiar with the TADOQuery class. Is this a class object you
wrote?

However, if you are creating multiple instances of a object, and that object
has it's own recordset, then I can't imagine why using one object would
effect the other. The only possibility here would be that both of your
objects are referencing the same global reocrdset, but that would indeed be
lame.

If you are talking about writing class objects in ms-access, access97 does
allow you to reference the base object without creating new instance of the
object, but this not your problem. (in a2000, you can't do that anymore, as
it is the same as VB6).

Perhaps you are not creating a new instance of the recordset object for each
instance of the object you are using?

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
"John Fine" <jo*******@hotmail.com> wrote in message
news:ff*************************@posting.google.co m...
I wrote a Delphi application that accesses a local Access database
using 2 instances of the TADOQuery class. Unfortunately, when I
traverse the DB records using the first TADOQuery instance, the
pointer to the active record maintained by the second TADOQuery
instance is also affected. Is there a way I can force Delphi to use a
seperate pointer to the DB for each instance of my class?

I'm truely a beginner in DB programming, so I apologize if my question
is lowly.

Thanks heaps,
John Fine

Nov 12 '05 #2
la**********@ntpcug.org (Larry Linson) wrote in
<fc**************************@posting.google.com >:
What is often called an "Access database", is most likely a "Jet
database" run by the same Jet database engine that is the default
with Access. Access is, in fact, the direct user interface part
and database application generator part of a DBMS.


I am presently in the process of recreating in Access an
application that was created by a Delphi programmer using an Access
2000 MDB file for the back end.

But it wasn't used just for data storage.

The reports were all done in Access and there are also tons of
stored parameterized QueryDefs, and even several code modules.

The Delphi programmer in question made quite a bit of use of
*Access* in his application and not just Jet 4.

That said, he really didn't have a clue about database application
design or about how to use Access/VBA itself, and that's why his
application never worked, and that's why I was hired to recreate it
from scratch.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #3
jo*******@hotmail.com (John Fine) wrote in message news:<ff*************************@posting.google.c om>...
I wrote a Delphi application that accesses a local Access database
using 2 instances of the TADOQuery class. Unfortunately, when I
traverse the DB records using the first TADOQuery instance, the
pointer to the active record maintained by the second TADOQuery
instance is also affected. Is there a way I can force Delphi to use a
seperate pointer to the DB for each instance of my class?


Your question is very likely delphi specific.
Searching on google, looks like you'd have more luck on
borland.public.delphi.database.ado
You might want to search using google yourself and check your question
hasn't already been answered as there's quite a few threads I found
searching on "TADOQuery".

Good luck.
Nov 12 '05 #4

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

Similar topics

12
by: CJM | last post by:
I'm setting up some web-based (ASP) reports that query an Access DB. I also want certain people to be able to access and manipulate the database directly. However, if the database is open in...
1
by: bluedolphin | last post by:
There seems to be a consensus that Access has a concurrent user limit of 200 users. I am working on a system that currently stands at approx. 1 gig and has a small number of users. However, there...
3
by: mgPA | last post by:
Short: How can I limit the number of concurrent logins to Access (2000) DB? Long: I seem to be having the problem discussed in previous postings of having more than 9 or 10 concurrent logins. ...
0
by: bettervssremoting | last post by:
To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool including SourceOffSite, SourceAnyWhere and VSS Remoting This article makes a detailed...
6
by: Rob | last post by:
Hi, I am working on a project that requires a Windows Service which performs the following file transfer functions. 1. It monitors a specific local directory on a Windows 2003 Server. 2. When...
5
by: sethwai | last post by:
Hi, I've read everything I can get my hands on and am still very confused about the similarities and differences between db2_mmap_read/write and concurrent i/o. It seems to me at this point...
1
by: Thomas René Sidor | last post by:
Hello Having been trying to find the root of this problem for several days I now hope that you can help me. I'm implementing a distributed file system - consisting of, at the moment, a...
1
by: sanjupommen | last post by:
I am in the process of exploring the possibility of providing our products on databases other than Oracle.I am able to migrate the data, procedures etc without too much effort (latest version of DB2...
0
amitpatel66
by: amitpatel66 | last post by:
There is always a requirement that in Oracle Applications, the Concurrent Program need to be execute programatically based on certain conditions/validations: Concurrent programs can be executed...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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...

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.