Conversion issue

I have taken over the development of an application that the previous 
developer used Access 2003 to develop an application for a user with Access 
2000.  Once he had written enough code to test, he would convert the mdb file 
to version 2000 for testing on the client's machines.

It worked fine for a while.  Now when I try to run certain reports in Access 
2000, the Access window shuts down whenever it hits the report object.  I can 
get to the reports design view in Access 2003 but not in 2000.  If I try to 
design, preview or open the report object in 2000 the Access window shuts 
down but leaves the ldb file.

I know it sounds kind of weird but its stopping me cold in my tracks.

Any ideas?
I want to do all of the development in version 2000 but can't get the report 
objects to cooperate. 

I have some reports that I'm trying to develop bu
0
Utf
1/11/2008 10:08:02 PM
access 16762 articles. 3 followers. Follow

2 Replies
550 Views

Similar Articles

[PageSpeed] 51

This sounds like the kind of corruption that a decompile would fix.

Try this sequence (in order):

1. Uncheck the boxes under:
    Tools | Options | General | Name AutoCorrect
Explanation of why:
    http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
    Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by 
entering something like this at the command prompt while Access is not 
running. It is all one line, and include the quotes:
    "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
        "c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code), 
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
    http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Still in the code window, choose Options on the Tools menu. On the 
General tab, make sure Error Trapping is set to:
    Break on Unhandled Errors
and the Compile on Demand is unchecked.

At this point, you should have a database where the name-autocorrect errors 
are gone, the indexes are repaired, inconsistencies between the text- and 
compiled-versions of the code are fixed, reference ambiguities are resolved, 
the code syntax is compilable, and the VBA options are set to show errors 
and avoid this kind of corruption.

If it is still a problem, the next step would be to get Access to rebuild 
the database for you. Follow the steps for the first symptom in this 
article:
    Recovering from Corruption
at:
    http://allenbrowne.com/ser-47.html

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TJ Dowling" <TJ Dowling@discussions.microsoft.com> wrote in message
news:CD50603A-3B13-4740-B2F7-D55F1FB69591@microsoft.com...
>I have taken over the development of an application that the previous
> developer used Access 2003 to develop an application for a user with 
> Access
> 2000.  Once he had written enough code to test, he would convert the mdb 
> file
> to version 2000 for testing on the client's machines.
>
> It worked fine for a while.  Now when I try to run certain reports in 
> Access
> 2000, the Access window shuts down whenever it hits the report object.  I 
> can
> get to the reports design view in Access 2003 but not in 2000.  If I try 
> to
> design, preview or open the report object in 2000 the Access window shuts
> down but leaves the ldb file.
>
> I know it sounds kind of weird but its stopping me cold in my tracks.
>
> Any ideas?
> I want to do all of the development in version 2000 but can't get the 
> report
> objects to cooperate.
>
> I have some reports that I'm trying to develop bu 

0
Allen
1/12/2008 2:57:29 AM
Allen,

Thanks for the tip.  It worked!

TJ Dowling

"Allen Browne" wrote:

> This sounds like the kind of corruption that a decompile would fix.
> 
> Try this sequence (in order):
> 
> 1. Uncheck the boxes under:
>     Tools | Options | General | Name AutoCorrect
> Explanation of why:
>     http://allenbrowne.com/bug-03.html
> 
> 2. Compact the database to get rid of this junk:
>     Tools | Database Utilities | Compact/Repair
> 
> 3. Close Access. Make a backup copy of the file. Decompile the database by 
> entering something like this at the command prompt while Access is not 
> running. It is all one line, and include the quotes:
>     "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
>         "c:\MyPath\MyDatabase.mdb"
> 
> 4. Open Access (holding down the Shift key if you have any startup code), 
> and compact again.
> 
> 5. Open a code window.
> Choose References from the Tools menu.
> Uncheck any references you do not need.
> For a list of the ones you typically need in your version of Access, see:
>     http://allenbrowne.com/ser-38.html
> 
> 6. Still in the code window, choose Compile from the Debug menu.
> Fix any errors, and repeat until it compiles okay.
> 
> 7. Still in the code window, choose Options on the Tools menu. On the 
> General tab, make sure Error Trapping is set to:
>     Break on Unhandled Errors
> and the Compile on Demand is unchecked.
> 
> At this point, you should have a database where the name-autocorrect errors 
> are gone, the indexes are repaired, inconsistencies between the text- and 
> compiled-versions of the code are fixed, reference ambiguities are resolved, 
> the code syntax is compilable, and the VBA options are set to show errors 
> and avoid this kind of corruption.
> 
> If it is still a problem, the next step would be to get Access to rebuild 
> the database for you. Follow the steps for the first symptom in this 
> article:
>     Recovering from Corruption
> at:
>     http://allenbrowne.com/ser-47.html
> 
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> 
> "TJ Dowling" <TJ Dowling@discussions.microsoft.com> wrote in message
> news:CD50603A-3B13-4740-B2F7-D55F1FB69591@microsoft.com...
> >I have taken over the development of an application that the previous
> > developer used Access 2003 to develop an application for a user with 
> > Access
> > 2000.  Once he had written enough code to test, he would convert the mdb 
> > file
> > to version 2000 for testing on the client's machines.
> >
> > It worked fine for a while.  Now when I try to run certain reports in 
> > Access
> > 2000, the Access window shuts down whenever it hits the report object.  I 
> > can
> > get to the reports design view in Access 2003 but not in 2000.  If I try 
> > to
> > design, preview or open the report object in 2000 the Access window shuts
> > down but leaves the ldb file.
> >
> > I know it sounds kind of weird but its stopping me cold in my tracks.
> >
> > Any ideas?
> > I want to do all of the development in version 2000 but can't get the 
> > report
> > objects to cooperate.
> >
> > I have some reports that I'm trying to develop bu 
> 
> 
0
Utf
1/14/2008 3:29:00 AM
Reply:

Similar Artilces:

Conversion 411
Hello, I currently have a couple of databases in 2000 format that are split into BE/FE and that have user-level security. Our IS department is in the process of upgrading our office suit from 2002 to 2003. I read that it is not necessary to convert my 2000 db's to 2003 because 2003 will read 2000 formats. However if I do opt to convert my databases, what is the process to follow and do I have to compact and repair? As you can see I am fairly new to this and I would like to get as much info. as possible. Thank You First, if you have not recently conducted a compact and repair,...

EBCDIC to ASCII Conversion
Four records in a mainframe file look like this: -------------------------- a m =20 0809100000805F001460008000 0104F000F002F20009C014C20C -------------------------- | =ACB =20 0054400000115C001760012000 1688F000F083F20014C017C20C -------------------------- d =AC =20 1810500000017F002770169000 0400F000F042F20161C026C20C -------------------------- & =AC g =20 3590500000804C000100090000 4002F000F071F20093C001C20C -------------------------- How can I convert those records to look like this: 008100941F0000000F0080025FF2000010496C0001048C02000C ...

Upgrading from QS2000 Problems/ Issues
I'm considering upgrading from QS 2000 to RMS 1.3 or 2.0. Should i wait until 2.0 is fully released and tested ? What are known problems /issues when upgrading to 1.3 ? Thanks Robert QS2000 has been discontinued and you will not be able to get any support. You should consider migrating to 2.0 directly. "Robert" wrote: > I'm considering upgrading from QS 2000 to RMS 1.3 or 2.0. > Should i wait until 2.0 is fully released and tested ? > What are known problems /issues when upgrading to 1.3 ? > Thanks > Robert > > ...

PROBLEM WITH ACCESS 95 DATABASE CONVERSION
Hi. I have a problem converting an access 95 database to access 2002. When the conversion is completed, It makes a table with one error field. The error is: " FILE MSJETSQL.TLB NEEDS THE VBE REFERENCE OR IS ERRONEOUS " I tried with other access 95 databases and It happen in everyone. I tried in other computer with the same configuration and it works ok. What can I have to do?. Reinstall the Access 2002?. Search for the file msjetsql.tlb in disk?. Thanks. I've solved copying the file from other PC. "JP" <aspento_quitar_para_correo_@arrakis.es> escribi� en e...

Multiple send issue
Hi. I know this is possible- I need to be able to send as different accounts with outlook tied to an exchange server, and I can't remember for the life of me how to do it. I know there's the "from" buttton access that will let you send as a contact in your windows address book, but that is not quite what I was looking for. Any pointers back on the path will be helpful. Thx in advance. >-----Original Message----- >Hi. >I know this is possible- >I need to be able to send as different accounts with >outlook tied to an exchange server, and I can't r...

Inventory issues for Project Module
I have installed the project module for GP and i have two questions: How can I validate with a report which inventory items have been received for a specific project? Next: does the Inventory Module allocate inventory that has been allocated for a specific project? I had ordered two monitors in Project and I received the two monitors in Project but when I check inventory- it does show that the monitors are received but not allocated. The next person who checks inventory will think that there are two available monitors..when in fact they are already spoken for in a particular project. Ho...

Data conversion problem
I am new to excel macro. I am importing data from SQL server into excel. My script within DTS job creates the file using a template and populate the sheets. The query runs fine and the data gets populated. But the problem is that all the numeric fields are in wrong data type. It looks like they are all character and there is a small green arrow at the top of each field. What do I need to do to convert them to number as soon as the sheet finished populating? I tried formatting my template, but did not work. The number of record change with every run. Any suggestion?? Biti >>What d...

CRM 4.0
Hi, I'm a relatively new CRM developer. I just attended the CRM conference in Toronto a week ago and I'm pretty excited about coming in on a fresh release. One of the options that seem very useful of course are "many to many" relationships. I've tried to customize the products entity to create my own relationship. Basically the situation I have is that I'm creating course packages (products) with sub-products (courses). So I'm going into the products table and creating a many-to-many relationship with itself. So far so good. Indeed, all the "...

Excel Range Value issue (Excel 97 Vs Excel 2003)
Hi, I have some VB6 code which was originally written to populate a spreadsheet in EXCEL 97. Basically, to cut a long story short, what the code does is it populates a variant array by calling a stored procedure. The variant array in question is populated with 3 elements (a date, and 2 floats). The array is then passed to Excel like this. Dim xlRng As Excel.Range xlRng.Value = vntDataArray In my particular scenario, the first four rows have the following dates in the "dd/mm/yyyy" format. 29/11/1995 30/11/1995 01/12/1995 04/12/1995 These dates are exported perfectly to Excel 97...

Why don't Microsoft issue Self-pace RMS Text book
I find for material to study but cannot, why don't ms issue rms text book There is a training manual you could buy for around $100. Have you read the RMS manual and practiced with the sample database and used the RMS help files? Rick Brown DataBasics "falunkai" <falunkai@discussions.microsoft.com> wrote in message news:3483C77A-EAD9-40DF-AF32-345C62B8B88C@microsoft.com... >I find for material to study but cannot, why don't ms issue rms text book There's also a Web Based training - around 20 hours and self paced for about $300. It's what our new t...

Conversion between Access 2002 and 2003 only via 2000?
I've been developing an Access database (mdb) with a SQL Server backend. In the end, the project will be installed on mostly Access 2000 systems and a few Access 2003 systems. I'm developing in Access 2002. Until now I had no problems running and compiling the program for any one of the three versions. After adding some more functionality I'm having the following problem: --- I copy the version from A2002 to the A2003 system. As soon as I try to run it in A2003, it crashes. If I bypass the startup options I can access the database window, but as soon as I try to access the VBA cod...

Outlook 2003/Exchange 5.5/Syncro issue
I upgraded to Outlook 2003 from Outlook 2000. I used to be able to syncronize all folders using F9. This no longer works in Outlook 2003. The 'All Accounts' send/recieve group includes Exchange and all relevant folders. Is there a way to fix this? Thanks, Craig Buchanan Hi Craig, Thank you for your post. It may be better if you post this question in the following newsgroup: Microsoft.private.directaccess.Outlook-Exchangeclient The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who visit the newsgrou...

Conversion of Office 2000 Publisher to Office 2000 Word
Does anybody have the secret to this? I don't want to just paste the Pub as a picture I want an editable Word format. Thanks for listening. Sorry, no easy way unless you can turn it into a .pdf and the convert that ..pdf into a .doc with ScanSoft's PDF Converter. Even that isn't 100% reliable but it's close. -- JoAnn Paules MVP Microsoft [Publisher] "Jon Williams" <anonymous@discussions.microsoft.com> wrote in message news:1762901c4491c$34715110$a301280a@phx.gbl... > Does anybody have the secret to this? I don't want to > just paste the Pub as ...

Conversion 2.0 and 97 to 2000 using 2003
We need to convert various 2.0 and 97 databases to 2000. We will shortly be having XP installed and will have to use Office 2003 with Access 2003. Are there any problems with doing the conversions this way? Will we still be able to convert 2.0 and 97 databases using 2003. I know that many of the databases will not automatically convert. ...

Identity/password issue
I have three identities and one is not retaining its password. I have attempted OL2000: (IMO) Your Password Is Not Retained in Windows 2000 or Windows XP but it did not work. I am seeing there are many others with this issue and am wondering if anyone was successful in fixing it. ...

Blank cell conversion to text
If I have a column of blank cells, how do I formulate to make them read as text? One way: Select the column and choose Cells/Number/Text from the Format menu. In article <270F582F-4C73-4C56-885C-74832CCE9920@microsoft.com>, "MaryMMG" <MaryMMG@discussions.microsoft.com> wrote: > If I have a column of blank cells, how do I formulate to make them read as > text? ...

Quicken Premier 2004 Conversion to Money
I just downloaded the trial version of Money. I wanted to do a comparison of Money vs Quicken. The conversion program does not properly convert the file; i.e. all of my check account transactions show a date of 1/1/90 and the amounts are zero. Everything else is blank. Is there a corrected conversion program out there? Jerry Ask again when M05 has been released and BEFORE upgrading to Q05. "jerry419" <jerry419@bellsouth.net> wrote in message news:228101c389ac$6a225140$3501280a@phx.gbl... > I just downloaded the trial version of Money. I wanted > to do a comp...

Active Directory Issue
The Network Administrator for my client took it upon himself to remove several past users from the Active Directory without removing them from MSCRM. The application now throws an error anytime any of the associated records are manipulated "Object cannot be found . . . ." I have searched the techknowledge database and found an article that listed three options. One was to remove the MSCRM license and replace it - it didn't work. The next was to restore the Active Directory using an Authoritative Restore - the network admin had not included the Active Directory locat...

Visual Basic 6.0 conversion
Can Microsoft Access 2003 convert a Visual Basic 6.0 program Hi Michael, Depending on what the program does it's possible that some or many of the VB6 procedures will run without much change, but there's no automatic conversion system. On Wed, 14 Jan 2004 12:38:35 -0800, "Michael" <anonymous@discussions.microsoft.com> wrote: >Can Microsoft Access 2003 convert a Visual Basic 6.0 >program -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. ...

COleDateTime ,SystemTimeToVariantTime Issues Questions
Hi All- I have a need to use a COleDateTime variable which I pass into an ADO record set and ultimately goes into a SQL database. My app uses the COleDateTime::GetCurrentTime function. Multiple calls to this function return the same exact time until some temporal threshold is reached and then it jumps up to a new time. I used CTime::GetCurrentTime function which works fine. I then convert the CTime to system time and finally to a variant time with the SystemTimeToVariantTime function. As soon as I get it in the variant type I run into the same problem as mentioned above. Why is this??? ...

Exchange clock settings/issue
I have a question about the clock settings on our exchange server. I am not sure if this is the right place to post, but I am hoping someone has had an issue similar to this one. We use an exchanger server 2003 and all of our clients PC's (Windows XP) sync up to the clock on the exchange server. For some reason our clock on the exchange server runs 6 minutes faster than the atomic clock. I am not sure where the exchange server pulls its time from or how it does. All of the clients show that their time is being pulled from the exchange server when I run 'net time' from the ...

Where to send Outlook connector for domino issues
Where do I send issues I have re Outlook connector for domino? The "register with us now" link on http://www.microsoft.com/downloads/details.aspx?familyid=8EBBBA59-5F17-4E52-8980-C4F0DFA92D65&displaylang=en is not fruitful. One specific issue - when others in the corp send an email with a word attachment, Outlook is unable to download it. Once I've tried then even Notes find the document is corrupted. Also, why can't I use my Outlook contacts as one of the address books as well as the Notes server AB. ...

Office 2004 corupt font issue
Hey folks, this is my first post and a last desperate attempt to get Office 2004 to work properly on my machine. I searched a bit to see if this issue has been addressed but couldn't find anything. First a little background: I have a 1.8ghz [dual processor] G5 running 10.4.3 and I have been running Office X without any issues. I bought Office 2004 Standard edition [upgrade] to keep everything current on my machine. I'm a freelance art director/graphic designer so keeping current usually makes my life easier. Currently I use Font Book as my font manager. This is my work machine, I don...

MnyBank : Ofc Ofx file conversion and Money import (V1.5.17)
Version 1.5.17 - Batch file conversion from CSV, QIF, OFC, OFX V1, OFX V2 (xml) to OFX V1, OFX V2 (xml), Excel (xml), - Demo at http://ferraroa.dyndns.org:8200/MnyBank/help/ with online conversion from OFC, OFX V1, OFX V2 (xml) to OFX V1, OFX V2 (xml), Excel (xml). A test file can be downloaded from the web not to use private data for testing. Version 1.5.16 : - Can save data into Excel Xml files (File/Save As) - Setting wizard in french and english - New link : http://ferraroa.dyndns.org:8200/MnyBank/bin/MnyBank.zip Version 1.5.12 : english help file and documentation (except...

owa ssl issues
We have a simple domain: 2 servers, 1 2003 DC, the other 2003 DC running exchange 2003. Recently we installed an SSL certificate (according to Microsofts's instructions) for Outlook Web Access. We also have a redirect script so that when user's type http://ourserver it redirects to https://ourserver/exchange. Since creating this some of our users get the warning box in Internet Explorer stateing that "the web site contains secure and nonsecure items" etc. If they choose no to not allow nonsecure items they get a "page cannot be found" error page. If they choose yes ...