I am somewhat familiar with Acess and have what I would call a simple question. I have an Access 2003 database that someone else developed a long time ago for the company I now work for. The database does a bunch of append queries and it runs just great with full blown access. But if I load the runtime version 2000 on a mchine and try to run the database all of a sudden I get a bunch of append query popups asking me to confirm running each and every query. I have search google for several days trying to find an answer. Most talk about 3 buttons to check to turn off the prompting (sorry I can't remmeber off the top of my head where they are). I can go in with a full version and check the settings and all of them are turned off which is evident because the full blown doesn't prompt you. The other threads I found talk about writing VBA or SQL code to turn it off but I am not familiar with that. The bottom line is I don't understand why I should have to re-code to fix something that is only broken in the runtime version. Does anyone know a trick to get the runtime version to read and acknowledge the security settings that the full version appears to read? Sorry for the long winded message.
Thanks Rick Bowman