>I have a form that is used for each users timesheet entries. The problem that I have though is that each user has their own DBF. (i.e. \DATA\THSHT\%user name%\TMSHT.DBF). Each user can only access their own TMSHT.DBF. My question is this. I don't know which DBF needs to be opened until the form is run so what is the best way to handle this in the DE of the form?
What if you used an empty temp table? You could even include it in your app to make sure it's always there. Then once you know who the user is, you can close the table, set the property and open the correct one. Will that work?
HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...