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

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
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
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