
excel sheet messes up my db path
Hello everyone,
I am hoping someone here had this happen to them, because I don't really
know where to start in telling you why it is happening.
I have a form that looks in an Excel sheet and grabs a list of names and
places them in a list box. However, when I try to set up a new event in my
database, it starts looking for my database in whatever folder the excel
sheet was in. I use relative paths for connecting to my database, and
somehow my connections seem to start using the path of the Excel sheet.
I can cheat and place all my excel sheets in the bin folder with my
database, but that's a pain in the butt.
Any help in how to debug this would be helpful too.
thanks for any help.
Jason