about .rpt file

You can't in Access.  I just may be a rich text file so open WordPad and browse for the file name from that application

What are you trying to achieve by opening the .RPT file? I am assuming this is a Crystal Reports report file. If you are trying to import the report structure then I doubt there will be a way, if you are trying to run the report then you can use the SHELL command and run Crystal Reports.
Cheers, Andrew

Do you have a copy of Crystal Reports?  If so you can open the reports in Access through Crystal components.

mlmcc

I just want to run it. How can I do that?

How can I use Crystal components?

OR ... maybe you can get the CR API separately from the full CR ... then tap in to the object model ?

mx

As stated earlier CR will probably have a command line option so you can use the SHELL command something like

SHELL "CR " & FileName

Cheers, Andrew

CR doesnt have a command line ability

mlmcc

Have we counted out the possibility that WordPad or Word may be able to view the rpt document?   Access can export a report as a rtf  or Save As, which can then be read by WordPad or Word.  

GRayl, If I can't open a report (which has .rpt extension) in Access, how can I export/save it as rtf?

I may need Crystal Report. I already requested our help desk to install CR in my machine. But, I am just thinking, is there any way I can open a .rpt extension file in ms word/excel/access?

I think we are beating a dead camel here.  I think we have exposed all the possibly ways you *might* do this.  Again, my best guess is you would at least need a CR API (if one exists) such that you could use some VBA code to tap into that and open the .RPT file.

mx

Seems you could open it in NotePad, WordPad or Word ... BUT ... probably not readable.

mx

If it's not readable, does it make any sense to open it? Anyways, I learned that I must need CR to open it. Access can't help me out.
Thanks guys for your wise answers. I'll split up points.

TextReport, your idea is also great!

"If it's not readable, does it make any sense to open it? "

Not really.  

I thought so especially the "useful features such as command line API "

I suppose what has not been established in this question is what you are expecting to do with it once you have opened it? The choices I can think of are

1. Print it or allow it to be read by a person
2. Grab the data and import into access
3. Create an Access report based on its design

Cheers, Andrew

Well, we actually have a general user (not IT guy) who generate crystal (just double click on it) report and using Access as database back-end. He doesn't have any idea how the reports are generated or where is it come from? All on a sudden, he started getting data anomally/missing in his report. I was assigned to fix it but I don't have crystal report in my machine. I have Access and tried to open it but couldn't be able to.
I'll get Crystal Report in my machine but it takes a while.

Is it clear now

Good To Go :-)

mx

I took DatabaseMX and TextReport's suggestion, mlmcc also helped me out. Thanks everybody!!