<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Opening MS Access db from VB</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Team,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">It would seem pretty simple but my head just cant get it....</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is the code I used which opens access but not the the actual db.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Dim mydb as database</FONT>
<BR><FONT SIZE=2 FACE="Arial">Dim str1 as string</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">str1 = "File location to the mdb"</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBEngine.DefaultUser = "Admin"</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBEngine.DefaultPassword = " "</FONT>
<BR><FONT SIZE=2 FACE="Arial">set mydb = DBEngine.Opendatabase(str1)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I know I am missing something but cant work out what....Any help is appreciated.</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>