Ms Access Runtime Error 3033
Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 02-22-2010, 05:07 AM #1 Caddie Newly Registered User Join Date: Feb 2010 Posts: 75 Thanks: 0 Thanked 0 Times in 0 Posts Run-time error 3033 Hi All - I keep getting a Run-Time Error 3033 when I try to run the following code for a certain Group (DB has user permisssions) it works for me as I am admin. the error occurs on the bolded line. I checked the permissions for this group and they have "Open/Run" permissions for it. Private Sub AddNewContract_Click() DoCmd.OpenForm "Add New Contract" DoCmd.Close acForm, "Main Menu" Exit_Command1_Click: Exit Sub Err_Command1_Click: MsgBox Err.Description Resume Exit_Command1_Click End Sub Caddie View Public Profile Find More Posts by Caddie 02-22-2010, 05:28 AM #2 gemma-the-husky Super Moderator Join Date: Sep 2006 Location: UK Posts: 13,140 Thanks: 50 Thanked 885 Times in 857 Posts Re: Run-time error 3033 you havent activated error handling in this code - so which error handler is reporting this. what description is 3033 - normally you get a 2501 if the form doesnt open. maybe the form is trying to do something on opening that needs more than open/run permisisons. __________________ Dave (Male!) Gemma was my dog if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside. gemma-the-husky View Public Profile Find More Posts by gemma-the-husky 02-22-2010, 06:53 AM #3 Caddie Newly Registered User Join Date: Feb 2010 Posts: 75 Thanks: 0 Thanked 0 Times in 0 Posts Re: Run-time error 3033 Ya, I figured it out, the user group didn't have the proper permissions to the backend DB. Still trying to get my head around the permissions. Thanks. Caddie View Public Profile Find More Posts by Caddie « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Rate This Thread Excellent Good Average Bad Terrible Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World Access World News Site Suggestions Introduce Yourself The Watercooler Microsoft Access Discussion General Tables Queries Forms Reports Macros Modules & VBA Theory and practice of database design Access Web Microsoft
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Runtime error 3033 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-21-09,11:13 #1 atsukoarai86 View Profile View Forum Posts Registered User Join Date Sep 2008 Location NM, USA Posts 97 Unanswered: Runtime error 3033 EDIT: http://www.access-programmers.co.uk/forums/showthread.php?t=188738 I found the solution to the below problem. The reason he was getting denied on the custom queries and not the default query is because the custom queries required the SQL to be modified, and as a Full Data User, he had read/write/update/delete permission on all the data, but did not have read design/modify design permission... I decided to just grant him those permissions for those specific queries. That seemed http://www.dbforums.com/showthread.php?1646754-Runtime-error-3033 like the simplest solution. _____________________ I understand this is a security error, but I'm not quite sure ... how to fix it. I get the error You do not have the necessary permission to use the 'MSysTables' object When I debug the error, it highlites the last line of the following code, where it says qdf.SQL = strSQL: Code: Call GetCriteria If err Then Exit Sub strSQL = "SELECT Site, [DOC Number], [Last Name], [First Name], [Collection Date], [Mg/Week], [INR], [Action Taken] FROM qryDsgINR_All " & _ "WHERE qryDsgINR_All.Site IN(" & strCriteria & ");" qdf.SQL = strSQL Obviously I don't get this error when I'm logged on to MY workgroup account because I'm in the admins group. I get the feeling it has to do with the qdf object. Any clues, hints, solutions? Thanks much everyone. Last edited by atsukoarai86; 08-21-09 at 11:30. Reason: Found the Solution "Unix is user friendly... It's just very picky about its friends." The best things in life...are well-documented. Reply With Quote 08-22-09,02:47 #2 pkstormy View Profile View Forum Posts Moderator Join Date Dec 2004 Location Madison, WI Posts 3,926 Any time I've seen an error related to the MSysTables table, it usually entails compacting/repairing, re-creating the security mdw file, creating a
Hi Dpw, From your description, I understand that you would like to know how could you find Workgroup Administrator in Access 2003. Have I understood the issue http://www.pcreview.co.uk/threads/re-howto-get-rid-of-error-3033.1667011/ correctly and completely? If there is anything I misunderstood, please feel free to let me know. Based on my understanding, you could startup Workgroup Administrator Dialog from Access 2002 and 2003 in this way. 1. Start Access by click its icon 2. on Menu Tools -> Security -> Workgroup Administrator 3. Then you can see Workgroup Administrator Dialog like you used to type "wrkgadm.exe" Please feel free ms access to post in the group if this solves your problem or if you would like further help. We are here to be of assistance! Sincerely yours, Michael Cheng Microsoft Online Support *********************************************************** Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. Please reply to newsgroups only, many thanks. Michael, Cheng [MST], Apr 15, 2004 #1 Advertisements Guest Guest ms access runtime Michael I thought by joining the workgroup information file my problem would be solved It did not Let me repeat the issue that I'm having I'm trying to open an .mdw file on Access 2003. I get this error message "You do not have the necessary permissions to use the