473,657 Members | 2,678 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Converting accdb to accde VBA code is not working

222 New Member
Dear friends

I am working on access 2007 sp2.

I do have a database(accdb) i converted it to accde.

While I am opening the converted database the VBA code is not working.

For example
Expand|Select|Wrap|Line Numbers
  1. docmd.maximize
on each form is not working and forms won't maximize

Is it a bug on my office or I am doing something wrong...


Could you please point me to the write direction


Thank you all
Nov 8 '09 #1
11 24949
missinglinq
3,532 Recognized Expert Specialist
Are you running the accde file from the same folder as the original accdb was run from, or from somewhere else? Does other code run?

Remember that in order for code to run in Access 2007, the file has to be in a folder that has been set as "Trusted."

Linq ;0)>
Nov 8 '09 #2
wassimdaccache
222 New Member
Yeah I am running my accde file in the same folder root.

also I added a trusted location and I enabled all macros.

Nothing on the code is working (VBA) Macros are working well.

P.S all code is working well before the accde conversion
Nov 8 '09 #3
mrrcomp
6 New Member
HI Wassim,


I am having the same problem. Did you ever figure out how to solve it?

Regards
Meir R.
Mar 9 '10 #4
wassimdaccache
222 New Member
No didn t get any solutions yet ...
Mar 11 '10 #5
mshmyob
904 Recognized Expert Contributor
Before converting it into an accde format you should test ALL your code by "compiling" it. Everything may appear to work in the accdb version but when converted won't work if there are some problems.

To "compile" it you open your accdb version and go into any of the code. Then select the DEBUG menu option and select COMPILE (1st option). If you get any errors then fix them and the compile again just to double check. Then try creating your accde again.

Try this and let us know.

cheers,
Mar 11 '10 #6
mrrcomp
6 New Member
HI

I was just going to post the solution of "Compiling" the code before the converting to ACCDE. In Access 2003 and earlier version the conversion automatically did a "Compile" seems that 2007 doesn't. So even if there are no problems with the code you still need to "officially " compile it.

Thanks

Regards

Meir
Mar 11 '10 #7
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
You also need to compile it in Access 2003. At least that has been my experience.
Mar 11 '10 #8
Nizar Yussef
1 New Member
Hi ev one
I got the same problem with Access 2010

I did the Compiling and it worked just fine.

It seems to b that also in Access 2010 you must Compile before covert to ACCDE file.

tnx to u all
Nizar
Nov 12 '10 #9
informerFR
14 New Member
Hi Mshmyob

Thanks a lot for this information. You make my day and now it works perfectly
Jun 6 '16 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
22619
by: Robert | last post by:
I understand that new features would not be available but is there any way I could open an accdb database in Access 2003? Robert
4
7488
by: ARC | last post by:
I have another question. With Access 2007, as I understand it, you only need to use the .accdb if you are using features such as memo notes history, or the multiple selections for a given key id. Prior to deploying my program in Access 2007, I need to make sure I'm using the correct formats. I have a handful of misc. databases, one for workspaces / temp. tables, local config options and a to-do list. Should I use the .mdb format for...
1
3483
by: bigshotj | last post by:
Hey Guys, I have made a small application that has a main form and a sub form. The main form contains fields like Bill No., Name of Customer, Month. and The subform contains several fields like Sr. No., Date, Invoice No., etc. I have made this application for a friend of mine who owns a small Transport company. So I want to give him the application in .accde format. But then I converted it to .accde and two problems popped out. The...
3
7291
RobH
by: RobH | last post by:
I am trying to generate a complied version of my Application by clicking on the "Make ACCDE" in Access 2007. It asks me where and with what file name to save the ACCDE however it quickly returns with an error "Microsoft Office Access was unable to create the .accde, .mde, or ade file" It then displays a box with the following text.. "This error is usually associated with compiling a large database into an MDE file.* Because of the method...
1
2068
by: mark | last post by:
Hi, I've converted my Access 2007 database to an accde format as I don't want users to be able to modify it. The only problem is that all the code has stopped working. I have split the database and the backend is on a server and the location is in my trusted locations setting. Can anyone help? Thanks, Mark
6
5571
by: postman | last post by:
I have an application that minimizes the Access application window and displays a pop-up modal form. The Application window is minimized with this command in the form's Load event. DoCmd.RunCommand acCmdAppMinimize When opening the file, the form/application retains focus and appears on top after the application window minimizes. But when I save it as an ACCDE file and open that, the form/application loses focus. If there are any...
0
1841
by: brendanmcdonagh | last post by:
Hi all, I have been working with java on a database program that connects via jdbc odbc access driver on my xp desktop. It is working fine but I'm installing it on 3 pc's tomorrow so testing it on my vista laptop now. When i go to configure dsn on vista laptop and access database via my Z drive it is now calling a java.sql.sqlexception on load of jar file. Question 1 Can accdb have multiple conections? (please say yes!)
4
2661
by: junaidfaiz | last post by:
resently iv created a software which is working fine in open format and i just have madte it converted to .ACCDE file but have lost all the links attached to it's buttons. It is in the trusted folder and has no error report. I havn't got any thing which asks me something more to be done. Yet obvioulsy i can't access my Db completely with broken links.
4
5720
by: MrDeej | last post by:
Anybody now if i can do this programtically? My challenge is that i have a maybe 10 distributions a week with updates and changes which i now have found the accde format to be of good use. I also want to force our developers to change the title, write version history and so before we make the accde file and all that i can manage if we can get VBA to make the ACCDE file instead of pushing the button in Access
0
8403
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
8509
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8610
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7345
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6174
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5636
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4168
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2735
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1967
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.