>I use Access 2000 and ADODB Recordset with:
>db.CursorLocation = adUseClient
>adoPrimaryRS.Open "select IDPtt,Mesto,Pttbroj from Ptt", db, _
>adOpenDynamic, adLockOptimistic
>
>Help me!
You can't do it with Access since it isn't a real Database Engine like Oracle or SQL Server.
The most you can do is to refresh your recordset at some interval!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com