hello,
i am having a problem creating a .ACCDE file from an Access
2007 .ACCDB file.
its somewhat large application, about 80 megs. it was originally an
Access 2000 app that somebody else wrote for our user base, which ran
it as a .MDE. i have now converted it Access 2007 .accdb, and am to
use the "Make ACCDE" function off the Database Tools ribbon bar.
upon doing so it says i need to enable the content as a security
feature. no problem.
afterward tho, it reports:
"Microsoft Office Access was unable to create the .accde, .mde,
or .ade file."
....it has more info under "Show Help >>", which says the error is
usually associated w/ compiling large databases. dunno if that applies
to mine or not, since its the same app that Access 2000 was able to
convert to its .MDE format.
.....any thoughts of advice on things to try? im new to access, not
really the dev on this project, but tasked w/ the conversion.
thanks!
sm
4  5738 
On Jan 4, 5:09 pm, SpaceMarine <spacemar...@ma ilinator.comwro te:
i am having a problem creating a .ACCDE file from an Access
2007 .ACCDB file.
its somewhat large application, about 80 megs. it was originally an
Access 2000 app that somebody else wrote for our user base, which ran
it as a .MDE. i have now converted it Access 2007 .accdb, and am to
use the "Make ACCDE" function off the Database Tools ribbon bar.
upon doing so it says i need to enable the content as a security
feature. no problem.
afterward tho, it reports:
"Microsoft Office Access was unable to create the .accde, .mde,
or .ade file."
...it has more info under "Show Help >>", which says the error is
usually associated w/ compiling large databases. dunno if that applies
to mine or not, since its the same app that Access 2000 was able to
convert to its .MDE format.
....any thoughts of advice on things to try? im new to access, not
really the dev on this project, but tasked w/ the conversion.
ah...found a post on this. the error message is a typical MS red
herring -- what it really means to tell me, is that there is a problem
compiling one of the modules. evidently the only way you can locate
what & where is to open the VBA and attempt to Debug-->Compile there. http://www.access-programmers.co.uk/.../t-123872.html
sm
SpaceMarine <sp*********@ma ilinator.comwro te:
>
ah...found a post on this. the error message is a typical MS red
herring -- what it really means to tell me, is that there is a problem
compiling one of the modules. evidently the only way you can locate
what & where is to open the VBA and attempt to Debug-->Compile there.
That's what it can mean yes. And it's quite standard to compile before making an
MDE. Actually I compile every few lines of code to catch any typos and such. http://msmvps.com/blogs/access/archi...e-i-enter.aspx
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
SpaceMarine <sp*********@ma ilinator.comwro te:
>...it has more info under "Show Help >>", which says the error is
usually associated w/ compiling large databases. dunno if that applies
to mine or not, since its the same app that Access 2000 was able to
convert to its .MDE format.
There actually is a limit in large MDBs in previous versions of Access. I would
expect that this limit has not been fixed in A2007 although I could be quite wrong.
You receive a "Microsoft Access Was Unable to Create an MDE Database" error message
in Access 2002 http://support.microsoft.com/kb/289686/
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
On Jan 5, 7:35 pm, "Tony Toews [MVP]" <tto...@teluspl anet.netwrote:
SpaceMarine <spacemar...@ma ilinator.comwro te:
ah...found a post on this. the error message is a typical MS red
herring -- what it really means to tell me, is that there is a problem
compiling one of the modules. evidently the only way you can locate
what & where is to open the VBA and attempt to Debug-->Compile there.
That's what it can mean yes. And it's quite standard to compile before making an
MDE. Actually I compile every few lines of code to catch any typos and such.
nonetheless.... i think the cause of this error is far more likely to
be a compile error (due to, say, typo) than for it to be a db size
issue. thus, the error description is a hopeless red herring that
will, more often than not, be completely inaccurate.
sm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: sonasiva |
last post by:
hai
Iam creating my own website using ASP and MS ACESS ,iam new to ASP and SQL
Please help me to write a query to finish my project.
i have datas as follows in my database
sno name companyname shares percentage date
1 aaa kroft 5000 5 1/1/2007
2 aaa kroft 10000 10 1/9/2007
if i click "name" link the deatils should...
|
by: Neil Patterson |
last post by:
Hello,
After preparing a relationships diagram I select 'Relationship Report'. The
only response is the feedback 'The command you specified is not available in
an .mde, .accde, or .ade database.' Anyone know how to enable this feature?
.../neil patterson
|
by: kannanudt |
last post by:
Sir,
I had done one application in ms-access2007 using VBA code... now i am converting the database to exe format.
At the time one error message raises,,, i.e,
"Microsoft office Access was unable to create the .accde, .mde, or .ade file"
so.. please help me to avoid this error, what are the steps to be followed?
|
by: ARC |
last post by:
Hmmm...This is interesting. While reading info on packaging an Access 2007
runtime app, it's mentioned that a file such as, .accde (mde for 2007) will
be changed to .accdr, where the final r means runtime.
I assume by changing the extension manually yourself from the .accde to
accdr you can then simulate the runtime (instead of the old way of using the
/runtime switch). I tried this, and it works. When you double-click the
..accdr, it...
|
by: Lou O |
last post by:
I have been using Access 2007 for a number of months and have
successfully deployed ACCDR files on many client machines.
The client machines have the "free" Access runtime version installed.
I recently installed SP1 for Office 2007 on my computer.
Now when I make an ACCDE file to distribute, I get an error on client
machines something like
"database is in an unrecognized format".
There seems to be a compatibility problem between Office...
| | |
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
|
by: Brian Nelson |
last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm
just stuck!
We've had a multiuser .mdb file on a network share for years. I know
it's not ideal, but it's worked well from Access 2000 to 2003. Ever
since we upgraded to 2007, we've noticed some serious bloating.
When we were on 2003, after a fresh compact, the database would be at
about 20 MB. After normal use it would grow to about 25 MB and then
significantly...
|
by: KW |
last post by:
I have an application that runs in any of Access 2000 thru Access 2007
to accommodate my customers' various environments. I implemented code
to call a function that uses the LoadCustomUI method to load in my
custom ribbon for Access 2007. This function is called only when the
check for running Access version 12 or higher is true.
Everything works like I want in Access 2007. The problem is when I
compile it on Access 2000,2002,2003,...
|
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
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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,...
|
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...
|
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...
|
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
