Application Not Starting (HELP)

[funderburgh]

I have an application I have built for our private school. The application uses shared databases and is installed on workstations through the school. The database is stored on a public file on my computer.

Recently I added a table to the database and tested its functionality on my development copy of the application. When I was satisfied I added the new table to the production database.

This morning I got complaints that the application was not working and could not be opened. I assumed that the installed versions were having a conflict with the updated database. I can't diagnose the problem because all versions of the application opens for a second and then closes, even my development version.

I have restored backups and they behave the same way.

I am at a loss to figure out where to go here. I can't get anything to open.

Any help is welcome, I am under the gun today.

 

[the_net_2.0]

I am not a big guru when it comes to diagnostics, but have a look at this thread: http://www.mrexcel.com/forum/showthread.php?t=396824

The suggestions made there might be a place to start...

 

[dfenton]

Is your application split? That is, are tables in one database (back end) and the forms/reports/queries/modules/macros in one file (front end) with links to the back end?

If not, now is a good time to fix that. This means you can send your new front end without overwriting the users' data.

Otherwise, I'd start with the advice in the thread cited above, i.e., to import everything into a new database as a starting point.