Access 2013 to Access 2007 Compatibility Issues

[sxschech]

I have a new computer with Office 365 University. I had wanted to purchase 2010, but it was no longer available at the bookstore or the local microsoft store. I'm having issues with sharing the file with colleagues that have 2007. The people I am helping have no immediate plans to upgrade and I am not in a position to request that happen.

When they open the file it gives a warning message that some features are from a new version and as a result they are unable to view or edit some of the code. I thought about saving the file as mdb, but for some reason, I could not do a save as on the original file. Seems I can only save as when I am the creator of the file. When I try a save as on files created by others, the screen returns to the main screen and does not bring up a window to provide the file name or location. The other issue I noticed was that the file I created and saved as, no longer has an option for macros.

While I personally don't use macros, I learned that in order to identify if the database is enabled or needs to be enabled, the recommendation was to create an autoexec which will run regardless of enabled in order to bring attention to the user to click on enable in order to allow the vba to work.

Any suggestions, workarounds short of having to buy an older version would be greatly appreciated. If I have to get an older version is there an affordable source that is not shady.

 

[SkipVought]

hi,

Is there not a selection in SaveAs for a 2007 compatable workbook?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[sxschech]

Hi Skip,

I'm talking about Access not Excel. The options are:

Access Database Default database format
Access 2000 Database Save a copy that will be compatible with Access 2000
Access 2000-2003 Database Save a copy that will be compatible with Access 2002-2003
Template Save the current database as a database template (ACCDT)

There does not seem to be a separate option to specify 2007 or even 2010 format.

 

[SkipVought]

So sorry. There it is in the title.

Unfortunately, this forum addresses VERY FEW questiotion regarding MS Access.

Fortunately, there are MANY MS Access forums that would have members much more in tune with MS Access issues.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[sxschech]

I wasn't sure which forum is best to post (Forms, Modules, Other). Should I post in modules... or your recommendation?

 

[SkipVought]

looks to me like it might be forum181

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}