[AccessD] Opening MS Access db from VB

Team,

I am trying to open an access DB from within a VB app. All i want to acheive
is to have the db open in its own right.

It would seem pretty simple but my head just cant get it....

Here is the code I used which opens access but not the the actual db.

Dim mydb as database
Dim str1 as string

str1 = "File location to the mdb"
DBEngine.DefaultUser = "Admin"
DBEngine.DefaultPassword = " "
set mydb = DBEngine.Opendatabase(str1)

I know I am missing something but cant work out what....Any help is
appreciated.






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031014/8310f22a/attachment.html>