Open Linked Table in Exclusive mode ( DAO)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Javier Gomez - 30 Mar 2005 23:09 GMT

How to open a linked table in exclusive mode from a FORM in DAO ???

(but,...... please I need it in DAO.)

Thank you !

Javier Gomez

Reply to this Message

Trevor Best - 31 Mar 2005 01:31 GMT

> How to open a linked table in exclusive mode from a FORM in DAO ???
>
[quoted text clipped - 3 lines]
>
> Javier Gomez

Last time I did this was in Access 2.0 and that just couldn't place a
real exclusive lock on a linked table, I had to go about it by opening
the backend database in DAO and opening from there. I don't know if
later versions are better than this.

set rst=db.OpenRecordset("linked table name",dbOpenDynamic,dbDenyRead)

or if you have the backend table open in the db variable

set rst=db.OpenRecordset("table name",dbOpenTable,dbDenyRead)

Signature

[Oo=w=oO]

Reply to this Message

Javier Gomez - 31 Mar 2005 19:55 GMT

Thank you! for your answer I 'll try it !
But any body knows if with Access 2003 is it any other way, or better
way, to do it ???

regards
Javier Gomez

> > How to open a linked table in exclusive mode from a FORM in DAO ???
> >
[quoted text clipped - 14 lines]
>
> set rst=db.OpenRecordset("table name",dbOpenTable,dbDenyRead)

Reply to this Message