forumyaren.com

Home > Visual Basic > Visual Basic Unexpected Error 40230

Visual Basic Unexpected Error 40230

pere_de_chipstic...View Member Profile Sep 16 2009, 06:29 PM Post#3UtterAccess EditorPosts: 9,987Joined: 8-November 07From: South coast, EnglandHi Rob I have a feeling that you can only create an mde database when it If that deos not work, you will need to use your most recent backup. if you're distributing MDEs to a user base with both A2K and A2K2, you must compile different MDEs for each user base using the target version of Access, even though your If you are not sure which ones you need, see: http://allenbrowne.com/ser-38.html Then verify that the database compiles correctly. (From a code window: Debug | Compile). http://forumyaren.com/visual-basic/visual-basic-unexpected-error-336.php

All contents Copyright 1998-2016 by MrExcel Consulting. Register now while it's still free! Join Now For immediate help use Live now! Home | Invite Peers | More Database Groups Your account is ready. http://stackoverflow.com/questions/16847059/access-2007-unexpected-error-40230

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Worksallright with Access XP.Both A2k-mdb's AND A2k-mde's work in Access XP.******************************************I recently had a case where a A2k-mde would NOT run in Access XPbut this turned out to be a (difficult pere_de_chipstic...View Member Profile Sep 17 2009, 08:27 AM Post#7UtterAccess EditorPosts: 9,987Joined: 8-November 07From: South coast, EnglandHi Rob2007 will apparently convert an A2003 mdb to an mde but I have the same

I'm on a Windows XP machine. If you are replying to this post, please remove the caps and underscores from my email address. Sometimes this works. I have exported the subform to a new database and get the same errors.

Tuesday, April 24, 2012 4:08 PM Reply | Quote Answers 1 Sign in to vote Chris If decompiling didn't fix it import everything into a new database and try again.Bill Mosca Does it matter if you create the MDE in A2K or A2K2 (using A2K format)? Unexpected Error (40230) Unknown User asked Jul 11, 2002 | Replies (6) I am at my wit's end (so is our Access guru). http://www.mrexcel.com/forum/excel-questions/294296-visual-basic-unexpected-error-40230-a.html if you're distributing MDEs to a user base with both A2K and A2K2, you must compile different MDEs for each user base using the target version of Access, even though your

Join the community of 500,000 technology professionals and ask your questions. Next, Start>Run a comamnd line that includes besides the full path of your msaccess.exe the option " /decompile " and then the name of your .mdb file. I've tried decompiling, but that doesn't seem to work. Just need to save and re-open it again. 2.

Registration on or use of this site constitutes acceptance of our Privacy Policy. http://www.tek-tips.com/viewthread.cfm?qid=536351 I mean an ACXP db in AC2K ffile formet. By "this" do you mean generating an A2K MDE with A2K2? My company recently converted from XP to Vista and from Office 2003 to Office 2007, but they did not convert the Citrix Metaframe version of Office from 2003 to 2007.

MrExcel HTML Maker or Excel Jeanie Use code tags for posting VBA e.g.; [CODE ]your VBA code here[ /CODE] (with no spaces within the square [] brackets) Reply With Quote Dec check over here This is not actually true. The back end of our application uses both SQL Server and MS Access on a remote server which is linked using UNC. Most likely your VBA went corrupt and can't be fixed by decompiling...

But I need to make some enhancements to the code. the A2K compatibility of A2K2 does not extend in any fashion to MDEs. au: Make sure the new database is in Access 2002 format: you will not be able to generate an MDE from A2000 format.This can be done with code, but the MDE his comment is here Top This thread has been closed due to inactivity.

Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. It will pop-up error as "Unexpected error (40230)" The way to fix it is right click at any macro file in VBA window select "VBAProject Properties..." go to "protection" tab check Fenton Mi************@Invalid.Com (Lyle Fairfield) wrote in : "Allen Browne" wrote innews:3f**********************@freenews.iinet.net.

After the enable VBA on the file, if the sheet or workbook is protected.

Close this window and log in. To get around this error we compact and repair and then exit MS Access prior to making the MDE. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Looks like I will have to take off my developer's hat and put on my politician's hat to get this one solved.Thanks for the input guys.

Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Anidear A computer geek contact: anidear1 {at} gmail {dot} com View my complete profile Connect via Facebook Categories News Close it, then open it and compact and repair. Phil Top White Papers and Webcasts Popular Best Practices for a BI and Analytics Strategy Related Using Virtualization to Balance Work with TCO Zenoss Service Dynamics Architecture Overview Evolution of End weblink pere_de_chipstic...View Member Profile Sep 17 2009, 02:00 AM Post#5UtterAccess EditorPosts: 9,987Joined: 8-November 07From: South coast, EnglandCheers Bob, - glad I could help revans611View Member Profile Sep 17 2009, 07:02 AM

I'm running Access XP, with all the updates, including service pack 2. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Yes. 2. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.

We get the error consistently if we do not exit first, or when we use the Access Linked table manager. Solved Unexpected error (40230) Posted on 2010-02-05 MS Excel 1 Verified Solution 1 Comment 2,322 Views Last Modified: 2012-05-08 Hi I can't seem to access the VBA code in my excel I have a database which I'm trying to make into an MDE, and for every module I have, I get a Microsoft Visual Basic error "Unexpected Error" (40230). Hmmm....

Why does the Developer Console show different extensions like "apxc" and "apxt"? USER_1799081 replied Nov 20, 2009 I have a lot of experience with the 40230 error. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Thanks 0 Question by:bowemc Facebook Twitter LinkedIn Google LVL 17 Best Solution bygtgloner This might help...

thanks Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Most likely your VBA went corrupt and can't be fixed by decompiling...