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.
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.
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.
Â
