woodsbw
asked on
Opening an Access Form (2010)
We are getting the "execution of this application has stopped due to a run-time error". when opening a form from the main application window.
The program is being run using Access 2010 Run-time version.
The machine is run from a Windows XP with sevice pack 3 system and all the updates.
The database resides on a 2008 R2 server in the same subnet as the desktop client.
The database application was created on a different subnet and when you run it from a machine on the subnet it was created, it works great. Both are identical machines (desktops) except for the subnet. When you run it from a system on the other subnet (where the user resides) we get the error mentioned above.
We have another 2010 access database application being used that works great from either subnet.
The program is being run using Access 2010 Run-time version.
The machine is run from a Windows XP with sevice pack 3 system and all the updates.
The database resides on a 2008 R2 server in the same subnet as the desktop client.
The database application was created on a different subnet and when you run it from a machine on the subnet it was created, it works great. Both are identical machines (desktops) except for the subnet. When you run it from a system on the other subnet (where the user resides) we get the error mentioned above.
We have another 2010 access database application being used that works great from either subnet.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Splitting is only a part of the issue.
My suspicion is that there is an issue with that individual form.form
Since the database is not split I would assume that you are not using a accde as the front end.
Any database used in the access runtime that is not complied into a accde must have very rock solid and complete error handling. I cover this in my article in the link I provided above.
My suspicion is that there is an issue with that individual form.form
Since the database is not split I would assume that you are not using a accde as the front end.
Any database used in the access runtime that is not complied into a accde must have very rock solid and complete error handling. I cover this in my article in the link I provided above.
ASKER
Ok. Splitting the database did not resolve the issue. Making the ACCDE did not complete due to the following:
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
I would create a new blank front end database. Import all teh object from the old front end into the new front end. Set the VBA references. Compile the VBA code. If it complies then try to make the ACCDE.
Note: Rebuilding a database like this help with corruption and other issue. I do this on most fron tend databases after making lots of design changes.
Note: Rebuilding a database like this help with corruption and other issue. I do this on most fron tend databases after making lots of design changes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
While the Expert did provide us with some valuable insight abut our problem, we felt it was better for us to move to SQL as the solution.
ASKER