ms Access 97 vs Access 2000

[azu_daioh]

Currently, 1 of our analysts has Access2000 and the rest are still on
Access 97. If I convert our database into Access2000 --will the folks
with Access 97 able to run the same database?

all 10 of us should only be using one database to enter/update the
records but 1 out of the 10 is not able to open the database due to
different version on Access installed in her machine.

Any suggestions as how I should handle this? Thank you.

 

[M.L. Sco Scofield]

As Access 2000 didn't exist when Access 97 came out, the short answer is no.

(The good news is the Access 2002 and 2003 work with the 2000 format by
default.)

The person with Access 2000 should be able to use the Access 97 format
database just fine. If it is single user, the 2000 person can open the 97
database without even converting. (Although they won't be able to create any
objects, they can add,delete, and modify data just fine.)

If this is a multi-user situation, you need to split the tables out to a
"backend" database of the lowest version you are going to use. Then, any
later version "front-end" can link to the tables just fine.

See the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;296179.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Chris Davis]

Thank you so much.

 

[azu_daioh]

Thank you so much.

 

[M.L. Sco Scofield]

You're most welcome.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com