Re: Update tabeli połączonej z bazy sql

Article View: pl.comp.bazy-danych.msaccess

Article #137434

Back to pl.comp.bazy-danych.msaccess Previous Next

#137434

From: Smyk
Date: Tue, 04 Apr 2017 09:36

11 lines
1642 bytes

LeszekN wrote at Di 04.04.2017 11:11:

> jedynie zmieniłbym otwarcie recordsetu na
> Set hist = db.OpenRecordset("hist_karta", dbOpenDynaset, dbSeeChanges)

Jeśli chce otworzyć Recordset, tylko w celu dodawania nowych rekordów, 
najbardziej optymalną kombinacją parametrów będzie:

Set hist = db.OpenRecordset("hist_karta", dbOpenTable, dbAppendOnly)

Ciao, Smyk

Technical Details

Message-ID: <obvpel$qis$1@news.albasani.net>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail

References:

<0baa993e-3f14-41c5-9738-4c5c6b161544@googlegroups.com> <f9a1b82e-72ae-4f0a-9199-b9e585cc6e3f@googlegroups.com> <7783fe2d-8a1c-4fcb-9e7c-7c66947e043f@googlegroups.com> <fd5b6e61-25e3-4409-ab74-6f16adf1f86f@googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail
From: Smyk <duzy.trzmiel@onet.pl>
Newsgroups: pl.comp.bazy-danych.msaccess
Subject: Re: Update tabeli połączonej z bazy sql
Date: Tue, 04 Apr 2017 11:36:21 +0200
Organization: albasani.net
Lines: 11
Message-ID: <obvpel$qis$1@news.albasani.net>
References: <0baa993e-3f14-41c5-9738-4c5c6b161544@googlegroups.com> <f9a1b82e-72ae-4f0a-9199-b9e585cc6e3f@googlegroups.com> <7783fe2d-8a1c-4fcb-9e7c-7c66947e043f@googlegroups.com> <fd5b6e61-25e3-4409-ab74-6f16adf1f86f@googlegroups.com>
Mime-Version: 1.0
X-Trace: news.albasani.net 0qto97VA37fTireyw88dr7b+DoDeIGbiX+uUHguC1bEwRY6OiYBJIZIwpKGStbSKU8BKCfRurBhzeq8ylEyKjrAmcpD8f5tIjrMn5ZiIqE1+JD3iBHR6CbWkxYAlvUsW
NNTP-Posting-Date: Tue, 4 Apr 2017 09:36:21 +0000 (UTC)
Injection-Info: news.albasani.net; logging-data="m2m5hNQcXn5PVugXDXFnK22hrYhOjIuRYkv3pUYq+ywQVo8d5KxpZdFRuJQWEvByK92k0y6X7xq53SneHiV+DrwmNm2K+ft42fpFP/ad+fmYxgLNjxWzxAzLQm3K3A2o"; mail-complaints-to="abuse@albasani.net"
User-Agent: KNode/4.9.5
Cancel-Lock: sha1:MdDNQkGajeH+VgCjcrS01nKzGN0=
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message