I have an MDE file that is growing exponentially (from 3,900 KB to over
132,000 KB today).  I am not saving data in this MDE, although I use a
mix of offline and SQL tables for Read Only querying.  I also have many
forms and some reports and queries.  Many people use this DB on a ...

I have a form which the user can apply filters, and push a button to
preview a report. I cannot use me.filter=forms!myform.filter, because
some of the filtered fields are not present in the report. What I would
like is to obtain the ID field from the filtered form, and show only

I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.

I have created an Access DataBase concerning Staff Training. It's aim
is to know whether staff has undertook the minimum courses that they
are asked to do in year 1 of employment, year 2, etc ...
Templates (=training profiles) have been created on Excel with the

I have a data entry form that contains drop-down lists such as
'Assigned to:' with a list of staff member names. Those names end up as
numerical codes in the main table ('ProjectInfo') of the Access
database. Is there some way - such as a SQL satement added to a query

I have two PCs that consistantly cut off about one inch of the right
side of the chart.  I also see the missing section in print preview
(but just on the two machines).  The same charts print fine on all the
other PCs.  I've tried changing printers, and adjusting margins, but

I have a table that contains the database names of external databases.
Each one of these external databases contain a table (which has the
same structure) that I would like to query together as one list.
For example, say each external db has a table of names.

I tried to ask this question before on the 14th of January but I never got a
reply.  I'm still struggling with the problem.  I'll try to rephrase the
question:
I have a crosstab query with rows of students and columns of activities and

I have a report that prints daily. The report needs to print whether or
not there are records available. I read in an old post on this group
that putting an unbound text box in the report footer, with the
following code in the OnNoData event would work like a charm --

I have a database that I use to track odometre readings.  Several
vehicles are tracked.  As you can imagine, if the wrong vehicle is
entered for the given mileage, it will through off reporting.  I would
like to include some kind of validation or error checking.

I have a query which returns a sum of duplicate records following
inputting a parameter ( The field has the criteria Like "Enter data"
for the filter). This works fine and diplays the reults I am looking
for.

I have a client who wants to have Access ask to save changes anytime
data is changed or added into the database.  I'm not really an Access
guy, I actually run their servers, but have been dropped into the roll
because I have some understanding of it.  Any help would be greatly

This is driving me nuts - I'm trying to export my access table to dbaseIII
format.  Most of the fields are text except for 2 of them which are
numbers.  No matter what I try, the resulting exported file adds a decimal
and four "0" after the numbers.  All the numbers in the table ...

I have created a DB in Administrator login.And also added many tables
with that login.Now when I writing
Grant  Read ON <Table Name> TO Users
Getting the prompt

I hope someone out there has some input on this problem, it driving me
nuts.
This problem only occurs with one code .mdb out of many I have on my
system, which implies the problem is with the .mdb, not the