read only access

[Kosmos]

when I give people read only access, will they be able to write if I open by adLockOptimisti c? I mean...when I open the recordset through adLockOptimisti c, I have a field in a temporary table that needs to be calculated and inserted into that temporary table before the table is exported to excel and cleared.

[Killer42]

when I give people read only access, will they be able to write if I open by adLockOptimisti c? I mean...when I open the recordset through adLockOptimisti c, I have a field in a temporary table that needs to be calculated and inserted into that temporary table before the table is exported to excel and cleared.

I'm pretty sure that read-only means read-only, regardless of locking options. Maybe you could open a second, temporary database, copy the table to there, and modify it. Or open two recordsets in the same database, but one read-only and one not.