Home > Visual Basic > Visual Basic Unexpected Error 40230

Visual Basic Unexpected Error 40230

Don't show the Database Window nor the windows shortcuts etc (see the startup menu options)Also make sure you maintain a development copy without the inhibit bypass.This distribution method is not as All product names are trademarks of their respective companies. Browse other questions tagged vba ms-access ms-access-2007 access-vba or ask your own question. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. this contact form

Fenton ar****************@tiscali.nl (Arno R) wrote in <3f**********************@dreader2.news.tiscali.nl >: > 1. 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 Home | Invite Peers | More Database Groups Your account is ready. Remove any references you don't need. Get More Information

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). Maybe it's overkill but it seems to get me back to a clean file again.Bill Mosca www.thatlldoit.com http://tech.groups.yahoo.com/group/MS_Access_Professionals Friday, July 31, 2015 2:05 PM Reply | Quote Microsoft is conducting an Time to copy everything into a new, blank DB. Arno R "David W.

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 Inhibit the bypass keyb. If that doesn't work then try importing all your objects into a new MDB and then creating the MDE again. [ Main | Access Tips ] Dev Center Explore Why Should I even bother with contacting them?Chris Ward Wednesday, April 25, 2012 3:00 PM Reply | Quote 1 Sign in to vote Chris If decompiling didn't fix it import everything into

Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc Nov 12 '05 #4 P: n/a Lyle Fairfield dX********@bway.net.invalid (David W. Hmmm.... To make matters worse, the company IT policy is that the XP machines are no longer available and I cannot have an Office 2003 installed on the Vista machine. http://www.mrexcel.com/forum/excel-questions/294296-visual-basic-unexpected-error-40230-a.html Is there any way I can retrieve my VBA code?

share|improve this answer edited May 12 at 11:32 Andre 12.2k3936 answered Aug 19 '13 at 15:39 vietnamese 6112 add a comment| Your Answer draft saved draft discarded Sign up or Perth, Western Australia. I'm on a Windows XP machine. Share it with others Like this thread?

Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. http://www.tek-tips.com/viewthread.cfm?qid=536351 Yes. 2. And you probably need to go to "VBAProject Properties..." again to uncheck "Lock project for viewing". Office UI Fabric Microsoft Graph Better with Office Word Excel Powerpoint Access Project OneDrive OneNote Outlook SharePoint Skype Yammer Android ASP .NET iOS JavaScript Node.js PHP (coming soon) Python (coming soon)

CONTINUE READING Join & Write a Comment Already a member? http://digitalfishbowl.net/visual-basic/visual-basic-6-xp-unexpected-error-quitting.html Does it matter if you create the MDE in A2K or A2K2 (using A2K format)? You cannot create an MDE in Access 2002 of a db in Access 2000 format. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.

I tried decompiling, which is how I found out the project is corrupt. If you are replying to this post, please remove the caps and underscores from my email address. Suggested Solutions Title # Comments Views Activity VBA to delete range of cells in row NOT entire row 11 38 12d Protecting an object 3 27 14d Simple Calculation for Value navigate here Unprotect your code.

Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. 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 My next step will probably include inhibition of the bypass key.

Unlock Macro/VBA Source Code Even the VBA window can be displayed with ALT+F11, you can't really go to see the existing code in each macro.

Unexpected Error (40230) Unknown User asked Jul 11, 2002 | Replies (6) I am at my wit's end (so is our Access guru). 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. This is usually the second easiest solution if it's your file that is corrupt. Cheers, all the same.

Register now while it's still free! When I double click on any of the forms, modules, or excel objects I get the error - "Unexpected error (40230)" Any thoughts or ideas? 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 http://digitalfishbowl.net/visual-basic/visual-basic-unexpected-error-32810.html Why is the size of my email about a third bigger than the size of its attached files?

SkyrimSE is Quiet My 21 yr old adult son hates me Sending a stranger's CV to HR Defining a custom TikZ arrowtip (circle with plus) Dealing with a nasty recruiter more You will have to convert your A2003 mdb to an A2007 accdb before you can create an A2007 accde. This leads me to a 3rd issue, in the form of a question: 3. If you are replying to this post, please remove the caps and underscores from my email address.

Before importing your objects into the new database, turn off the Name AutoCorrect boxes under Tools | Options | General. Good Catch! Upgrade your Citrix mainframe version of Office to 20072. Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask a Question AB, right again. Assuming I've interpreted correctly, does this mean that: 1. Login.

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 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! Fenton Mi************@Invalid.Com (Lyle Fairfield) wrote in : "Allen Browne" wrote innews:3f**********************@freenews.iinet.net. You can use A2K format but then you can't create mde's, Right?

The former will, but the latter is not possible. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers ps. And if so, do you mean that an A2K MDE generated by A2K2 is not really an A2K MDE, that it won't run in A2K? I am getting it when trying to open a worksheet that has ...

Please mark an answer(s) as an answer when your question is being answered. Here is the problem. Please mark an answer(s) as an answer when your question is being answered. For .XLSX rename the file extension from .xlsx to .zip go inside to xl\worksheet subfolder there will be sheets in their separated XML files open the protected one with a text