connectiing to a secured MS Access DB from VB.NET

Similar Threads:

1.Shell function - accessing an Access secure db (.MDW file)

Hi - Does anyone know the correct syntax for the shell function.  This is my problem.. my Access db has a workgroup (.MDW) file associated with it and what I am trying to do is run my Access macro, through VB5, that runs a query and exports the results into an Excel spreadsheet.  The following statement does work correctly (but it is accessing an Access db that has NO .MDW file associated with it), I need to incorporate the username and password:
Retval = Shell("c:\Program Files\Microsoft Office\Office\Msaccess.exe " & 
    "c:\salesrpt\grp\roster\marssrs.mdb /x mcrDownloadRosterWeb", 0

Maybe this will help some: (This is a sample of my code, that usually use to access the secure db, note:  the username is MarsSRS and the password is phone1phase

swrkgrpfile = Mid("C:\Salesrpt\Grp\Roster\marssrs.mdb", 1, Len("C:\Salesrpt\Grp\Roster\marssrs.mdb") - 1) + "w
    
DBEngine.SystemDB = swrkgrpfil
 
Set wrkConnect = CreateWorkspace("MarsSRS" + CStr(Time), "MarsSRS", 
                   "phone1phase", dbUseJet

Set dbRoster = OpenDatabase("C:\Salesrpt\Grp\Roster\marssrs.mdb"

HOPEFULLY SOMEONE CAN HELP ME OUT HERE.. THANKS!

2.Opening/Linking to (user-level) secured db from unsecured db in VB

I have looked and looked and from what I have seen, there is no way to open 
or link to a (user-level) secured db from an unsecured one usign VBA.  
OpenDatabase seems to have provision to allow a way through database-level 
password protection, but not user-level.
I am writing a db to perform as many steps as I can to convert an MSAccess 
2000 db into an Oracle one with a number of structure changes, so I want to 
open or link (attach) to the tables in the production db, so I can run the 
conversion queries and produce Oracle scripts ready to run on the Unix Oracle 
server.
Any suggestions?

3.Example code to create an MS Access db locally using VB.Net 2003

Hi, 

I am a beginner looking for example code on how to create an access
database for a local application. I need to create the database when
the app is first installed. I can do it with SQL 2000 but I am not
sure how to do create a db, tables and fields as a local mdb. Any help
or pointers to where I can find example code on this much appreciated.

Thanks
John

4.Deploying VB .NET application WITH MS Access db

5.Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB

Hello,
	when I execute the code below I get the usual access message:

SECURITY WARNING----------------------------------

Opening "<filepath & name.mdb>"

The file may not be safe if it contains code that was intended
to harm your computer.
Do you want to cancel the operation?

CANCEL			OPEN		MORE INFO

---------------------------------------------------

Private Sub OpenDB(ByVal strMDBFullPath as string)

Dim appDatabase As Access.Application

appDatabase = New Access.Application()
appDatabase.OpenCurrentDatabase(p_strMDBFullPath, True)

...

End Sub

How can I detect if the user presses the CANCEl button? With the code
above if the user presses the CANCEl button the code throws an exception
on the line "appDatabase.OpenCurrentDatabase(p_strMDBFullPath, True)".

The code is VB .net and the database is 2003 but could be 97, 2000 etc.

Thanks in advance

Paul M.