Suddenly my App Fails on start up

  • Thread starter Thread starter Richard Albrecht
  • Start date Start date
R

Richard Albrecht

Ok, this is strange:

Suddenly my app fails when it starts up. There's an AutoExec Macro that
runs a function called main. The error says Action Failed! Condition True,
Action Name: RunCode.

And even stranger is that if I try and make a change, Access says it can't
save my project.

Yesterday this was working fine!

Any Ideas!

Rich
 
I could, but it's not a code problem, it has to be an access problem. It
worked fine yesterday, today it throws that error. Also No work was done on
the madual that has the Main function in it.

Also why is access saying it can't save my project???

Rich
 
Richard said:
I could, but it's not a code problem, it has to be an access problem. It
worked fine yesterday, today it throws that error. Also No work was done on
the madual that has the Main function in it.
Click to expand...

I understand you feel it cannot be a code problem, but 'action failed'
means that the action could not be completed. The code is part of the
action, we usually take something apart if it doesn't work, so why not
post that code?
 
Ok, here's the deal. This is a commercial Access program my company
purchased, along with the source code. The problem has to be something in
access. It worked fine then suddennly stopped.

The real strange thing is that if I go into the code of the Main() function
that gets called, and place a stop statement in the beginning, Save the
code, then exit out of Access, I get the "Access can't save your project
message"

This is on a single computer and I'm the only one running it.

That's why I feel this is an internal access issue. I've never had problems
like this using Delphi, since field test 2.

Rich
 
Richard said:
Ok, here's the deal. This is a commercial Access program my company
purchased, along with the source code. The problem has to be something in
access. It worked fine then suddenly stopped.
Click to expand...

Okay. Do a Ctrl-G and check under Tools:References if any is marked as
Missing. Don't ask me how this occurs. If so, uncheck and try again.
The real strange thing is that if I go into the code of the Main() function
that gets called, and place a stop statement in the beginning, Save the
code, then exit out of Access, I get the "Access can't save your project
message"
Click to expand...

A2K I suppose? I don't have that here so I'll leave this to my
collegues. Sure it is an .mdb and not an .mde?
 
Richard Albrecht said:
Ok, this is strange:

Suddenly my app fails when it starts up. There's an AutoExec Macro
that runs a function called main. The error says Action Failed!
Condition True, Action Name: RunCode.

And even stranger is that if I try and make a change, Access says it
can't save my project.

Yesterday this was working fine!

Any Ideas!
Click to expand...

Two things occur to me: one, a broken reference, and two, a corruption
of your VB project. Have you checked for a broken reference? See this
link:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

If that's not the problem, and doing a Compact and Repair doesn't fix
the problem (unlikely, it seems to me), then you might make a copy of
the database and try decompiling it using a command line like this:

msaccess.exe /decompile "C:\Path To\YourDBCopy.mdb"

You want to try this only on a copy of your database, as it has been
known upon rare occasions to make things worse. After decompiling,
compact the database, then recompile it, then compact it again.

At various times you may need to hold down the Shift key while opening
the database to bypass the startup code and settings. However, the
database designer may have set it up not to allow you to do this.
 
Here some more info...

The application runs ok if I run it from another computer over the network
to the computer that can't run it. Unfornatly that's my development
computer.

I checked the referances and there is none showing missing. Both computers
show the same referances also. I guess I'll try re-installing Access and
see if that solves it.
 
Richard Albrecht said:
Here some more info...

The application runs ok if I run it from another computer over the
network to the computer that can't run it. Unfornatly that's my
development computer.

I checked the referances and there is none showing missing. Both
computers show the same referances also. I guess I'll try
re-installing Access and see if that solves it.
Click to expand...

That sure sounds suspiciously like a references problem. Did you try
the other steps Doug Steele suggested, like unchecking a reference at
random, closing the dialog, then going back in and re-checking it? Did
you install or uninstall anything on your computer in the last few days,
right before the problem showed itself?
 
Did I miss something, I don't see any posts from Doug Steele...

I will play around with the referances some more.

Thanks

Rich
 
Ok, I tried launching the app, got the error, hit HALT, Picked File - Name
of project to show the project window. Unchecked all referances it would
allow me to, Closed VBA window, closed Access, got the message that Access
couldn't same my project, then relaunched program, got the same error. Went
to VBA window and the Referances I un-checked were still checked.

Should I try a reinstall?

Rich
 
Richard Albrecht said:
Ok, I tried launching the app, got the error, hit HALT, Picked File -
Name of project to show the project window. Unchecked all referances
it would allow me to, Closed VBA window, closed Access, got the
message that Access couldn't same my project, then relaunched
program, got the same error. Went to VBA window and the Referances I
un-checked were still checked.

Should I try a reinstall?
Click to expand...

Hmm, if Access can't save the project, any changes you make to the
references aren't going to stick, I guess. But why can't Access save
your project? What is the exact text of the error message? Is this an
..mdb file or an .mde? Have you ensured that you have opened the
database exclusively?
 
The error message simply says:

Access could not save your project


The file is a mdb. It's on my laptop and I'm the only one using it. I
searched the knowledge base for that error and couldn't find it at all.

I did try a re-enstall, No luck. I suppose the next thing would be a total
uninstall, then re-install.

Any other ideas?

Rich
 
Richard Albrecht said:
The error message simply says:

Access could not save your project


The file is a mdb. It's on my laptop and I'm the only one using it.
I searched the knowledge base for that error and couldn't find it at
all.

I did try a re-enstall, No luck. I suppose the next thing would be a
total uninstall, then re-install.

Any other ideas?
Click to expand...

Are you using Access 2000 with Windows NT 4.0 SP3? If so, maybe this
applies:

http://support.microsoft.com/default.aspx?scid=kb;en-us;218993

Regardless, I reckon it would be a good idea to make sure you have all
the latest service packs for your Access version and operating system.
 
Access 2k on Win XP Pro

I have all SPs for Windows and Access.

I will look at that article anyway.

Rich
 
Back
Top