Open Linked Table in Exclusive mode ( DAO)

[Javier Gomez]

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

[Trevor Best]

Javier Gomez wrote:

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

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)

--
[Oo=w=oO]

[Javier Gomez]

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

Trevor Best <no****@besty.org.uk> wrote in message news:<42**********************@news.zen.co.uk>...

Javier Gomez wrote:

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

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)