Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Converting Access 2003 to 1997 using 2007.


  • Please log in to reply

#1
Welshhobo

Welshhobo

    Member

  • Member
  • PipPip
  • 29 posts
In my school the were using VB6 to program a game in. VB6 only likes to data link with access 1997.
If a version of access is set to 1997, the only way to edit the database (except for putting new records in) is to use the 1997 version of access.
My school uses access 2003, this means we have to make our database in 2003 then use the converter built into 2003 to get our 1997 version of our database so it is compatible with VB6.
I however only have 2007 at home, so i was wondering if it is possible to convert my 2003 database to 1997 format without having to get a copy of 2003 just to use the built-in converter.

Thanks in advance :)
  • 0

Advertisements


#2
Neil Jones

Neil Jones

    Member 5k

  • Member
  • PipPipPipPipPipPipPipPip
  • 8,476 posts

To convert an Access 2007 database to a file format that is compatible with Access 97 or earlier, you must first use Access 2007 to convert the database to the Access 2000 file format or the Access 2002 - 2003 file format. Then you use an earlier version of Access to convert the database to the format that you want. For example, by using the Convert Database command in Access 2003, you can convert an Access 2000 database or an Access 2002 - 2003 database to the Access 97 file format.


You should also read the rest of the page that the quote comes from as there are caveats. But the bottom line is, you can't do it from 2007.
http://office.micros...2308221033.aspx
  • 0

#3
Welshhobo

Welshhobo

    Member

  • Topic Starter
  • Member
  • PipPip
  • 29 posts
Bah, so ill just have to get Access 2003 ?

Can you have both 2003 and 2007 on a computer simultaneously?
  • 0

#4
Neil Jones

Neil Jones

    Member 5k

  • Member
  • PipPipPipPipPipPipPipPip
  • 8,476 posts
Yes.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP