Please help me !!!
How can I Open a table and not the rest of tables from VB exclusevely.
Printable View
Please help me !!!
How can I Open a table and not the rest of tables from VB exclusevely.
Use the Options Flags, ie.
Set oRS = oDB.OpenRecordset("Table1", dbOpenTable, dbDenyRead Or dbDenyWrite) 'Open Table1 Exclusively, Don't Allow anyone else to Read/Write with the Table
The Lock is Released when the Recordset is Closed.