Deploying Access 2010 Accde But Some Users On Access 2007

[accessNator]

I have created an .accdb file in Access 2010 and split the databases. I then created a .accde file in Access 2010. Now I found out that a couple of my users who want to use my .accde file has Access 2007 on their computer. They cannot open my .accde file. How do I create a file so my Access 2007 users can use it?

Thanks in advance,
Chuck

 

[Fuse3k]

You could try opening you accdb in 2007 and saving it as a 2007 accde.

 

[AccessMSSQL]

I can't post links yet but you can try this search in Google: access 2010 and access 2007 backwards compatibility.

If you are using features specific to Access 2010 you will have problems trying to run it in 2007. I actually have to deploy 2 different ACCDE files for this situation, but my users are also running a variety of OS (some 64 bit on Windows 7 and some 32 bit on Windows XP). Good luck!

 

[Boss1b]

Agree w/AccessMSSQl... Have same situation here. Users running Office 2010 and 2007. Coding is done in 2010. Open the database in 2007, go into vb, check for missing references, replace with correct ones for that version of office. Compile it, create accde and implement. Maybe not the best solution, but it works.