I cannot understand why the Connection I've set up in a Database Container keeps prompting for the MS ACCESS MDB file when I have already defined it in the connection and also in the ODBC DSN File. Any ideas? Why the continual dialog box that says SELECT DATABASE?
I am using the part of the CONNECTION DESIGNER where you select the first choice, i.e., Datasource, User ID, password. I then select "MS ACCESS Database" in the drop down box in the designer. I put in the MDB file name. I have put it in without its file name extension and also with it (.MDB)
So, it just keeps on prompting for the MDB file. WHY???