Have any of you heard of or used any commercially
available 3rd party solution that addresses common
forms of mdb file corruption? I don't think FMS has
anything like this. Perhaps other company does?

My application is calculation intensive and the servers are agonizingly slow.
Administrators of my application only update the backends once a month (twice
a month max). So, my launching program allows the back-end file to be
downloaded to the user's PC. This will provide maximum ...

Hope you guys can help.
I have a form"frmSafetyLevel1" in which users will enter data and once
they submit, the results will be displayed on "frmSL1Registration". My
problem here is i need to set some controls in the "frmSL1Registration"

Thank you already for the amount of information that has collected in
this group, very helpful indeed. I have a question in regards to
setting up individual emails to be sent based on a query:
What I currently have is a setup which is pretty much identical to this

I've inherited a tax report where all of the financial numbers are
currency.This is a detailed report that lists amount, tax and total for
that day ( total is listed in the database). The report gets its
information from a query. At this point all is working

              Can any one help me?
                The form i am making contains a combo box a command
button and a list box.
My problem is when i click the button i want to count the number of

Can anyone help? I am importing Emails from Outlook using the following
code:
Public Function ScanInbox(SubjectLine As String)
   Dim TempRst As Recordset

In the code below, it seems like there should be a way to simplify the
expression to search for the specific values of 1, 9, 10, 11 and 12.
It would be more tedious if I was looking to execute some code when x
would evaluate to, say, 1 or 3 or 5 or 7 and so on.  Could someone

I have a form that creates a new ticket. Click save on the form and the form
closes and updates the form underneath. I would like to print a report from
this form when I hit the save button all at the same time.
Here is what I have been working with.

I have a number of queries that require various parameters.  However,
the parameters will change infrequently, so I do not want the user to
have to respond to them every time they run the queries.  I am
tentatively setting up little tables to hold the parameters so they are

I am using WinXP Pro with Access 2003.
I created a custom toolbar and I added the Sort Ascending and the Sort
Descending button to it. When the user wants to browse a table, I have a
table selection window that displays the tables. When the user selects

Hope you guys can help.
I have a form"frmSafetyLevel1" in which users will enter data and once
they submit, the results will be displayed on "frmSL1Registration". My
problem here is i need to set some controls in the "frmSL1Registration"

hi,every one
im facing a problem in running access it's about
25 tables
80 forms

I want to do this from a for/next loop:
DoCmd.OpenForm aryForm2(count), acDesign, , , , acWindowNormal
Temp = aryForm2(count)
Forms!Temp.Section(1).BackColor = Forms!zfrmcolor!color2

Quick question.  I'm very much a beginner with Access so I'm sorry if
there's an easy way that I missed.
I have several fairly large tables that I am trying to export from
Access into SPSS for analysis.  I haven't found a way to go directly