Max Wanadoo
max.wanadoo at gmail.com
Tue Jun 30 00:21:31 CDT 2009
Talking of which, John. How is the re-write of EatBloat going? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 30 June 2009 02:38 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access error You know what I want to see is a database comparison tool that uses eatbloat to export every object, then do a comparison between each file from the two databases being compared. John W. Colby www.ColbyConsulting.com Jim Lawrence wrote: > Well William or Max: > > Never having used the EatBloat MDB what would be the best way to launch and > use the form? > > Also which reference library do I attach to get such functionality as: > Office.FileDialog. Check 4 website and acquired 3 different answers. Attach > a reference call to a specific package ??? or add the appropriate API calls? > > TIA > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Monday, June 29, 2009 12:33 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access error > > Jim > > ...no, the switch setting is what I use ...its the process that is a bit > more complex than simply running the decompile > ...the decompile switch itself only works reliably if you follow the steps > before and after using it ...in other words it only puts your app in a state > > that will result in a clean build "IF" you walk though each step. > ...its always been confusing to me ...sometimes it appears to work by itself > > ...other times not ...the only consistent decompile results I've achieved > come when I follow the complete process, not just right click on "decompile" > > ...besides which, I should have mentioned that I also use Max's EatBloat app > > when even decompile doesn't work for me ...but I've said it so many times > here people think Max is paying me off :) > > William > > -------------------------------------------------- > From: "Jim Lawrence" <accessd at shaw.ca> > Sent: Monday, June 29, 2009 1:21 PM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] Access error > >> Hi William: >> >> I am not sure now whether the decompile is working correctly. I added the >> decompile feature to my 'file-type...MDB' options many years ago and other >> than update it occationally depending on which version of Access I have >> been >> using. I have not really checked it over. >> >> Is there any more switches than just >> 'C:\Program Files\Microsoft Office\office(10 or 11 or 12)\access.exe >> c:\project\my.mdb /decompile' ? >> >> Jim >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman >> Sent: Monday, June 29, 2009 6:27 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Access error >> >> Jim >> >> ...never saw that problem but I note you said you had decompiled >> ...on the off chance that the decompile didn't actually run, >> ...I've found using the decompile switch to be very buggy >> ...it works ...but only if I do it by the numbers >> ...by itself, it runs but does nothing leaving only the illusion of a >> decompile >> >> ...my process is: >> >> Turn Off CompactOnClose >> Decompile >> Exit >> Open w/Shift >> Compact w/Shift >> Compile >> Compact >> >> ...that actually works reliably, where just running the decompile itself >> often does nothing real. >> >> William >> >> -------------------------------------------------- >> From: "Jim Lawrence" <accessd at shaw.ca> >> Sent: Monday, June 29, 2009 8:16 AM >> To: "'Access Developers discussion and problem solving'" >> <accessd at databaseadvisors.com> >> Subject: [AccessD] Access error >> >>> Hi All: >>> >>> I have just run across an error in MS Access 2003 I have never seen >>> before. >>> >>> The Access is the proper format... 2003, a new DB was created and all the >>> objects were moved from another MDB... giving the same error, the code >>> modules compiles with no errors, the number of objects in the MDB is >>> relatively small and the MDB has been decompiled. >>> >>> The error is as follows: >>> >>> <error message> >>> Microsoft Office Access was unable to create an MDE database >>> >>> 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. >>> >>> More information about this error message online. >>> </error message> >>> >>> The error is as far as I can see is irrelevant. I will now be going >>> through >>> object by object removing or adding and compiling until the error either >>> stops or starts. >>> >>> If anyone has seen this type of error before and has been able to resolve >>> or >>> better yet find out why, I would be very appreciative. >>> >>> Jim >>> >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com