473,671 Members | 2,601 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Microsoft Office Access 2003

3 New Member
I am hoping someone can help me. I converted a database from MS Office 2000 to MS Office 2003 and now I am trying to make an MDE from out. When I try to make an MDE file, I receive the following error:

This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.

anyone have any ideas?
Sep 28 '06 #1
0 1372

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

Similar topics

3
1026
by: Helene Day | last post by:
I am trying to access the Word Objects from a .NET project. I have some sample from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/WordObject.asp and I have MS Office 2003. However I don't know which file I need to reference for the MS Word 11.0 Object Library. Or what else do I need to install/download from MS to be able to create MS Office 2003 Projects.
27
3621
by: Chuck Grimsby | last post by:
(Repost, due to lack of submissions...) The Microsoft Access Product Group (the people who build Microsoft Access) want your help! One of the main things we're working on for the near future is a conversion tool to take Microsoft Access 97 databases (primarily, but also Microsoft Access 2000 or 2002/XP databases) up to Microsoft Office Access 2003. For us to do this, we need sample databases from *you*, our customers, to ensure a...
3
2403
by: Mike Pace | last post by:
When I package my Microsoft Access 2002 application with the Office XP Developer Packaging Wizard, and include the runtime, the resulting OSP1.CAB file that is created does not contain the latest msjet40.dll (SP8), but instead contains SP4. How can I upgrade the packaging wizard to include the latest component service packs, such as msjet40 and MDAC? Mike Pace M. L. Pace Computer Consulting
1
1970
by: TJ | last post by:
I am interested in packaging a database that I have created and understand I will need Microsoft Office Developer's Edition XP to allow users that do not have Access to run it. I have looked on the net and the prices range from $454 to $853. I have a couple of questions: 1. Is there a MOD 2000? 2. If so where is a good place to buy?
71
7922
by: Lauren Wilson | last post by:
Hello folks, Would love yo get all informed opinions and/or facts on the following: Over the last few weeks I have spent quite a bit of time reviewing all the Access and .NET stuff I could find on Microsoft.com. It's seems harder and harder to find much of anything about Access as a primary development platform. I am getting the uneasy feeling that Microsoft is slowly phasing out Access.
4
12271
by: bbdobuddy | last post by:
Hi, How do I open a Microsoft Access 2003 form from Visual Basic.net Thanks in advance bbdobuddy
9
2103
by: Dean | last post by:
I wrote a simple App in Access 2003 but used the 2000 file format. The one module Requires reference to Microsoft Office 11.0 Object Library. However, the person I have the code to has Office 2003 but only Microsoft Office 9.0 Object Library. Are they not backward compatible? Is there something the user can do to update this to Office 11?
6
7639
by: Excel 009 | last post by:
Hi, In my office I have Office 2003 on the PC. I created an Access application which has a component reference to Microsoft Office 12.0 Object Library. The problem that I am having now it that in my home PC I also have Office 2003, but I only have Microsoft Office 11.0 Object Library in it and not Microsoft Office 12.0 Object Library, so the application does not work right.
3
2116
by: Salad | last post by:
I have Microsoft Office Professional 2003 and the computer I connect to also has A2003 retail. The others in that office use Access 2003 runtime. Q1) I wanted to see if they were up-to-date on their service pack but the "About Microsoft Office" menu item is missing when the run my app. Is there a way to view the About form in the runtime version from the menu? Q2) Also, do folks with a runtime version need the SP3 and hotfix? Q3) ...
0
8485
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...
0
8403
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,...
0
8930
Oralloy
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...
1
8605
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
8677
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...
1
6238
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
4227
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...
0
4417
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2062
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.