Re: Access and Ado for multi-user

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/09/04


Date: Wed, 08 Dec 2004 21:44:53 -0600


> I'm using to TAdoTable for access to MSAccess *.mdb file. (with Delphi
>7 )
>My problem is in a PC (user)'s updates the records(update, delete, add new
>row) cant see instantly from other PC's even used the TAdoTable's Refresh
>method.
>When CursorLocation:=clUseServer, CursorType := ctDynamic (in design time )
>and I try to change AdoTable.Active := True but i encounter a message
>"Dataset not support bookmarks, which are required for multi-record data
>controls".
>if CursorLocation:=clUseClient, CursorType can be ctStatic only.
>This is not useful for me.
>I want to make CursorType := ctDynamic for multi-user updates are visible.
>Anyone can help me about this??
No one can help you. You have to live within the functionality that ADO and the
Jet Oledb driver provided. If you want to use ctDynamic you just have access to
the current record. Grids or any other controls that require bookmarks don't
work

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com


Relevant Pages

  • Re: is it a newsgroup or marketplace? (was: What DNS to go for?)
    ... model for all of those free DNSes), I just need reliable DNS. ... What would happen when refresh period expires? ... business domain) if you just want to serve your local lan. ... updates or guarantees of consistency. ...
    (comp.os.linux.networking)
  • RE: Need to requery a main form with a pop up form
    ... When you requery a form, a result of that action is the form will move to the ... Open you're popup form where you enter your payments in dialog mode. ... repaint updates the value of unbound calculated controls on your form. ... Depending on your needs, you may not need both refresh and repaint, so try ...
    (microsoft.public.access.gettingstarted)
  • RE: [PHP-DB] Dynamic Website Question!
    ... refresh, just the text from the database. ... But I have never used DHTML. ... >> the updates is there a way to provide the updates ... > browser must be demend by the browser. ...
    (php.general)
  • Re: Invalidate wont fire OnPaint??
    ... immediate updates then you will have to do a Refresh. ... invalidate passed the required region. ...
    (microsoft.public.dotnet.framework.drawing)
  • Multiple Problems (slow,freezing,errors)
    ... i cant seem to run programs anymore without having them freeze on ... my IE doesnt allow me to open multiple windows ... cuz it needed updates, but i cant even get that done. ...
    (microsoft.public.windowsxp.help_and_support)