I'm using VBA with DAO to open a recordset from an Access table. This all works fine.

The problem comes when I attempt to overwrite the old table with a new one. I get a "database locked" error, ostensibly because someone else on the floor is using it.

I have tried using DBEngine.Idle dbFreeLocks,
but this didn't help.

How can I provide read-only access to the table so the recordset can be produced, without locking the table? Thanks for any suggestions.