Hi
can Access 2007 natively open an Access 2013 database or do I have to save it in mdb format?
THanks
Ian
Hi
can Access 2007 natively open an Access 2013 database or do I have to save it in mdb format?
THanks
Ian
both formats are .accdb so no need to convert to .mdb
However if your 2013 developed app has features not available in 2007 (you'll need to google to find out what) then the app will fail in 2007. Also, not tested but if your 2013 app has later version references e.g. to word/excel/outlook etc it may also fail on those as well (but you can use late binding to get round that). It is always better to develop to the oldest version to avoid these issues
In the first instance, just open in 2007 and see what happens - ideally in a test environment, not a production one.
Also not tested but you could provide the 2007 user with a 2013 runtime environment (but then you need to make sure your db will run in a runtime environment (i.e. no reliance on ribbon, navigation pane, shortcut menus)
Hi
thanks for the info, it gives me fod for thought!!
I'll experiment with the runtime. I don't really want the sub-admin person to have full access to the back-end but I do need him to be able to add, delete and remove records
thanks again
Ian