Re: Connection to Access Database Problem

Barry Wood wrote:
Michael,

UserName & Password are OK as I (currently) have to enter them when I open the mdb in Access. I didn't give the actual username/password ;-). The error I get occurs when I hit the Test button in the Connection Editor - at this stage I haven't been asked to enter a username/password.

Originally the mdb didn't have any userid/password set (which is how I had the editor parameters set to, with LoginPrompt set to False). When I kept getting the error which says suff about the workgroup information file missing I created this file. Part of that process was in providing a username and password. By choice I don't want a userid/password, especially whilst I'm developing/testing.

I've just deleted the above connection and tried setting up a new one. Without changing anything (taking all the defaults) & pressing Test I get the same error instantly. Like it isn't even looking at the database. Then I pointed it to the mdb file & left other parms as they were (login set to false, UserName=myuser, UserPassword=mypass & pressed Test - same error. When I remove the username/password I get a BDP exception error.

Just entered Admin as username & no password, as you suggest, & get different error messgae. I've subsequently pointed the Database to another copy of the mdb in an entirely different folder and I get a succesfull Test connection! How weird is that! It's the exact same database - one copy is in the wwwroot folder the project files are in (doesn't work) the other in another folder and it does work.

Check the permissions on the folders and on the mdb?
Mike
.