Access compatibility issues?

[YounesB3]

Hello, I need both versions of Access 2010 & 2003 to run 2 different databases. Would it be possible to also install Access 1997 for another database access or will I have compatibility issues for sure if I do?

Kind Regards,
Younes

[YounesB3]

hello, i need both versions of access 2010 & 2003 to run 2 different databases. Would it be possible to also install access 1997 for another database access or will i have compatibility issues for sure if i do?

Kind regards,
younes

bum p

[redbull]

I have a database front end that users in 2003 and 2010 use. the trick is to create the database in 2003. If your not concerned about ribbons and navigation panel you should not run into any issues. 97? I have no idea.

[YounesB3]

I have a database front end that users in 2003 and 2010 use. the trick is to create the database in 2003. If your not concerned about ribbons and navigation panel you should not run into any issues. 97? I have no idea.

Yeah, I already have 2003 & 2010 and I need both. But now, I would also need 1997, but I'm not sure if I should or everything will screw up...

[redbull]

Hmm wonder if you could attach a access runtime file from 2003 to avoid using 97.

[YounesB3]

Hmm wonder if you could attach a access runtime file from 2003 to avoid using 97.

How do I do that?

[redbull]

well generally runtime access can be used if the user does NOT have microsoft access.. but I wonder if we can make it work in this scanario. Maybe someone with a little more exp with runtime can chime in, but I will poke around the webs and post what I find.

[redbull]

Alright... So this is what i've found so far.

    If SysCmd(acSysCmdRuntime) = False Then        'The user is using a full blown version of MS Access            Else        'The user is using the runtime version of MS Access    End If

So, I don't know how but basically.

Need a version check at load,

IF access 1997 then

load load access runtime

[YounesB3]

Thanks for the help. Apparently, there aren't any compatibility issues if you have all 3 versions.