User Profile

Collapse

Profile Sidebar

Collapse
HaBe1963
HaBe1963
Last Activity: Jul 9 '16, 11:12 PM
Joined: Jun 20 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • HaBe1963
    replied to MS Access database grow issue
    zmbd,

    the code as last posted is what it is. Actually the part

    Code:
            DoCmd.SetWarnings (False)
            DoCmd.OpenQuery "KeyFind:DEL"
            DoCmd.SetWarnings (True)
     
            Set Keys = CurrentDb.OpenRecordset("KeyFind")
     
            STArray = Split(Ways!Veld4, ";")
            For Each word In STArray
                If Len(word) > 0 Then
    ...
    See more | Go to post

    Leave a comment:


  • HaBe1963
    replied to MS Access database grow issue
    zmbd,

    this was the last version I used

    Code:
    Dim Ways As DAO.Recordset
    Dim ID_Old As String
    Dim ID_New As String
    Dim STArray() As String
    Dim SaveTime As String
    
    Set Ways = CurrentDb.OpenRecordset("Ways_Sorted")
    
    Ways.MoveFirst
    
    Dim word As Variant
    
        While Not Ways.EOF
         
            STArray = Split(Ways!Veld4, ";")
    ...
    See more | Go to post

    Leave a comment:


  • HaBe1963
    replied to MS Access database grow issue
    zmbd,

    It looks like I was a bit too enthusiastic. All looked OK, but after 450,000 loops or so the database suddenly exploded, although at first there was no significant growth.
    I think I leave MS Access as it is and write some conversion code in C++
    Looks like Access isn't really helpfull in this.

    Thx for all your advices
    See more | Go to post

    Leave a comment:


  • HaBe1963
    replied to MS Access database grow issue
    Thx both,

    I skipped adding the ID's to the Keys table and instead of that I used the array directly for looking up the New ID's.
    Also instead of
    Code:
    Ways!Veld4 = Replace(Ways!Veld4, ID_Old, ID_New)
    I first build up Veld4 with the new ID's and then set Veld4 to this new Veld4 instead.
    Although the code is somewhat slower there is hardly no size growth now.

    Also I'm looking into a Directory object to store the Old...
    See more | Go to post

    Leave a comment:


  • HaBe1963
    replied to MS Access database grow issue
    Hi,

    Thx for your reply. I did build the database as an .accdb first, but had the same issue. I tried to include a piece of code to compile and repair the database, but did get errors. As I did this with a previous mdb database I tried this format, but had the same issues.

    The Line 52 - hanging "end if" is a part in which I checked the database size in order to prevent a corrupted DB if it exceeded 2G
    ...
    See more | Go to post

    Leave a comment:


  • HaBe1963
    started a topic MS Access database grow issue

    MS Access database grow issue

    Hi,

    I have created below piece of code in order to amend some data in an Access table:

    Code:
        Dim Ways As DAO.Recordset
        Dim Keys As DAO.Recordset
        Dim Recordcount As Double
        Dim Records As Double
        Dim ID_Old As String
        Dim ID_New As String
        Dim STArray() As String
        Dim SaveTime As String
        
        Set Ways = CurrentDb.OpenRecordset("Ways_Sorted")
    ...
    See more | Go to post
    Last edited by zmbd; Jul 8 '16, 05:20 PM. Reason: [z{re-stepped the code-block}]

  • HaBe1963
    replied to Subform doesn't show any records
    OK, looks like I've found the answer elsewhere. It appeared that my mainform was bound to a query were it shouldn't have been.
    Removing this bound query did the trick.
    Thought I knew MS Access a bit, but appearantly there is still much to learn.
    See more | Go to post
    Last edited by NeoPa; Jun 26 '16, 12:48 AM. Reason: Removed illegal link to competing forum.

    Leave a comment:


  • HaBe1963
    started a topic Subform doesn't show any records

    Subform doesn't show any records

    Hi,

    I'm having an issue with MS Access 2010 which drives me crazy.
    I do have a form with some subforms. The subforms are not linked to the main form, but their recordsource queries on some fields on the mainform.
    So far so good. If I change the values of the fields on the mainform the subforms are showing the correct records.

    However when I reset the values on the mainform with some VBA code the issue begins....
    See more | Go to post
    Last edited by zmbd; Jun 29 '16, 06:19 AM. Reason: [z{set code tags}]
No activity results to display
Show More
Working...