Topics Search

Publishing database- Shut down run-time errors

Publishing database- Shut down run-time errors
Views: 12
I'm handing my database off to a client who doesn't want to split it, but also doesn't want to see any potential VBA Run-time errors. I compiled the code and digitally signed the database.

Is there a way to shut down the VBA run-time errors to a generic "error" message, or no error message at all? We don't want any users to have the option of ever pressing "debug" and getting into the
Sponsored Links:

Similar posts...


Setting up relationships between back-end tables and front-end queries

Setting up relationships between back-end tables and front-end queries Icon
I have an Access 2010 database that has a front end and a back end. Both are located in a shared folder on our server.

I am trying to work through the process of publishing this database to SharePoint 2010.

When I run the Web Compatibility Checker, I get the following errors:

Relationships that are not associated with a valid lookup field are incompatible with the Web.

These errors ( 3 ) are all associated with one query called Q_COMPANYDATA that is based on ODBC-linked tables on our SQL server.

correcting typographical errors

correcting typographical errors Icon
I am learning how to use Access. I have some large sets of data that I am importing from Excel and I am figuring out how to turn a flat database into a relational database (which is a very new concept to me and I am trying to get my head around it).
So I import data as a flat database and then I run the wizard to turn it into a relational database.
The thing that is bugging me is I get to a stage where Access wants to correct typographical errors. It gives me the option of making a change or selecting "Leave as is". The trouble is I don't want to correct any typographical errors. Access thinks it sees errors when there are none. BUT it flags hundreds of errors and I can't find away to "Leave as is" for all of these in one go. Instead I have to select "Leave as is" for each record in turn. This is very time consuming. Does anyone know what I am talking about and is there an easier way? I am using Access 2010 (which I think is pretty much the same as Access 2007).

Autonumber field resets when publishing database to SharePoint 2010

Autonumber field resets when publishing database to SharePoint 2010 Icon
I have a very simple table with ID (autonumber) and some other text fields. A while ago I made an append query to my ID field, starting at 9000.9001.9002.

After publishing my database to SharePoint 2010, I discovered that all IDs were reset to 1.2.3 and so on. Is this a well known problem, and can it be solved

Runtime Problem

Runtime Problem Icon
I've been working on a database for 2 months with no problems. for the first time, I got an error message which read: "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down." I have never seen this message before and I have no idea what is causing it. Do I just need to reinstall the run-time engine?

Run time vs Full Version

Run time vs Full Version Icon
I have created a database , split the database , and now I have multiple user ready to key into a form to update the table on the back end.

Sent in a request for multiple liscenses and it was denied. They told me to create the database so that they could use the database in Run Time.

Is there something that I have to do in order to allow the users to do the same work through Run Time

Handle Run-Time Errors in VBA

Handle Run-Time Errors in VBA Icon
When you are programming an application, you need to consider what happens when an error occurs. An error can occur in your application for one of two of reasons. First, some condition at the time the application is running makes otherwise valid code fail. For example, if your code attempts to open a table that the user has deleted, an error occurs. Second, your code may contain improper logic that prevents it from doing what you intended. For example, an error occurs if your code attempts to divide a value by zero. Learn how to trap run-time errors.

Run macros in different database

Run macros in different database Icon
I am working with three different databases, all of which work together in certain areas, normally through linked tables. One database gets updated via csv files and the other databases get backed up primarily via this database. I am trying to automate the update process. I run the primary database update first and then I need to call macros from the other two databases to run and update the other databases. My thought was to call all of the macros from one master macro (or code) that would run daily and update the databases. In short, I am having trouble calling the macros in the secondary databases to run from the primary database.
I managed to accomplish this using the RunApp macro action but because it doesn't pause I run into a bunch of errors. Is there a better way to do this

Error in Runtime Only

Error in Runtime Only Icon
when I run my database in access 2007 I do not get any errors. when I run it in access 2007 RT I get errors and it crashes and shuts down. I don't understand how you can fix an error if their is no warning an error is occurring?

Run Multiple Queries Simultaneously

Run Multiple Queries Simultaneously Icon
I currently have a database that creates local tables from ODBC connections to a DB2 database. These queries are run each morning. At present, each of them are run sequentially. As some of them are very large, it may take a significant amount of time before it finishes and runs the next make-table query.

What I would like to do is figure out a way to run them all at the same time. My thoughts were to possibly run each query in a separate instance of Access, preferably without having to create a separate Access database for each query. However, that is an option.

The idea comes from being able to create 2 databases, have them both open, and then run a make table query in both, at the same time.

DELETE column in TABLE

DELETE column in TABLE Icon
Is it possible to create a query that DELETES column in a table in ACCESS 2007?
the reason is, because I receive a very big database from my supplier, I need to delete a large number of column that are not needed by us. now there are 200 fields and I only need 15.

when publishing to complete database it takes to much time and is way to big in file Size.