Access Security

[RichardJ]

Quick one this, and probably easy as well!!! But we can't remember how to do this here!!!

I'm using Excel 97 and want to connect to an Access 97 database to retrieve some data. The database uses access security.
Were connecting to the database using DAO... First creating a workspace object and then using the opendatabase command. But as we are not referencing the workgroup file its not letting us in.
So the question is how do you connect to a workgroup using DAO.


Cheers

 

[RichardJ]

Ok I found out how to do it...

I noticed that a few people had been stuck on this without resolve so.......

dao.dbengine.SystemDB = "c:\Secu.mdw"

Then use the createworkspace command with appropriate username and password, then use OpenDatabase as normal.


Cheers