Article View: pl.comp.bazy-danych.msaccess
Article #137026Błąd 2004 Access
From: Xylo
Date: Mon, 02 Nov 2015 09:36
Date: Mon, 02 Nov 2015 09:36
35 lines
2474 bytes
2474 bytes
Witam !
Korzystam w moim accessie 2003 / Win 7 z funkcji
Function SystemOnline(ByVal ComputerName As String)
' This function returns True if the specified host could be pinged.
' HostName can be a computer name or IP address.
' The Win32_PingStatus class used in this function requires Windows XP or later.
' Standard housekeeping
Dim colPingResults As Variant
Dim oPingResult As Variant
Dim strQuery As String
' Define the WMI query
strQuery = "SELECT * FROM Win32_PingStatus WHERE Address = '" & ComputerName & "'"
' Run the WMI query
Set colPingResults = GetObject("winmgmts://./root/cimv2").ExecQuery(strQuery)
' Translate the query results to either True or False
For Each oPingResult In colPingResults
If Not IsObject(oPingResult) Then
SystemOnline = False
ElseIf oPingResult.StatusCode = 0 Then
SystemOnline = True
Else
SystemOnline = False
End If
Next
End Function
w ten sposób sprawdzam pingiem czy mam urządzenia w sieci.
Niestety po około dwóch godzinach wywala mi błąd 2004
Brakuje pamięci aby wykonać operację, zamknij niepotrzebne aplikacje i spróbuj ponowić operację
Pracuje sam access, muszę z menadżera zadań zakończyć accessa i uruchomić od nowa.
Dlazcego ?
Proszę o podpowiedzi i pomoc
Technical Details
Message-ID:
<ec3a9e5c-7860-4e03-a5cb-44e836b17480@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!i2no1610049igv.0!news-out.google.com!z4ni43667ign.0!nntp.google.com!i2no1610042igv.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailShow Full Headers
Complete Article Headers
X-Received: by 10.182.22.200 with SMTP id g8mr18497412obf.0.1446457007155; Mon, 02 Nov 2015 01:36:47 -0800 (PST) X-Received: by 10.50.103.35 with SMTP id ft3mr161939igb.9.1446457007115; Mon, 02 Nov 2015 01:36:47 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!i2no1610049igv.0!news-out.google.com!z4ni43667ign.0!nntp.google.com!i2no1610042igv.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Mon, 2 Nov 2015 01:36:46 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=194.169.236.28; posting-account=gW5xHwoAAACy1U5SdCzvKeuZTmdLup9Z NNTP-Posting-Host: 194.169.236.28 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <ec3a9e5c-7860-4e03-a5cb-44e836b17480@googlegroups.com> Subject: Błąd 2004 Access From: Xylo <papkin121@gmail.com> Injection-Date: Mon, 02 Nov 2015 09:36:47 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit