Linking Access 97 tables in Access 2010

[Robbie]

Hey, was hoping somebody could help me.

I hope this has not been answered somewhere before but I could not find it.

Our office is stuck using access 97. For obvious reasons I would like to follow the rest of the world into this century and move to 2010.

Problem is that over the years many people have created many MDBs and not of them them knew what they were doing! It is all a bit messy.

If we start converting databases we will inevitably end up with 2010 front ends linked to 97 tables. I know it is possible to do this and I have done some testing and everything looks okay but does anybody know if this will cause any unexpected side effects? Anything like supported data types across the different versions or anything like that?

 

[gemma-the-husky]

there is no problem with an A97 back end,

i actually think A97 tables seem to perform better than later ones - A97 certainly consumes less resources than later versions


the only problem may come if you move to W7 say - which does not support A97, in which case you may find it difficult to maintain the back end.

 

[Robbie]

Thanks!

I have heard before that access 97 will be the best for performance.

I am glad to hear that they will be okay.