I'm having a couple of problems with a DataReport I'm trying to create. First, I'm designing a program, but it won't be run on the computer where I'm coding it. I'm using a DataEnvironment with the DataReport to bound all the controls to my Access 2002 database. The problem is when I deploy the program to the other computer. I get a "Failed getting Rowset(s) from current data source." I know this problem is stemming from the DataEnvironment's database path; the path is different in my computer than the other computer's path. My question is, is there any way (either in code or through the DataEnvironment) that I can solve this little problem?
Secondly, just wanted to know how can I display a DataReport using a password-protected Access 2002 Database? I've tried different ways, getting the same error message as the question above. Thanks in advance!