"Operation not supported for MS Access 1.x database"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to extract the data from an application named "PumpTrack"
(database for tracking breast pump rentals), and it's apparently an Access
1.x databse under the hood. I find a file in the Programs folder named
Rentals.mdb, where I suspect the data tables are to be found, but I cannot
open this database using any version of Access that I currently have (2000,
2002 or 2003). When trying to open the file, I get the message,

"The operation is not supported for Microsoft Office Access 1.x
databases."

I am building an Access db to replace this outdated application (it appears
to date back to 1992), and just want to extract the data from the old
database. There is no Export feature in the actual PumpTrack "application"
that I can find.

Any advice on trying to open this older Access db? Do I need to try and
find and install Access 1.x in order to open it? Any direction would be
appreciated.

TIA,
Steve Vincent
(e-mail address removed)
 
You don't need to find Access 1.0.

Access 2.0 and A97 would work also :~)

But since you only want the data, you don't need to open the file
in Access at all.

First try to see if you can just import or link the tables. (I don't
have a 1.0 database to try)

If you can't do that, try compacting the database to a new
version first:

dim dbe
set dbe = createobject("dbengine.35")
dbe.CompactDatabase "olddb","newdb",,32

I'm not sure if you need all the parameters on that line. If you do,
dblangGeneral is
";LANGID=0x0409;CP=1252;COUNTRY=0"

(david)
 
Back
Top