Changing Database Location at Runtime Using Crystal Reports

[Guest_imported]

hey fellas... i have the latest version of crystal reports with VB 6.0... i need to change the database file path at runtime to account for different installation directories. different users will use different directories. any ideas on how to do this? thanks

 

[jfrost10]

Hey shad00,

What you could do is, when your program loads, create a file system object and use its FileExists method (might be called something different, but check the help. It gives a pretty good detailed description). All you'd have to do is check to see if the db file exists in each of the possible spots, and when it finds it, assign that path to the global path.

Hope this helps,

Jack