Posts by wackopmij

    Re: Query Access Database Using ADODB Very Slow


    Hello Gollem,

    Thans fo the fast reply (sorry for my slow reply, went on a holliday)

    What I did, was to store each time a user used a function, the name of the user, date and the action (naam of the tool).
    But sinds these are all small tools the user had to wait longer to 'log' or write that data to the database, then the actual tool itself.

    But in the main wile and some searching on this form, a better idea came to me. ..
    Instead of writing each time from excel to access, i saved up a list of logs within the .xla file.
    Then when the user closes excel I write every line to the access table.

    Hello Everybody,


    I have a code to write three fields of data (genereted by code) to an Access Database using ADODB.
    BUT this is very slow, considering this is a simple code using SQL. Is there another faster way to write the fields to a file or database on a shared drive over the network?


    Thanks in advance,


    Gr, W.