Project on access 2010 car wash db?

Asked By dixon eartha 10 points N/A Posted on - 08/25/2012

I have created a database in access 2010 about car wash. Does this access 2010 car wash db compatible with access 2003.

My friend is having ms access 2003 on his pc.

Any advice. Thanks.

Regards,
Dixon Eartha

• Status: Open
• Question Views: 1098
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Sharath Reddy

Go To Solution

Answered By reaiuhathy 0 points N/A #133568

Project on access 2010 car wash db?

 

Hi Dixon,

 

You can convert your MS Access from 2010 to 2003. But there are some features in 2010 that are not available in 2003.

 

Here are the steps to follow:

 

1. Open the Access file that you want to convert to 2003.

 

2. Click on the Microsoft Office logo on the upper left corner of the window and select "Save as".

 

3. From the given options, choose "Access 2002-2003 Database".

 

4. Decide the name of the file and the location in where you want to save it. Click Save.

 

Another way is to install MS Office 2010 to your friends computer since some of the features in 2010 are not available in 2003.

 

I hope this helps you.

About reaiuhathy

Questions
2

Answers
14

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/26/2012
• Question Category: MS Access

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #291399

Project on access 2010 car wash db?

Microsoft Office Access 2007 and 2010 uses the same default file format, .accdb while versions of Office Access earlier than Office Access 2007 uses .mdb file format by default. Now, if you want to create a database in Office Access 2010 that can be opened in Office Access 2003, the easiest way is to use the “Save As” option to convert the database to the older version.

Even if it is possible to convert the database using “Save As”, it is only possible if the .accdb file from Office Access 2010 doesn’t contain features that require the .accdb file to run. To convert the database from Office Access 2010 to Office Access 2003, in Office Access 2010, click “File” then “Save & Publish”. In “Save Database As” dialog, select one of the following:

• Access 2002 – 2003 Database (*.mdb) – select this option if you want a database that can be accessed in Office Access 2002 and later.
• Access 2000 Database (*.mdb) – select this option if you want a database that can be accessed in Office Access 2000 and later.

After this, select “Save As”. Here, if the database contains features that prevent you from saving in the .mdb file format, you should see a message on your screen and it will prevent you from continuing. If this happens, go to Factors that Prevent Conversion and then address the factors so you can continue saving the file. Enter the file name then click “Save”.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 03/15/2017
• Question Category: MS Access