Convert to Access 2000 question/problem

[lorirobn]

Hello,

I have created an Access desktop application that will be used on an SQL server. The Back End will be my tables and will reside on the server. The Front End will be my Access application, and will reside on individual computers. I have split my desktop application into front end and back end, and now am wondering about Access versions.

I have Access 2003, but have set my 'Default File Format' to Access 2000. One of my users has Access 2003 on his laptop, and the others have Access 2000. My question is: do I need to convert my application to Access 2000, or does the default file format make it compatible? I don't believe my application is actually in Access 2000 (because my command buttons look the newer way). Do I even need to convert???

Also, an error came up when I did try to convert to Access 2000. The message was: 'the report name 'DirDataCopy' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist'. I have no idea what this is; I never heard of 'dirdatacopy'. I did documentation (Documenter) on all my forms, reports, and queries, and searched for this expression, but no 'dirdatacopy' found. I searched all my VBA modules. I have no macros. Any suggestions on how to figure out this problem? It occurs whether I try to convert from my split database or my pre-split version. In addition, the conversion never seems to complete fully, as seen by the green progress bar that never reaches 100%.

Thank you in advance for any help,
Lori

 

[GingerR]

Hi. I suggest you create a blank/new Access 2000 database and import your objects into it. I had the same message about a report that didn't exist. It must save some listing about it, even thought it'd been deleted. I don't remember what I did to remedy it, but creating a new DB should work. Also try compact/repair, and compile it.

If at the top of the db window it says "Access 2000 Format" then it's in Access 2000, regardless of what the buttons look like.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[lorirobn]

Hi Ginger,
Thanks for your response. I checked as you suggested and my original db is in Access 2002-2003, so I do need to convert.

I have a few questions.
--How do I create a blank Access 2000 database using my Access 2003 application? I am trying to figure this out, and cannot (as yet) find info on it.
--my converted database, even though it had an error during the conversion, and conversion never completed fully, says 'Access 2000' on top. I feel that I should start over, because of this error. Would you agree?
--when you say to compact/repair, do you mean of my original Access 2002-2003 database? And I'm not sure what you mean by 'compile'. Would I do compact/repair, then try converting to Access 2000 again?
Sorry - just want to be clear with what you meant.
Thanks so much,
Lori

 

[lorirobn]

As an addendum, I figured out how to compile, did a compact/repair of the Access 2002-2003 version, did a compile, then tried to convert to Access 2000 again, but got the same error about report name ' dirDataCopy'.

 

[evalesthy]

Did you take GingerR's advice of importing all database objects (tables, queries, forms, macros, modules, etc.) into a new blank database? That often solves mystery problems like these.

 

[lorirobn]

I don't know how to create a new blank database in Access 2000 - can you please tell me how to do so? I have Access 2003, and this creates a new blank database in Access 2002-2003.
Thanks.

 

[evalesthy]

If you are using Acc 2003 open Access and choose 'Create a new file' and then choose 'blank database'. Give it whatever name you want. In the design view that opens you will see in the caption bar something like "your db name: Database (Access 2000 File Format)"

If that is what you see then you have created a database is Access 2000 File format. If it shows Access 2003 File Format then you could always go to toolbar, Tools --> Database Utilities --> Convert Database --> To Access 2000 File Format

Then go to toolbar File --> Get External Data --> Import and import all database objects. Under Options button be sure to select anything that applies to you (like relationships, toolbars (if custom toolbars exist) etc.).

That should do it.