I just checked again, and if I create DB from scratch in MS Access this code doesn't work, It doesn't work for any DB I created, I have only one DB where it works, and it was created by the guy who used to work here before me. He must have changed something in DB permission.. or I don't know...
Thank you,
but the problem is I need to use that DB, and it's too big to recreate it again from scratch. It has something to do with DB Permissions. Do you know what can I change in the DB I am using, may be something in User and group permissions, so it works?
Thanks
HI,
I have Access DB and I am trying to create temp_table in Access DB using VBA, and every time it generates the following error:
"You do not have the necessary permissions to use the 'Temp_table' object. Have your system administrator or the person who created this object establish the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.