Using Access 97 Password to open a database in VB6

Thanx too much, It works fine with Access 97 and 2000
"Mohammed dwaikat" <dwikatmo.RemoveThis@yahoo.com> wrote in message
news:eigobVZuDHA.2248@TK2MSFTNGP09.phx.gbl...
 > Hi All
 > I am using DAO, in a VB6 project with Access97. is there anyway to set the
 > Access 97 database Password, and open the databse that is protected by a
 > password from VB ie using opendatabase, and also using data control, If I
 > set the password it cant't open the database .
 >
 >
 > Thank you
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Access 97 Password to open a database in VB6 

Hi,

I think what happens in your case is that your recordset was updated already
and your code tries to call Update or CancelUpdate method again, which is
not allowed after updates completed. Hard to say where it happens and only
way to find it out is to debug your code. It could be in case if you call
AddNew, updated values and moved pointer inside of the recordset into
another location. In this case ADO will automatically update recordset and
exit from the edit mode
"Santhana Gopalan S" <santhana_gopalan_s_NOSPAM.RemoveThis@yahoo.com>
??????:02c401c3b9ea$ce32fe00$a501280a@phx.gbl...
 > Hi,
 >
 > In the link below you can find various types of opening
 > the connection to an Access database.
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?</font" target="_blank">http://support.microsoft.com/default.aspx?</font</a>>
 > scid=http://support.microsoft.com:80/support/kb/articles/Q1
 > 91/7/54.ASP&NoWebContent=1
 >
 > Santhana Gopalan S
 >
  > >-----Original Message-----
  > >Hi All
  > >I am using DAO, in a VB6 project with Access97. is there
 > anyway to set the
  > >Access 97 database Password, and open the databse that is
 > protected by a
  > >password from VB ie using opendatabase, and also using
 > data control, If I
  > >set the password it cant't open the database .
  > >
  > >
  > >Thank you
  > >
  > >
  > >
  > >.
  > ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Access 97 Password to open a database in VB6 

you/ll need a couple of lines in your form_load event to pass the connection
properties to your data controls -
better still - why bother with data controls ? (unless you have 3rd party
controls that insist on them ?)

"MrSmith" <wz05770577 DeleteThis @21cn.com> wrote in message
news:eVCfmK$1DHA.2328@TK2MSFTNGP10.phx.gbl...
 > Hi,
 >
 > I think what happens in your case is that your recordset was updated
already
 > and your code tries to call Update or CancelUpdate method again, which is
 > not allowed after updates completed. Hard to say where it happens and only
 > way to find it out is to debug your code. It could be in case if you call
 > AddNew, updated values and moved pointer inside of the recordset into
 > another location. In this case ADO will automatically update recordset and
 > exit from the edit mode
 > "Santhana Gopalan S" <santhana_gopalan_s_NOSPAM DeleteThis @yahoo.com>
 > ??????:02c401c3b9ea$ce32fe00$a501280a@phx.gbl...
  > > Hi,
  > >
  > > In the link below you can find various types of opening
  > > the connection to an Access database.
  > >
<font color=green>  > > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?</font" target="_blank">http://support.microsoft.com/default.aspx?</font</a>>
  > > scid=http://support.microsoft.com:80/support/kb/articles/Q1
  > > 91/7/54.ASP&NoWebContent=1
  > >
  > > Santhana Gopalan S
  > >
   > > >-----Original Message-----
   > > >Hi All
   > > >I am using DAO, in a VB6 project with Access97. is there
  > > anyway to set the
   > > >Access 97 database Password, and open the databse that is
  > > protected by a
   > > >password from VB ie using opendatabase, and also using
  > > data control, If I
   > > >set the password it cant't open the database .
   > > >
   > > >
   > > >Thank you
   > > >
   > > >
   > > >
   > > >.
   > > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Access 97 Password to open a database in VB6