Ms Access Mde Error
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MS Access cannot create the MDE Error. Too Many Objects up vote 2 down vote favorite 1 So I have a MS Access database at work. Recently I tried to put out another MDE file, that actually took something off a report that was previously there. Now I am getting this error that says, "MS Access cannot create the MDE" with a little show help button....click the show help button and it gives a description about this relating typically to too many objects (Forms, reports, tables, etc). This database is not very big at all, so I am wondering how this could be happening? Does it count each time I release an MDE with only minor changes, all the same forms, reports, etc over and over again? Could this be another error and the pop up box is kind of blanket or generic? Is there anyway to solve this? Does this count objects on a form/report (text boxes, cmb boxes, etc)? Basically the example given in the help says that if you have 500 forms, and 2 modules for each form, then that would count as a 1000....this database has about 12 forms, 4 queries, 16 tables (max record = >1000 records) and is not very big. Since the last time I released an MDE with no problem, I have only tried to deleate an item off a report for this new one, without adding anything new. Please help....there are screaming for this, and I am at my wits end! Thanks ms-access vba ms-access-2003 share|improve this question edited Nov 23 '09 at 21:52 Tony Toews 7,02511324 asked Nov 23 '09 at 11:11 Justin 1,6921765126 Note that a form or report can't have more than one module. –Tony Toews Nov 23 '09 at 22:37 yeah not sure why i put that. think i was trying to say if the forms module was calling a .bas module/function, because I did not know if that counted as....though your explain sort of already explained that it is some bad code somewhere. thanks! –Justin Dec 8 '09 at 23:04 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Objects count for the life of the database, that is, even if you delete them, they still count. I suggest you decompile, compact & repair, and then copy
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Repaired Microsoft Access MDE file with "missing MSysDb" error; now receiving "no read permission to MSysObjects" and then to MSysACEs. Microsoft Office > Office 2010 - IT Pro General Discussions Question 0 Sign in to vote Microsoft Access mde file was corrupted. Started receiving the "missing MSysDb" error. Could not use Microsoft Access database tool "Compact and Repair", but received same http://stackoverflow.com/questions/1782476/ms-access-cannot-create-the-mde-error-too-many-objects error. The same happened when trying to export in order to import to a new file. Used "Access Repair Toolbox" to repair the file. Afterwards, started receiving the error messages "Record(s) cannot be read; no read permission on 'MSysObjects'." and then "Record(s) cannot be read; no read permission on 'MSysACEs'." Cannot view mde file in https://social.technet.microsoft.com/Forums/office/en-US/76a61d2d-c7c5-4bc1-9216-a20c7194cb20/repaired-microsoft-access-mde-file-with-missing-msysdb-error-now-receiving-no-read-permission-to?forum=officeitproprevious Microsoft Access after receiving these errors. Have read the other answers to issues with the "missing MSysDb" error, but the recommendations did not work. Unfortunately, the file was not backed up. Thursday, August 13, 2015 7:17 AM Reply | Quote Answers 0 Sign in to vote Hi, Have you read this thread? http://answers.microsoft.com/en-us/office/forum/office_2007-access/repaired-microsoft-access-mde-file-with-missing/76b7bd6f-f284-4029-aa6b-e4758d6bb2e4 I agree with them, we need to find the original MDB file and re-create a new MDE file (Do not need the backed upMDE file). Regards, George Zhao TechNet Community Support It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com. Marked as answer by Melon ChenMicrosoft contingent staff, Moderator Friday, Septem
Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 11-22-2002, 12:54 PM #1 R2D2 Member Join Date: Jul 2002 Posts: 62 http://www.access-programmers.co.uk/forums/showthread.php?t=38174 Thanks: 0 Thanked 1 Time in 1 Post Can't Make MDE file For some reason, Access is unable to create an mde file out of my mdb database. This has never been a problem before - I've converted this exact same database to an mde file several times before. I've been working on fixing a bunch of bugs recently, and now that I have those fixed, I want to recompile to an mde to distribute to my users. But everytime I ms access choose Tools > Database Utilities > Make MDE File... it gives me an error that says "Microsoft Access was unable to create an MDE database." Anyone know what might be going on? How would I fix it? R2D2 View Public Profile Find More Posts by R2D2 11-22-2002, 02:35 PM #2 Pat Hartman Super Moderator Join Date: Feb 2002 Location: Stratford,Ct USA Posts: 25,623 Thanks: 12 Thanked 1,042 Times in 990 Posts You probably have a compile ms access mde error. Try compiling the database. Pat Hartman View Public Profile Find More Posts by Pat Hartman 11-30-2002, 09:14 PM #3 trotsky Guest Posts: n/a You probably had a button for a function which you have deleted, but you did not delete the buttons VBA code. The private sub in VBA relating to the deleted button must also be deleted, otherwise Access will not be able to create the mde file. 02-27-2008, 07:04 AM #4 Tyler08 Registered User Join Date: Feb 2008 Location: Medway, Kent, UK Posts: 44 Thanks: 0 Thanked 0 Times in 0 Posts My DB also will not make an MDE. The reason is probably deleted buttons as above. Is there a way of listing all the redundant code so that it can be deleted? Tyler Tyler08 View Public Profile Find More Posts by Tyler08 02-27-2008, 07:08 AM #5 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts: 32,482 Thanks: 94 Thanked 1,781 Times in 1,565 Posts What you do is go into the VBA window and click DEBUG > COMPILE and it should take you to those spots that need adjusting or deleting. __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. The Following User Says Tha