Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

Mass Convert Access 97 to Access 2007

I have roughly 200 databases I wish to mass upgrade from 97 to 2007.  I found a link that converts from 2003 / xp to 2007; however, it says my 97 databases are an unrecognized format.

http://www.labnol.org/software/bulk-convert-office-documents-in-2007-format/4291/

That is the link with the steps.

Is there a direct conversion from 97 to 2007?  If not, then is there a way to mass convert from 97 to 2003?
0
dzirkelb
Asked:
dzirkelb
  • 5
  • 5
  • 2
  • +1
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I never heard of or seen a 'mass' way to convert databases.

Not positive if A2007 will recognize A97 or not.  You may need to go A97>A2003>A2007.  However, I would skip the now 4.5 year A2007 and move directly to O2010.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Regarding the linking issue from the other Q ... you could ... probably use this code:

http://www.mvps.org/access/tables/tbl0009.htm

to help automate the process.  However, this code is intended to already be in an MDB ... and allow the user to relink to a different location of a back end mdb.

mx
0
 
dzirkelbAuthor Commented:
I have something similar in place for our sql tables; however, the access tables are all random per database, one might have 10, one might have 50, and all do not need to have the same linked tables.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
re that link you posted ... I would FULLY test that on a single mdb(s) to be absolutely sure it's going to convert an Access database.  A Word doc is one thing, an Access mdb is entirely another.

mx
0
 
dzirkelbAuthor Commented:
That link is a mute point right now as it does not recognize access 97, only 2003 and above.  I am looking for somethig similar to that post.

If there isn't anything out there, then it isn't the end of the world.  I just wanted to save a couple hours.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I will have to check at home tonight ... and see if A2010 will recognize an A97 mdb.

"a couple of hours" ...at LEAST :-)

mx
0
 
dzirkelbAuthor Commented:
The couple hours is about right as I have done about 40 hours of preliminary work already, so it is jus converting them now and should be done (after re-linking some random tables, but most are in sql now)
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
97 should convert directly to 2007, however there are some known issues:

http://allenbrowne.com/ser-48.html
0
 
dzirkelbAuthor Commented:
Converting is not the issue...I am looking for a mass conversion so I do not have to do them individually.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You asked if 97 could be converted directly. The link I provided seems to suggest it can be.

As to doing that en-masse - that's not what I intended to address.

Have you reviewed the OMPM documents: http://technet.microsoft.com/en-us/library/cc179179(office.12).aspx

There are quite a few requirements in order to use this, and the error you're getting would indicate that you don't have the correct version(s) of DAO or Jet on your machine.

0
 
Jeffrey CoachmanMIS LiasonCommented:
If you read that link,
http://www.labnol.org/software/bulk-convert-office-documents-in-2007-format/4291/
...it does not explicitly say that it will convert Access databases:
<Say you got tons of Excel sheets, PowerPoint presentations and Word documents on your computer...>
...This may be the reason for your original Error.
...so this may be a moot point...


200 Database eh?
I can see why you might want something like this...
;-)

I don't know if I could trust a Bulk update from 97-->2007 in any event.
So many things have changed, not only in Access, But in Office and Windows as well.
You need look no further than the Allen Browne link to see just how many issues there may be.


But to address your question directly...
   I do not know of any utility that will Bulk convert Access database from Access 97 to Access 2007

JeffCoachman
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Actually (supposedly):
                                                                       vvvvvvvvvvvvvvv
"This utility works with Word (doc to docx), Access databases, PowerPoint (ppt to pptx), Visio diagrams, Excel (xls to xlsx) and Microsoft Project files. The conversion may however fail for password protected documents."


But I certainly agree with "I don't know if I could trust a Bulk update from 97-->2007 in any event."

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
:-(
I only read the first few line of the link...
0
 
dzirkelbAuthor Commented:
Thanks guys, I just did each one manually over the past weekend.  It took some time, but at least it is done :)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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