Opening Access 97 mdb's with Access 2003 OK?
by don.fleming » Fri, 14 Dec 2007 04:38:45 GMT
We have a tool built for determing which Access version an mdb is that
works nicely. Problem is, hundreds of PC's here are getting reimaged
without it(!)
Since I've been unable to solve that problem, am quite interested in
this. Can an Access 97 be harmed by opening it with the Access 2003
app as a User of the mdb.? We have LOTS of this happening here and
I'm starting to research if/how much of a problem this is. If the
Users have no need to change objects, (Tbls/Qrys/Forms etc..), perhaps
its OK for them to View Tbls/Qrys/Macros results, even change table
data with the v2003 app.
I have converted LOTS of the mdb's to v2003, but hundreds more v97's
are out there my scans are showing.
Thx of course for info
Don
Re: Opening Access 97 mdb's with Access 2003 OK?
by Tom van Stiphout » Fri, 14 Dec 2007 11:27:21 GMT
We have no evidence reported in this newsgroup or anywhere else I am
familiar with that would indicate this is a problem. Backward
compatibility in Access is quite good.
-Tom.
Similar Threads:
1.Access 97 .mdb won't open in access 2003
I have an access 97 database that I am attempting to open in access
2003. It sez: "unrecognized database format'C:documents and
settings\My Name\desktop\tilium roster.mdb'.
I click help and it gives it as error 3343 with suggested solutions.
I don't have access 97 any longer to look at it for it's sorting order
or whether there was anything like a *commit* in/on it. I don't even
know what those terms refer to. It is a Very simply database with
nothing hidden nor scripted.
Is there any way to see the info so I cam at least salvage my info
I thought .mdb _was_ the correct format??
Hope someone can walk me thru this.
Thanks,
Barb
2.mdb file could not open after converson 97-2003 in Access 2003 run
Hi There,
I have a problem to open mdb files in Access 2003 runtime version, Those
files are open successfully in Access 2003 fully installed from CD. when I
open thse files it could not open I check all security level of macros and
trusted publisher all are fine. We have around 30 mdb files and 6 databases
are successfully open in Runtime version any idea there is problems with
runtime version or conversion problem.
Thanks
Wasi
3.have installed office pro 2003 cannot open access 97 mdb
Details
Product: Office
Event ID: 10013
Source: OfficeErrorMessages
Version: 11.0
Message: Links to additional information about the error message you saw are
available below.
4.Access 97 MDE to Access 2003 MDB
I have been asked if there is a way to take an 8 year old database
application written in Microsoft Office 97 Professional Access *.mdb system
and complied into a Microsoft Access *.mde for the user to convert this
application into Microsoft Office 2003 Professional Access *.mdb and mde.
The problem is this! I only have the namedtable.mde to work with. The
corresponding namedtable.mdb that exists is not a synchronized version to the
*.mde file. Is there a way to reverse engineer a Access 97.mde file into a
convertable 2003.mdb file to perform maintenance on this application? If
so, what tools do I need to convert it, the original source for this working
*.mde does not exist.....
Thanks,
Robert
--
Robert Nusz @ DPS
5.migrating mdb(s) from Access 97 to Access 2003
I am migrating mdb(s) from Access 97 to Access 2003.
I have never used MS Access before. (I'm PowerBuider developer.)
I understand that I have to install MS Access first (of course!) then
MS Access 03 -> Tools -> Convert database ->Access 2002-2003 file
format.
What else do I need to know and what else do I need to check?
The front end that is working with Access databases developed with
VB6.
6. Unable to open Access 95 mdb in Access 97
7. access xp cant open access 97 mdb with security
8. Can't open my Access files after conversion from Access 97 to Access 2003