Re: Adox Views in Access97

sosoft wrote:
Hi,

I'm using VB6 with ADO/ADOX 2.8 and Access97 Databases.
i create any views with Adox in runtime and use they in
Ado.recordsets with the same connection.
existing views will be deleted and new created.
in debugmode works all without problems
in release i get time by time errors. "view ... alredy exists" or
"view does not exists" (but in database is all korrekt)

what can i do?

I don't understand why you're dropping and recreating views. You may as well
just be using ad hoc queries.
Are you sure you couldn't be using parameterized saved queries to avoid this
overhead?
Provide a short example of how you are using these views so we can offer
suggestions. Views are intended to be long-lasting, if not permanent,
objects in a database. They are intended to encapsulate sql that is re-used.

Having never attempted to do what you are doing, I am at a loss to
understand the problem you are running into. It sounds as if the view is
failing to be dropped when you intend it to be. You may be running into the
delayed-write optimization used by Jet:

http://support.microsoft.com/kb/200300
http://support.microsoft.com/?kbid=240317

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Unknown Maiden Name [WAS how-to ruin a perfectly good FGS]
    ... through at the beginning of my database, ... or display your information in the fields you intended for them. ... the names in a manner you didn't intend and the meaning has become ... If my data is on the Internet and people don't understand it, ...
    (soc.genealogy.methods)
  • Re: Unknown Maiden Name [WAS how-to ruin a perfectly good FGS]
    ... on deaf ears. ... through at the beginning of my database, ... or display your information in the fields you intended for them. ... the names in a manner you didn't intend and the meaning has become ...
    (soc.genealogy.methods)
  • Re: Game database dilemma!
    ... database, and generally, I don't include dupes as I don't intend keeping ... I do, however, keep different versions or regions of the same games (e.g ... So, I *do* intend keeping both copies of AC, but they're the same region ...
    (uk.games.video.misc)
  • Re: How to fix a database that I dint design?
    ... don't intend to be unkind, or demean you, hon, because there's never shame ... built by someone else can test the skills of even an experienced developer - ... it's not a place to start "dabbling", especially in a working database being ...
    (microsoft.public.access.forms)
  • Re: Problem w/ VBScript running against SQL Server 2000
    ... bay_id is the identity field in your database. ... account for sql injection anyway. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)