For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > May 2005 > Access Database Question?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Access Database Question?
gmarr6

2005-05-19, 8:59 pm

Is there a way to set the Database path at runtime?

I created a report using the Report Expert, And it works great. The only
problem is that the report will only work if the Database is at it original
path.

Is there a way to set the path at runtime? What i would realy like is to use
Application.StartupPath, but I can't figure out how to do it.

Thanks for the help
Gord


Dale

2005-05-19, 8:59 pm

Hi, are you running a crystal report from a VB program?

Dim report As CRAXDRT.report

....

report.Database.Tables(1).Location = "c:\somepath\mydb.mdb"

> Is there a way to set the Database path at runtime?
>
> I created a report using the Report Expert, And it works great. The only
> problem is that the report will only work if the Database is at it original
> path.
>
> Is there a way to set the path at runtime? What i would realy like is to use
> Application.StartupPath, but I can't figure out how to do it.
>
> Thanks for the help
> Gord
>
>

gmarr6

2005-05-20, 4:01 pm

Thanks for pointing me in the right direction. Works geat.

"Dale" <dale0610@hotmail.com> wrote in message
news:OH9MUhLXFHA.2540@tk2msftngp13.phx.gbl...[color=darkred]
> Hi, are you running a crystal report from a VB program?
>
> Dim report As CRAXDRT.report
>
> ...
>
> report.Database.Tables(1).Location = "c:\somepath\mydb.mdb"
>


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com