Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2006

Tip: Looking for answers? Try searching our database.

Access 2000 file format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jenny - 01 Feb 2006 10:46 GMT
Hi all

Although all users have Access 2002, my database now says (Access 2000 file
format) at the top of the database window when opened on any PC.  Anyone know
what I can do to convert it back to 2002 format please?

Many thanks
John Spencer - 01 Feb 2006 13:21 GMT
By default the datafile are in Access 2000 file format.  If you really want
to convert the file format then open the database in design view, go to
tools, Database Utilities, Convert Database and select the option to convert
to 2002 file format.
In most cases, you can use an Access file that implements an Access 2002 or
later feature in Access 2000 without any problems. However, if you open an
Access 2000 file in Access 2002 or later and create a Visual Basic procedure
that uses an object, function, property, method, or argument that is
available only in Access 2002 or later, you'll receive a compile error when
you open the Access file in Access 2000.

> Hi all
>
[quoted text clipped - 5 lines]
>
> Many thanks
Jenny - 01 Feb 2006 13:35 GMT
Thanks a million

> By default the datafile are in Access 2000 file format.  If you really want
> to convert the file format then open the database in design view, go to
[quoted text clipped - 16 lines]
> >
> > Many thanks
Rajat - 01 Feb 2006 13:35 GMT
in access.....goto Tools->options
under "advanced" tab u will find "default file format" ....chg it t
access 200

--
Raja
Douglas J Steele - 01 Feb 2006 21:03 GMT
Actually, that won't convert the databases she's already created.

As John correctly pointed out, you need to use Database Utilities | Convert
to change any existing databases.

Signature

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

> in access.....goto Tools->options
> under "advanced" tab u will find "default file format" ....chg it to
> access 2002
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.