Accessing database in Access 97 instead of Access 2010

Asked By DowneyRobert 0 points N/A Posted on - 12/08/2011

Dears,

Is it possible to open an older access database in Access 97 instead of Access 2010?

 

What do I do to get all column names with types alongside?

 

Can I combine multiple columns of different formats and query using nested IFs?

 

Sure you have correct answers.

 

Thanks in advance.

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

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Pramod Steve

Go To Solution

Best Answer

Best Answer

Answered By Pramod Steve 0 points N/A #120824

Accessing database in Access 97 instead of Access 2010

Hi,

Many organization maintaining access database in older versions. So you can maintain your older access database by converting as a current versions in following procedure.

 

Open the current version of Microsoft Access then Select "Open" from the "File" pull-down menu. Browse your computer and locate the file you wish to convert and double-click on it. Convert/Open Database wizard will appear.

 

Select Convert Database then Click OK. Then you need to enter a NEW name for the converted database. After that the converted a database will be opened.

 

You have to keep in mind that converted database cannot be open in older version.

About Pramod Steve

Questions
2

Answers
8

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 12/08/2011
• Question Category: MS Access

Answered By ahkamran 0 points N/A #120827

Accessing database in Access 97 instead of Access 2010

Depending on your computer's configuration and your working environment, there are several things you can do that may improve the performance of Microsoft Access or your Access database.

If you are optimizing the performance of an Access database, the best place to start is with the Performance Analyzer. You can use the Performance Analyzer to analyze a whole database or just selected objects in a database.

 

About ahkamran

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 12/09/2011
• Question Category: MS Access