Re: Eure Ideen gefragt: Access Datenbank beschleunigen (mit Linux versteht sich)

Article View: ch.comp.os.linux

Article #24724

#24724

From: Pascal Eugster
Date: Sat, 16 Jan 1999 00:00

15 lines
1292 bytes

Danke fuer die Tips (bei Probs meld ich mich wieder)

> zum Beispiel so:
> Dim Datenbank As Database, Daten As Recordset, s as String
>     
>     s = "select * from Adressen where Nachname Like '" +
> [Formulare]![SuchFormular]![MeinSuchFeld] + "'"
>     Set Datenbank = DBEngine.Workspaces(0).Databases(0)
>     Set Daten = Datenbank.OpenRecordset(s, DB_OPEN_DYNASET, DB_READONLY)
>     do until Daten.EOF
>      ...
>     Loop
> In Formularen kannst Du  das ueber z.B. Recordsource = s im "Ereignis"
> onLoad machen.
>

Technical Details

Message-ID: <01be420f$f19b9300$b49387c1@home.home>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<01be3d84$89cacfa0$ad9387c1@home.home> <369c1efe.350516696@news.ohz.north.de> <369A09E5.3D3B934F@gmx.net> <369B154B.34B15D8A@codelab.ch> <369B185D.D6F4E3E1@gmx.net> <369B35A2.1A7BB2CF@cns.mpg.de>

Show Full Headers

Complete Article Headers

X-Google-Language: GERMAN,ASCII-7-bit
X-Google-Thread: f4b73,ca0ee00d4e000729
X-Google-Attributes: gidf4b73,public
X-Google-Thread: f55df,ca0ee00d4e000729
X-Google-Attributes: gidf55df,public
From: "Pascal Eugster" <eugster4@centralnet.ch>
Subject: Re: Eure Ideen gefragt: Access Datenbank beschleunigen (mit Linux   versteht sich)
Date: 1999/01/16
Message-ID: <01be420f$f19b9300$b49387c1@home.home>
X-Deja-AN: 433298614
References: <01be3d84$89cacfa0$ad9387c1@home.home> <369c1efe.350516696@news.ohz.north.de> <369A09E5.3D3B934F@gmx.net> <369B154B.34B15D8A@codelab.ch> <369B185D.D6F4E3E1@gmx.net> <369B35A2.1A7BB2CF@cns.mpg.de>
Organization: Improware Network Services, Switzerland
Newsgroups: ch.comp.os.linux,de.comp.os.unix.linux.misc

Reply to Parent Message