Groups > comp.lang.basic.visual.misc > #1026

Re: Qs on DAO 3.6

From	Helmut_Meukel <Helmut_Meukel@bn-hof.invalid>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Qs on DAO 3.6
Date	2012-03-28 17:58 +0200
Organization	HM - Soft Hof
Message-ID	<jkvcfn$8c7$1@dont-email.me> (permalink)
References	<Yojcr.287$e07.70@fx16.am4> <kcm3n717l2ppuvcgahof5qjvfs5ia29cg8@4ax.com> <_8rcr.2237$Re2.395@fx08.am4>

Show all headers | View raw

Ivar schrieb:
> ralph wrote:
>>I'm guessing that what you want to do is if your VB6 application
>>currently has the file open you want a message box to appear when a
>>user opens it using MS Access.
>
> Nope, The VB6 app uses only disconnected recordsets, so not connected to mdb 
> file.

That's impossible with DAO.
If you really are using disconnected recordsets, then you are using ADO.

> If someone opens the mdb file using Access then Access shows a msgbox saying 
> something like "it's your database, break it if you want to"
> Easy to do using Access, Clueless if it's even possible using DAO when 
> creating the mdb file.

Which Access version?
This sounds like the Messagebox you get in Access, if you open an older
version of a database file. Access asks to upgrade to the current
version, but warns it will render it unusable with older versions of
Access (or DAO).
I have some db files creauted with Access 97, but the customer uses
mostly Access 2000. My programs are using DAO 3.6, so an upgrade with
Access 2000 would be no problem, but he has an older PC with only
Access 97. I warned him he must install Access 2000 on this PC if one
user allows his Access to upgrade the db file.

I never tested it with higher versions of Access, but I guess it may
even make it unusable with VB6/DAO3.6.

Helmut.

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Qs on DAO 3.6 "Ivar" <ivar.ekstromer000@ntlworld.com> - 2012-03-27 14:38 +0100
  Re: Qs on DAO 3.6 "David Youngblood" <dwy@flash.net> - 2012-03-27 10:11 -0500
    Re: Qs on DAO 3.6 "Ivar" <ivar.ekstromer000@ntlworld.com> - 2012-03-27 19:14 +0100
  Re: Qs on DAO 3.6 ralph <nt_consulting64@yahoo.net> - 2012-03-27 11:06 -0500
    Re: Qs on DAO 3.6 "Ivar" <ivar.ekstromer000@ntlworld.com> - 2012-03-27 23:27 +0100
      Re: Qs on DAO 3.6 ralph <nt_consulting64@yahoo.net> - 2012-03-27 22:08 -0500
      Re: Qs on DAO 3.6 Helmut_Meukel <Helmut_Meukel@bn-hof.invalid> - 2012-03-28 17:58 +0200
        Re: Qs on DAO 3.6 ralph <nt_consulting64@yahoo.net> - 2012-03-28 13:24 -0500
          Re: Qs on DAO 3.6 "Clive Lumb" <clumb2@gratui_en_anglais.fr.invalid> - 2012-03-29 09:29 +0200
  Re: Qs on DAO 3.6 Wolfgang Enzinger <we_usenet@nurfuerspam.de> - 2012-03-28 12:04 +0200

csiph-web