🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Błąd 2004 Access

#137026
From: Xylo
Date: Mon, 02 Nov 2015 09:36
35 lines
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-mail

Show 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