473,320 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

What are the differences between Access 2000 and 2002-2003 formats?

176 100+
Hello.

I've been writting an Access app on office 2003 for sometime, and couldn't find any info on the net on what are the differences between the 2 formats, and why should I use Access 2002-2003 in favour of Access 2000.

Help would be appriciated.
May 1 '08 #1
2 6222
ADezii
8,834 Expert 8TB
Hello.

I've been writting an Access app on office 2003 for sometime, and couldn't find any info on the net on what are the differences between the 2 formats, and why should I use Access 2002-2003 in favour of Access 2000.

Help would be appriciated.
Just subscribing, as soon as I get a chance I'll list the enhancements/advantages of Access 2002 over 2000.
May 2 '08 #2
ADezii
8,834 Expert 8TB
Just subscribing, as soon as I get a chance I'll list the enhancements/advantages of Access 2002 over 2000.
I'll list some differences between Access 2000 and Access 2002 right from the Access 2002 Developer's Handbook. This list is by no means comprehensive. The most significant changes can be grouped into five major areas:
  1. Programmability
    1. Access 2002 includes VBA 6.3 which is an incremental advance over the VBA 6.0 language used with Access 2000.
    2. Forms in 2002 support an Undo() Event, and some Controls support Undo() and Dirty() Events.
    3. Access 2002 contains the new Printer Object and Printers Collection which makes it much easier to pro-grammatically control Printing Properties.
    4. New ImportXML and ExportXML Methods of the Application Object offer a programmatic interface between XML/XSL files and Access data and presentation.
  2. Access 2002 Forms and Reports
    1. Forms now offer two new views of your data: PivotTable and PivotChart.
    2. 2002 Reports now support the OpenArgs, Modal, PopUp, Borderstyle, AutoResize, AutoCenter, MinMaxButtons, CloseButton, and ControlBox Properties.
    3. Forms and Reports both have a new Removable Property.
    4. Forms and Reports can be saved as Data Access Pages.
  3. 2002 Data Access
    1. Access 2002 includes the SQL Server 2000 Desktop Engine which contains the new features of SQL Server 2000.
    2. The new Liked Tables Wizard allows linking of Tables to Access Projects via SQL Server Linked Servers.
    3. Access Projects are enhanced with new options to copy and transfer SQL Server Stored Procedures and Functions as well as new graphical designers for the above mentioned.
    4. You can now make use of SDQL Server Extended Properties.
    5. In 2002, you can toggle the SQL dialect supported in Queries (standard Access SQL or ANSI 92 Extended SQL).
  4. Internet and Intranet features
    1. The Data Access Page Designer now takes advantage of Extended Properties to correctly handle Lookup Fields and create Labels for Fields.
    2. The DAP Designer has extensively been enhanced with features like better Control sizing, Control multi-select, and more intuitive cursor cues.
    3. Data Access Pages are enhanced with a number of data-related events: AfterUpdate(), AfterDelete(), AfterInsert(), BeforeUpdate(), BeforeInsert(), Dirty(), Focus(), RecordExit(), and Undo().
    4. You can bind Data Access Pages to XML files.
    5. Access data can be exported to XML with optional XLS and XSD support.
    6. Access Forms, Reports, and Data Access Pages can also be exported to XML/XLS files.
  5. Other Improvements
    1. Access 2002 introduces an updated MDB file format for Access Databases, but it is also capable of using Access 2000 files without conversion.
    2. A 2002 DB can be converted to either Access 2000 or Access 97.
    3. Multiple levels of Undo and Redo are now supported for most Object Designers.
    4. Automatic logging of Conversion Errors.
    5. Compact and Repair functionality has been improved to better recover broken Forms and Reports.
    6. In Access 2002, you can pro-grammatically supply a Database Password when opening a Database.
May 2 '08 #3

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

Similar topics

3
by: jason | last post by:
Could someone highlight any known problems in converting an access 2000 to access 2002 database....should I expect a painful transition or can I expect a quick turnaround time to get my existing...
1
by: Steve Claflin | last post by:
I have a database with a moderate number of records in several tables (the biggest table at the moment is about 800 records). In development it got moved between 2K and XP repeatedly. Several...
0
by: Damon Heron | last post by:
This is repeatable: I recently upgraded to 2002 from 2000. When I start Access 2002, and open my 2000 mdb file, it works normally. However, if I open my mdb file by clicking on it directly, it...
1
by: Fred | last post by:
Hi. Is it safe to instll Access 2000 on a system that already has Windows XP and Office 2002 (Word, Excel Access, Powerpoint). Anyone done this? I would install it in a searate directory but...
2
by: MFS 43 | last post by:
Have previously upgraded from Access 2000 to 2002. Access 2002 seems to start as 2002 but when I create a new database, it says "Access 2000 file format" Why am I not getting a 2002 file...
1
by: Alan Brasel | last post by:
I have an Access database that I have been using for over a year. My company just replaced my computer with a "New and Improved" computer, and they also installed Access 2002 ( I was using 2000). ...
9
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly...
9
by: Neil Ginsberg | last post by:
I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access...
0
by: meyvn77 | last post by:
Hello, I wrote an .ADP application in Access 2002 and delivered it to the client. They are not due for an upgrade till January and are running Access 2000. They would like to use the...
2
by: Dedalus | last post by:
If I want to retrieve a full version information for an ms access databases, I use (from vb6 code) the "Access.Application" object and SysCmd method. Whit the number returned by the method I can...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.