Wow, so that took 4 hours to figure out....
If anyone is interested the way to run ALOT of querys without having to type in the names or hitting enter every time.
I ended up coding it in excel so I could close the db and not get authorization issues. For this to work you have to go into Tools-> Referances and make sure all the access related libraries are checked because I still don't know which one exactly these objects reside in. Enjoy
I am da man!Code:Dim wrkspc As Workspace Dim db As Database Set wrkspc = CreateWorkspace("WorkSpace", "usrid", "pswd", dbUseJet) Set db = wrkspc.OpenDatabase("nameofdatabase.mdb") For Each QueryDef In db.QueryDefs QueryDef.Execute;