A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2002 - 2003 file format vs. Access 2000 file format



 
 
Thread Tools Display Modes
  #1  
Old January 20th, 2006, 11:08 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Access 2002 - 2003 file format vs. Access 2000 file format

I am using Access 2003. When I create a new database, Access creates in
Access 2000 file format. My question a

1. Why Access creates in the 2000 file format, not the 2002-2003 file format?
2. Why would I want to create my database in the 2000 file format, not the
2002-2003 file format or vice versa? Advantages & disvantages?
3. Other Suggestions?

Thanks.
  #2  
Old January 20th, 2006, 11:55 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Access 2002 - 2003 file format vs. Access 2000 file format

Since all 3 of Access 2000, Access 2002 and Access 2003 can read the Access
2000 format, that's the default in both Access 2002 and Access 2003: it
maximizes the usability of the database.

However, to make an MDE, you must convert to the "native" file format:
neither Access 2002 nor Access 2003 can create an MDE from a database in
Access 2000 format.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"AccessHelp" wrote in message
...
I am using Access 2003. When I create a new database, Access creates in
Access 2000 file format. My question a

1. Why Access creates in the 2000 file format, not the 2002-2003 file
format?
2. Why would I want to create my database in the 2000 file format, not
the
2002-2003 file format or vice versa? Advantages & disvantages?
3. Other Suggestions?

Thanks.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice needed: Should we upgrade MS Access 2000? And if so to what? ship General Discussion 43 November 30th, 2005 10:58 PM
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 10:04 AM
Access 2000 DB in Access 2002 Tony_VBACoder General Discussion 2 July 28th, 2004 01:23 AM
Access 2003 RK General Discussion 12 June 14th, 2004 10:16 AM
Unsafe Attachments Ron Installation & Setup 2 June 9th, 2004 01:55 AM


All times are GMT +1. The time now is 12:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.