Error:execution of this application has stopped due to a run-time error

[Sandy H]

I am getting this error at my first attempt to deploy an Access 2007
database at runtime.

I have made sure every procedure has meaningful error code - I have checked
numerous times just to be sure.

I have made sure that my Excel code uses late binding.

I have made sure all my recordsets are declared as DAO.Recordset

Any other ideas or help would be greatly appreciated.

Thanks in advance
Sandy

 

[Clifford Bass]

Hi Sandy,

Do you mean as an .accde file? Are you deploying the Access 2007
Runtime or is the expectation that the user will have Access 2007? One thing
to try may be to create a very simple test database. Say a small table and a
simple form that uses the table and that is set to be opened when the
database is opened. Then set it up for deployment in the same way. And test
deploying it. Does that work? On another front, if you simply copy the
..accdb database to the target machine and open it, does that work? Also,
does the target machine have Excel 2007 on it?

Hopefully some of that will give you some ideas of how to figure out
the problem.

Clifford Bass