Unanswered: Access 2007 Assets Database.accdb saved as Access 2003 .mdb?
I just got Office 2007 on XP installed at home. I looked at the new templates in Access and found that the Assets Database is just what I need on my job (inventory/asset management for office automation products). At work we are still running with Office 2003/XP. We are not jumping up to Office 2007 for the foreseeable future. Question: Is it possible to get the Assets Database from Access 2007 to run in Access 2003-compatible mode? http://office.microsoft.com/en-us/te...CT101428241033
Tools-> database utilities -> convert database -> To ..........
doe 2007 have the same function ??
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Here is the answer I posted over at mrexcel.com:
Okay, I guess I'll answer my own question.
Nope, won't work. Copied and pasted the Assets database.accdb template from my Office 2007 desktop to my Office 2003/XP laptop (okay, not mine, belongs to my employers). Attempted to save it as an earlier version of Access without success. Even attempted to rename the file extension from ".accdb" to ".mdb". Uh-uh, no-go.
To get from an .accdb to an .mdb, you say "No, you'd have to convert in [sic] down using 2007."
How do you even do this? I can't figure out how (using MS Access 2007)...
Also, I saw a post on a Hong-Kong-based forum that told how to switch the DEFAULT file type in MS Access 2007 to an older version (e.g., 2000 or 2003), but the menu options they mentioned don't exist. Any ideas on how to do this??