---
title: "begränsning i Access??"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/120193-begränsning-i-access"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Eclipse"
published: "2005-01-15T16:31:07.000Z"
updated: "2005-01-15T16:38:05.000Z"
replies: 1
views: 249
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/120193-begränsning-i-access"
---

# begränsning i Access??

## #1 — Eclipse, 2005-01-15T16:31Z

```
' ## DELETE OLD POST IN HTTP_REFERER-LOG -- 42 DAYS = 6 WEEKS
SQL = "DELETE * FROM [http_referer] WHERE dteCreated <#" & dateAdd("d", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [referer_log] WHERE dteCreated <#" & dateAdd("m", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [active_meta] WHERE dteCreated <#" & dateAdd("m", -43, date()) & "#;"
Conn.Execute(SQL)
```

Finn fem fel...!! :-)

Datumet ska vara 2004-12-03 (gäller just idag).
http_referer = 2004-12-06, 4.344 poster
referer_log = 2004-09-29, 29.073 poster
active_meta = 2004-09-23, 916 poster

Varför raderas inte posterna!?

Permalänk: https://www.webforum.nu/p/120193

## #2 — Eclipse, 2005-01-15T16:38Z

```
' ## DELETE OLD POST IN HTTP_REFERER-LOG -- 42 DAYS = 6 WEEKS
SQL = "DELETE * FROM [http_referer] WHERE dteCreated <#" & dateAdd("d", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [referer_log] WHERE dteCreated <#" & dateAdd([b]"m"[/b], -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [active_meta] WHERE dteCreated <#" & dateAdd([b]"m"[/b], -43, date()) & "#;"
Conn.Execute(SQL)
```

Byt "m" till "d"... och det behövs ett inlägg i forumet för att se det! Beklagligt, verkligen!

Permalänk: https://www.webforum.nu/p/1530581

---

Tråden på webben: https://www.webforum.nu/amne/asp/120193-begränsning-i-access