Programatically open Access DB with user level security
 

I have an Excel Add-in that now needs to open an Access database that has
user level security applied to it.

The only way I have been able to achieve this so far is using the VBA Shell
function, since by doing this I can pass the workgroup path and user
name/password to the DB.

Problem then of course is that I can't set a reference to the DB until
Access has started sufficiently to begin supporting OLE and the amount of
time this might take is indeterminate.

A very crude workaround I am using at the moment is to pause the Excel VBA
execution using Wait for a few seconds or so after calling the Shell
function, but even with this included, it still has a less than perfect
success rate.

Does anyone know how I can either pass workgroup and user parameters
thorough regular VBA such as OpenCurrentDatabase - or - monitor the process
handle of Access to see when it has fully initialised?

--
Regards - Peter

Programatically open Access DB with user level security
 

Are you opening the Database using the ADO method? The Ado method has
the following options

connection.Open ConnectionString, UserID, Password, Options


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184110

Microsoft Office Help

Programatically open Access DB with user level security
 

No I have typically always used DAO, or shell in this case, thanks for the
suggestion though I will try it.

--
Regards - Peter



"joel" wrote:


Are you opening the Database using the ADO method? The Ado method has
the following options

connection.Open ConnectionString, UserID, Password, Options


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184110

Microsoft Office Help

.