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

Re: Qs on DAO 3.6

Path	csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	Helmut_Meukel <Helmut_Meukel@bn-hof.invalid>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Qs on DAO 3.6
Date	Wed, 28 Mar 2012 17:58:48 +0200
Organization	HM - Soft Hof
Lines	34
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>
Reply-To	NoSpaml@NoProvider.invalid
Mime-Version	1.0
Content-Type	text/plain; charset="iso-8859-15"
Content-Transfer-Encoding	8bit
Injection-Date	Wed, 28 Mar 2012 15:58:47 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="koTVuPu75vM2yMMRwfLDcQ"; logging-data="8583"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19TKwNA4ZC37BCHp46xfiiSUBaFfOFmlac="
X-Newsreader	MesNews/1.08.03.00-de
Cancel-Lock	sha1:dW9oVZvGeKPKk4z9OhhMdaCZD80=
Xref	csiph.com comp.lang.basic.visual.misc:1026

Show key headers only | 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