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

Re: Qs on DAO 3.6

Path	csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	ralph <nt_consulting64@yahoo.net>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Qs on DAO 3.6
Date	Wed, 28 Mar 2012 13:24:00 -0500
Organization	Aioe.org NNTP Server
Lines	50
Message-ID	<lsj6n7l6d9gras7v7olves9s5m523drb45@4ax.com> (permalink)
References	<Yojcr.287$e07.70@fx16.am4> <kcm3n717l2ppuvcgahof5qjvfs5ia29cg8@4ax.com> <_8rcr.2237$Re2.395@fx08.am4> <jkvcfn$8c7$1@dont-email.me>
NNTP-Posting-Host	QPUqO38R4VH3RL6SKQdX5g.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
X-Notice	Filtered by postfilter v. 0.8.2
X-Newsreader	Forte Agent 6.00/32.1186
Xref	csiph.com comp.lang.basic.visual.misc:1027

Show key headers only | View raw

On Wed, 28 Mar 2012 17:58:48 +0200, Helmut_Meukel
<Helmut_Meukel@bn-hof.invalid> wrote:

>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.
>

I too suspect the OP is using ADO in his VB6 App as the primary data
access library and is only using DAO for its DDL capabilities.

What he is apparently attempting to find is an Access-defined property
which will invoke a custom message whenever the database is opened. I
dont' know of any method outside of wrapping the mdb in an Access
Project - but then I'm certainly no MS Access expert. Sounds like a
useful feature however. I'd be interested too.

You are correct in warning your customer about possible problems with
MS Access clients and forward-compatiblity, but this will have less
impact on DAO 3.6. DAO 3.6 can create, read, and write all Jet formats
from Jet 1.0 to Jet 4.0 through the facilities of translator dlls.

-ralph

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