Re: Access and Ado for multi-user
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/09/04
- Next message: Yannis: "Re: Remote MSSQL + Local Access Database update"
- Previous message: Michael Jacobs: "Re: XMLType in Oracle and Delphi ADO components"
- In reply to: Huseyin Tasdoven: "Access and Ado for multi-user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Yannis: "Re: Remote MSSQL + Local Access Database update"
- Previous message: Michael Jacobs: "Re: XMLType in Oracle and Delphi ADO components"
- In reply to: Huseyin Tasdoven: "Access and Ado for multi-user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|