Hi There

Unfortunately I am still working with VS 4.6 but cannot afford to upgrade just yet.  What I want to do is programatically use a report whose database file name has been changed.  I  know it can be done through CR directly, but I need to make the same report transparent to a database file that has different names.  The data structure, fields, tables ect remain unchanged.

I am beginning to believe that my version just wont allow this to be done.  However, I was wondering if anyone who is using a later version could post a short basic code line as an example so I can determine if I can program any work-arounds for my earlier version.

Thanks

Hi Bruce,
    I'm not sure if this can be done.  I did think of another possibility, which I'm not sure will work either.  If you base your report on an a DSN, you can change the database to which the DSN points, without having to change your report.  I think that you can even do this through code.  This may not be an acceptable solution, but I hope it's of some help.

Bob Holmes

  Hi There

  Unfortunately I am still working with VS 4.6 but cannot afford to upgrade just yet.  What I want to do is programatically use a report whose database file name has been changed.  I  know it can be done through CR directly, but I need to make the same report transparent to a database file that has different names.  The data structure, fields, tables ect remain unchanged.

  I am beginning to believe that my version just wont allow this to be done.  However, I was wondering if anyone who is using a later version could post a short basic code line as an example so I can determine if I can program any work-arounds for my earlier version.

  Thanks

Thanks again.