• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Developed in Access 2010 - Saved as Access 2003

Hi,
I developed an fairly simple database in Access 2010.

I then "saved as" to Access 2003.

The end user has both access 2010 AND 2007.

The system worked fine on users 2010 system.
However, it is NOT working on the 2007 version.
(Details not fully known at this point ... just a email from user saying "they can't get into options")

I had assumed (!) that if I developed in 2010 and "saved as" 2003 that it would run in 2007.

I will be talking to the end user tomorrow.
Can anybody give me pointers as to why the system would not work given the above.
i.e. Problems - developed in 2010, saved as 2003 and end user running 2007.



0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<
Can anybody give me pointers as to why the system would not work given the above.
>>

 Yes. 2010 is buggy and should not be used to work on a DB in a prior format.  I'm assuming the "save as" has some of the same issues.

 Not a great answer I know, but until you get more detail on the problem, it's hard to say anything specific.

JimD.
0
 
Rey Obrero (Capricorn1)Commented:
refer to this link
Backward Compatibility between Access 2010 and Access 2007
http://msdn.microsoft.com/en-us/office/cc907897.aspx

* start developing a  .mdb file
* avoid using features available in a2010 and not in a2007(see link above)
0
 
Patrick O'DeaAuthor Commented:
Thanks for comments and links - which I am reading.
Unfortunately, I do not have full details of customer problems at present.

However, can I add ONE more point which may (or may not) be relevant.

I have another PC that has Access 2007 where the software works fine.
Any thoughts?  In summary ;

1. Software developed on my PC-A with Access 2010. (Saved as 2003).
2. Software works fine on my PC-B which is Access 2007.
3. Software DOES not work on customers PC which is Access 2007.

I appreciate that there is not full details and good advice has already been given.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Rey Obrero (Capricorn1)Commented:
check PC-B A2007 , refer to the link posted above (verify SP installed)
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This could also be a reference issue. Once you find out what "not working" really means, let us know and we can see what can be done.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 in addition to references, Service Pack level might also be an issue.  really hard to say.

JimD.
0
 
Patrick O'DeaAuthor Commented:
Thanks again for all advice.

I will be talking directly to customer in about 12 hours (Thur 9am GMT) and will see what further info I can obtain.

Good nighT!
0
 
Patrick O'DeaAuthor Commented:
Thanks all,

It transpires that the user made a error - so a false alarm!

Nonetheless, I gained knowledge from you contributions and links.

THanks again!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now