microsoft access error after update

I have this program that we use to do quick estimates when people walk in. The program was working fine before we did updates for our office program. Afterwards it gave an error and went to debug. We are a small buisness and the guy before me setup the program. I don't know anything about visual basic or access programming. I was wondering if someone could help me out with this problem. If you could fix it for me that would be even better.

When I ran the program I got this error message:
Run-time error '-2147024769 (8007007f)
Method 'connection' of object '_CurrentProject' failed.

The line at fault is: Set con = Application.CurrentProject.Connection

The update(s) at fault: Office service pack 1 and 2 for Microsoft Access XP (Sorry that doesn't narrow it down much)
We are running Windows 2000 Professional

I have uploaded teh 3.75mb file onto our website so you can download it and view it. It is located at www.springhome.net/estimatedatabase.mdb. If you fix it or have any advice fell free to email it to me at cplettspringwood@hotmail.com


Answer this question

microsoft access error after update

  • Christof.Mattes

    First of all I love DAO... but I haven't used it since VB6.

    How come you chose it I'd really recommend ADO.NET, which I have reasonable Access experience.



  • Mladen Mihajlovic

    This problem is documented with a fix here.


  • Paul Monaghan

    Charles Springwood, what kind of assistance are you seeking This is a board for developers who work with microsoft products.

    Are you looking for consulting



  • JZucker

    I am having the same problem. I use DAO. The process works on a computer with Win98, but not WinXP. Both computers have MS Access 2000 SP3.
  • Tony Roebuck MSFT

    I have a very similar problem, but I get a dll error and I don't know if I am using ADO or something else. Can you help It works on other xp machines and on 2000 machines, but two of the machines that run xp it gives us the error.

    Set con = Application.CurrentProject.Connection


  • Aj - Malta

    I think we're going to need a whole lot more information deriving a larger picture.

    Is the language VBA (If I'move you to the VBA forum :) ). What is the language and what kind of file access does it use DAO or ADO



  • microsoft access error after update