Converting simplest database from A2010 to A2007
See attached.
Database "Service2007" has one form and one table with one field !!
I created on my PC with A2010.
I then emailed it to PC with A2007.
PC with A2007 does "not recognise format".
Also, on A2007 PC , I created a new blank database and tried to import from "Service2007" but still unrecognised.
I accept that there are differences between A2007 and A2010 but I have used the simplest of all functionality that would have worked 15 years ago!
What am I doing wrong?
Service2007.accdb
Database "Service2007" has one form and one table with one field !!
I created on my PC with A2010.
I then emailed it to PC with A2007.
PC with A2007 does "not recognise format".
Also, on A2007 PC , I created a new blank database and tried to import from "Service2007" but still unrecognised.
I accept that there are differences between A2007 and A2010 but I have used the simplest of all functionality that would have worked 15 years ago!
What am I doing wrong?
Service2007.accdb
jppinto
Access 2007 won't recognize Access 2010 databases because is from a higher version!
don't have 2010 on my current PC. Is there a SaveAs 2007 option in the File Save menu?
ASKER
fyed,
On A2010 there is no explicit option to "Save As" A2007.
See attached which shows an option for A2003 but NOT A2007.
A2010SaveAs.JPG
On A2010 there is no explicit option to "Save As" A2007.
See attached which shows an option for A2003 but NOT A2007.
A2010SaveAs.JPG
ASKER
Actually fyed,
I am wondering if you can open the database that I attached in the original post.??
If you can then it would indicate a problem with my A2007 installation (on my second PC).
Thanks,
I am wondering if you can open the database that I attached in the original post.??
If you can then it would indicate a problem with my A2007 installation (on my second PC).
Thanks,
makes sense, since they both supposedly use the accdb format.
Have you tried creating a new 2007 database in 2007, and then importing all the objects from the 2010 db into the 2007 version?
Have you tried creating a new 2007 database in 2007, and then importing all the objects from the 2010 db into the 2007 version?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, so now I have tried "SaveAs" in my A2010 to A2003.
(Bear in mind I just created this databse and it has only one field!!)
See attached error.
Any thoughts?
A2003SortOrder.JPG
(Bear in mind I just created this databse and it has only one field!!)
See attached error.
Any thoughts?
A2003SortOrder.JPG
There are incompatibilities including that one, which will prevent your 2010 database from opening in earlier verisions of access.
Take a look at this for specific issues and resolutions:
http://msdn.microsoft.com/en-us/office/cc907897.aspx
Take a look at this for specific issues and resolutions:
http://msdn.microsoft.com/en-us/office/cc907897.aspx
ASKER
Hi again all,
I have had a few other problems with database corruption in recent days. This may well not be a related issue!
However, I had assumed that a "database" was corrupted. So therefore if I create a brand new database then there could not possibly be any corruption in it?? Is this assumption correct?
I have had a few other problems with database corruption in recent days. This may well not be a related issue!
However, I had assumed that a "database" was corrupted. So therefore if I create a brand new database then there could not possibly be any corruption in it?? Is this assumption correct?
Uhm, I am sorry, I was partially wrong assuming that Access 2007 e 2010 have the same format.
It depends on which 2007 service pack you have.
See here for better description
http://msdn.microsoft.com/en-us/office/cc907897.aspx
It depends on which 2007 service pack you have.
See here for better description
http://msdn.microsoft.com/en-us/office/cc907897.aspx
if there is no way you can create an application using version A2007,
* in A2010, create a .MDB file
- then, open in A2007
* in A2010, create a .MDB file
- then, open in A2007
ASKER
Thanks I am sure we are making progress.
I have looked at the link
http://msdn.microsoft.com/en-us/office/cc907897.aspx
It makes sense to a certain degree.
However, the "Sort Order" options that I am presented with include "General , General Legacy and then about 20 or 30 non English headings".
Neither "General" or "General Legacy" allow me to "SaveAs" A2003. I do not want to choose a foreign language "SortOrder".
Any thoughts?
I have looked at the link
http://msdn.microsoft.com/en-us/office/cc907897.aspx
It makes sense to a certain degree.
However, the "Sort Order" options that I am presented with include "General , General Legacy and then about 20 or 30 non English headings".
Neither "General" or "General Legacy" allow me to "SaveAs" A2003. I do not want to choose a foreign language "SortOrder".
Any thoughts?
Try the General Legacy.
I believe "Legacy" means something along the lines of 'old'
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks All,
I will close this call.
There is definately something odd happening but I have a workaround.
In summary, I could NOT save a A2010 as A2007 - there appeared to be no suitable "SaveAs" option in A2010. When I tried to "SaveAs" A2003 I got errors on the "Sort Order" (for both "General" and "General Legacy").
My solution was to create a new database as A2003 (i.e. not via "SaveAs") using A2010. I then imported data into the the A2003 database.
I was not using any functionality that required greater than 2003.
Far from perfect but it works.
I will close this call.
There is definately something odd happening but I have a workaround.
In summary, I could NOT save a A2010 as A2007 - there appeared to be no suitable "SaveAs" option in A2010. When I tried to "SaveAs" A2003 I got errors on the "Sort Order" (for both "General" and "General Legacy").
My solution was to create a new database as A2003 (i.e. not via "SaveAs") using A2010. I then imported data into the the A2003 database.
I was not using any functionality that required greater than 2003.
Far from perfect but it works.
Sorry that none of the ideas mentioned resolved your issue.
As a side question, which version 32 bit or x64 of Office 2010 are you using?
As a side question, which version 32 bit or x64 of Office 2010 are you using?
Just double-checking...
Did you try General Legacy sort order, and then simply oening the DB in 2007 (without the save as to 2003)?
Did you try General Legacy sort order, and then simply oening the DB in 2007 (without the save as to 2003)?
ASKER
fyed , 32 bit
mbizup, I tried the "General Legacy" with an ordinary save - However, it failed.
In truth, I do not fully understand what is going on..... happy to have resolved the issue via a workaround tho'.
mbizup, I tried the "General Legacy" with an ordinary save - However, it failed.
In truth, I do not fully understand what is going on..... happy to have resolved the issue via a workaround tho'.