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.

Thank you for your reply,
Ginna.

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:1t14h2tonuh74abn9jmpdm8o67kap17vn4@xxxxxxxxxx
I would like to establish such a configuration of database cursors where
all
users could view "instantly" any changes made by other users on the
network.
I'm using MS Access and have tried many combinations already but I always
get my cursor set to either ctStatic or I get the "Provider doesn't
support
this inerface..." error. Can you please tell me of the fastest way to set
up
by database system so changes would be visible to all users. Does MS
Access
support a dynamic cursor at all and do I use TAdotable or TAdodataset?
Access does not support dynamic cursors

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima0501.asp

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • 2.6.23-rc4-mm1 list_add corruption in networking code
    ... errors that seems related to network code. ... # Firmware Drivers ... # PCI IDE chipsets support ... most of these also require special kernel boot parameters ...
    (Linux-Kernel)
  • Re: 2.6.23-rc4-mm1 list_add corruption in networking code
    ... errors that seems related to network code. ... # Firmware Drivers ... # PCI IDE chipsets support ... most of these also require special kernel boot parameters ...
    (Linux-Kernel)
  • Network slowdown due to CFS
    ... I noticed that my network performance has gone down from 2.6.22 ... # Linux kernel version: 2.6.22 ... # Loadable module support ... # RAM/ROM/Flash chip drivers ...
    (Linux-Kernel)
  • Re: PROBLEM: oops in 2.6.21.1 after bringing up the network
    ... I am consistently getting a kernel oops from a vanilla 2.6.21.1 kernel. ... I have the same problem here on an ASUS laptop with sis network ... # Linux kernel version: 2.6.21.1 ... # ACPI Support ...
    (Linux-Kernel)
  • oops in current -git
    ... FC5 boot proceeds normally, mounting local filesystems etc., until it reaches the step where it determines the network address for eth0. ... # ACPI Support ... # Device Drivers ...
    (Linux-Kernel)