Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Problem in Table with datatype decimal

Copper Contributor

In Access i have the following Table:

 

tbl_Test:


   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


Fehler:
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 (Copper Contributor)
Solution
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.

1 best response

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

View solution in original post