Hallo

I have a problem that I can't seem to solve. My application is running from a server. Because of multi-users, we do not hard code the directory in which the database is situated, because every user may have a different mapped drive to the server. The user, by using the commondialog box, import files from C-drive, other computers over the lan ect. Everytime the imported the first file, the directories of all my Adodc ect. point to the drive where the file is. In other words, my databse is lost by the application. Can you prevent this from happening? If so, how? (without hard coding the directory)

I would appreciate any help received.

Thank you