Re: Proper way of using ctDynamic cursortype on network with MS Access


Thanks for the link, as far as I can figure out, MS Access doesn't even
support such dynamic way of refreshing records through network. I'm
converting an old Paradox database and it seems I'll have to change all
ADOTable components to ADODataset ones to get the ctKeyset capability which
is an improvement over ctStatic. However even that won't enable the
application to instantly see any updates through the network, can you
recommend a database system which would do exactly that, the database is
some 10000 records in size, few get changed over day but those need to be
visible to all users so no duplicate entries or other errors appear.

What you are asking for is expensive as far as resources go for the server to do
this. I don't know of any databases that do this easily.
My guess is that you are not realistically evaluating your need for instant
refresh. What you need is an error handling routine that will return an error
if a user tries to enter a duplicate record. This is how the large reservation
systems handle it.

If you must persist in your questionable design Interbase is the best database I
can think of. While it does not provide instant viewing of database changes it
does have the capability for the server to send events to the clients. So you
can have a trigger fire an event down to the client and use that event to
refresh the records
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: client-server app where data is disconnected, but stays fresh
    ... second or two) poll the server to see if they are up to date. ... disconnected fashion until the next change triggers them all to refresh. ... I intend to have a single row in one of my database tables provide the ... clients with a 'change type' and 'change number' to facilitate this near ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Decentralized databases?
    ... within a network shared by many clients and one central database server. ... Yes you can replicate your database, but be prepared for a significant increase in network traffic, performance hits during peak periods, an increase in the number of DBAs required to take care of your increased number of databases and assure that they really are in synch. ...
    (comp.databases)
  • Re: Real time notification
    ... reaction was that I will use a database. ... Logical - The central server informs the clients of a change. ... so you can network load balance it as your needs grow. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Inlavid Operation ereror when refresh table link
    ... I also use it to refresh my links. ... Dim strTblName As String, strConn As String ... Dim db As DataBase, rs As Recordset, tbl As TableDef ...
    (comp.databases.ms-access)
  • Re: Refresh questions
    ... submitted item repeats each time the refresh is clicked. ... > in my database that stored a submission ID and checking it when the page ... > a hidden field in the form. ... I allowed the submission to be inserted into the ...
    (microsoft.public.dotnet.languages.vb)