Create Linked Table Readonly -- MS Access

[MUKESHY12390]

Hi frnd,

Can we create read-only Linked table , so that user won't able to delete/update anything table.

below code works, but it doesn't create readonly access.

Any help would be appreciated.

DoCmd.TransferDatabase TransferType:=acLink, _
        DatabaseType:="Microsoft Access", _
        DatabaseName:="[URL="file://\\MyPath\MyDB.accdb"]\\MyPath\MyDB.accdb[/URL]", _
        ObjectType:=acTable, _
        Source:="tblUniqueList_Client_II", _
        Destination:="tblUniqueList_Client_II"

Thanks,
Mukesh Y

 

[Joe4]

There is an option offered here: https://www.devhut.net/2010/10/18/ms-access-make-tables-read-only/
and there is an interesting discussion with various options found here: https://access-programmers.co.uk/forums/showthread.php?t=234498

 

[MUKESHY12390]

Thanks! Joe, I will take a look.