Opening Access 97 mdb's with Access 2003 OK?



  • 1. Report Help, break between details
    Chris: In design mode, if you right-click on the "Details" bar, it brings up a Properties dialog for the Details section. On the Format tab is a "Force New Page" option. Setting it to "After Section might do the trick. -Matt On Mon, 14 Jul 2003 20:30:03 GMT, "Chris Kettenbach" < XXXX@XXXXX.COM > wrote: >Greetings, >How do I get a report to page break between details? I put a page break ctl >in the details footer which works ok except the report generates an extra >blank page with the detail header info. I would like the details to stay on >one page and not to run an additional page. I can not figure out how to do >this. Seems like this would be easy. > >The desired effect is >Employee > date time1 time2 >(I want to page break here and start a new employee). I do not want to print >another page with the details header. Any ideas? Tia > >~ck >
  • 2. access linked forms
    I have a problem : I don't know how to link different forms. The data base I want to set is an evaluation sheet with points to mark from 1 to 4. ( displayed with option group). I made 3 forms which have the date, the name of the evaluator and 2 other information in common. But I am not able to link these 3 forms.
  • 3. overflow error in access 97
    in our information system, we have a function called mail ...... . where...... is a report that we want to mail. however, when we try to do that, gives an overflow error. please help. it's not only happening on this machine on others as well. how can i gewt past or over this. we have the function to view, and then print, and then fax, but it's obviously much easier to just mail the report. thanks in advance yanks
  • 4. How to programatically insert a new line in a text box?
    I have users select items in a multi select list box. As the items are selected, they appear in a large text box in the format Item 1, Item 2, Item 3, etc. separated by commas. This works fine but I'd like the text box to look more like a list of items and replace the comma separator with a hard return. I can't figure it out. What works great now is For Each varItem In ctl.ItemsSelected strAuthMethod = strAuthMethod & ", " & ctl.ItemData(varItem) Next varItem strLen = Len(strAuthMethod) strAuthMethod = Mid(strAuthMethod, 3, strLen - 2) Me.txtAuthMethod = strAuthMethod TIA!
  • 5. Email Attachment
    "Murray Carter" < XXXX@XXXXX.COM > wrote in message news:lZVPa.5927$ XXXX@XXXXX.COM ... > My Problem is: > Required to send a comma delimited file as an attachment. Using Outlook > Express > I can use {TransferText} to create the file from a query > would like to use some thing like {SendObject Action } to EMail it. > Have tried {SendObject Action } with the Query and .txt but no good > > -- > Murray Carter > > Search Google groups for SendMailWithOE

Opening Access 97 mdb's with Access 2003 OK?

Postby 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


Re: Opening Access 97 mdb's with Access 2003 OK?

Postby 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.


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.



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.



3.have installed office pro 2003 cannot open access 97 mdb

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.....


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

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

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

Return to MS ACCESS


Who is online

Users browsing this forum: No registered users and 15 guest