I know this is a dumb question but my work database has a security file that limits most users to read only.
I made a continuous form recently that puts records into a temporary table. Upon opening the form it runs some SQL to erase the previous records so that it starts blank but this doesn't work in the read only account.
I was also going to try generating a temporary table using the CREATE TABLE method but it seems to have a similar issue.
Does anyone know a work around to have this table empty every time while keeping the user in read only?