I did however have my source mdb file on a disc that I copied to my laptop, and then tried to re link the tables to the network drive (had them Import the tables from the old MDE file to the new one. Browse other questions tagged database ms-access vba access-vba ms-access-2003 or ask your own question. 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 http://brrian.net/unable-to/unable-to-create-form-in-access-2003.html
Why does a (D)DoS attack slow down the CPU and crash a server? Thanks! Make sure your database is in Access 2002/2003 file format by opening the database. Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access Discussion of Microsoft Access database design and programming. https://support.microsoft.com/en-us/kb/283788
Any advice? Until you've decompiled, you don't know if your code really compiles or not. –David-W-Fenton Apr 6 '10 at 0:57 add a comment| up vote 2 down vote First try to work Compact and repair a copy of the database 2.
If Access runs into a problem while making the MDE file, a message appears with a Show Help button. Registration is fast, simple and absolutely free . Then the new MDE file opens. No, create an account now.
Open any code module and, from the VBA menu, select Debug, then Compile. If I atttempt to open this copy it errors all over the place saying it cannot find files etc. Hello and welcome to PC Review. Usually the problem will be in a form or report.
llkhoutx View Public Profile Find More Posts by llkhoutx
It does not seem files specific (same error for multiple files). Please Wait... Not sure what Office service packs have been applied as a company firewall prevents us from downloading them or any .exe or .zip files. If you are using Access 2002 or 2003, the default database format is Access 2000 unless you have changed this.
Guest Guest Access 2000 Windows 2000 Microsoft Access was unable to create an MDE database Why would I receive the above error (no error number was given)? Delete any empty forms; modules; marcos; etc. Thanks Jan 23 '07 #1 Post Reply Share this Question 7 Replies Expert 2.5K+ P: 3,072 nico5038 Strange, but some problems can be prevented by first compiling the database code. http://brrian.net/unable-to/unable-to-create-mde-file-access-2003.html If you are going to do this often, consider splitting your table into a front end and a back end.
If your database is corrupt, the simplest way to fix this is to create a new database and import all the objects from your database. If the compiler finds errors, you'll need to fix those and save your changes. 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
Nic;o) Jan 23 '07 #2 reply Expert Mod 15k+ P: 29,924 NeoPa On top of that I'd also recommend doing a Compact & Repair. Open the corrupted database, and then click Tables under Objects. If I try to create an MDE in Access 2000 software, it has no problems. Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics
P: 54 ZaphodBBB Hi Using Access 2003 and Win XP Pro S.P.2 (not sure what service packs have been applied to Access. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Is there anyway to solve this? Check This Out database ms-access vba access-vba ms-access-2003 share|improve this question asked Apr 5 '10 at 12:00 Justin 1,7251766127 1 Have you decompiled and / or imported everything into a fresh mdb? –Fionnuala
Take a look at the title bar of the Database window. (Press F11 if it's not visible.) If the title bar says "(Access 2000 file format)" then you need to convert Any ideas or help appreciated. One for All, and All for One Does advantage negate disadvantage (for things such as sneak attack)? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
The time now is 01:24 PM. Chances are you had some code in the report referencing the control you removed from the report. Is scroll within a card good or bad? (In desktop) Why does a (D)DoS attack slow down the CPU and crash a server? Open the original MDB file and make any changes to contain the forms, reports, and VBA code that you want.
The error message further stated that the problem had to do with the creation of many tableids (due to the use of more than 500 forms). The shortcut I created is fine but every time I try to run using decompile I get a message along the lines of: "The command line you used to start MS Guest, Aug 17, 2007, in forum: Microsoft Access Replies: 1 Views: 186 Allen Browne Aug 17, 2007 Microsoft Access was unable to create an MDE database Ron Hinds, Jun 3, 2008, Browse other questions tagged ms-access vba ms-access-2003 or ask your own question.
Compiling the code will find all the compile errors one at a time though. –Tony Toews Dec 9 '09 at 1:13 add a comment| Your Answer draft saved draft discarded of Environmental Quality, Air Quality Division #3 (permalink) November 6th, 2004, 11:23 AM rjweers Friend of Wrox Join Date: Nov 2004 Location: Seattle, WA, . Sign Up Now! I would suggest compiling your code on a frequent basis.
The file path... If you use the MDE file to do data entry and editing, that file contains your up-to-date tables. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find You have to go back to your MDB file to make these kinds of changes, because you can't make changes in an MDE file.