Problem in Table with datatype decimal

New Contributor

In Access i have the following Table:



   ID: Autowert;
   Feld1: Kurzer Text;
   Feld2: Zahl (Long Integer);
   Feld3: Zahl (Decimal 18,0);
   Feld4: Zahl (Long Integer);


By executing the following sub Access crashes after the Debug.Print of Feld2 ab (seems it has to do wihth the datatype decimal of this field):


Public Sub Test()
Dim rs As DAO.Recordset
Dim F As Field

On Error GoTo Fehler

Set rs = CurrentDb.OpenRecordset("SELECT * FROM tbl_Test;", dbOpenDynaset, dbSeeChanges)
If Not rs.EOF Then

For Each F In rs.Fields
Debug.Print F.Name & ": " & F.Value
Next F

End If

If Err.Number <> 0 Then MsgBox Err.Number & " " & Err.Description

End Sub

3 Replies

Meanwhile i found out that it seems to be a bug in Access Version 2005. In the previous Version the problem does not exist.

best response confirmed by HartwigSch (New Contributor)
There have been a number of similar reports regarding this version. The current recommendation is to roll back to a prior build.

Does someone know when Micrsoft is expected to fix the bug? Our company does not roll back to an earlier build.