Hi, I'm trying to analyze one simple column of data collected at 1-second
intervals over several weeks. Raw data I'm importing into Access look like
this:
DATE,         TIME,            XDATA

Is there a way to kick the users out of a backend database?
I know there is a method based on how long a user has been logged in,
but I am just looking to kick some people out ... no warning needed.

I was wondering what the best (or easiest) way to track when the last time a
record was changed/updated?

Does anyone know of any additional resources online to get Access help?

I have a code procedure that is building a file from a series of
operations. I wanted to avoid the possibility of duplication, so I set
up the first field as indexed.
However, when I run SELECT ...INTO, it appears to delete my table

I am trying to calculate part of a table based on the elements of one column.
The elements are letters (NC, CSR, H, CON, & O).  These elements are not
being recognized when I try to count a specific element.  I keep returning a
total count.  Can any one help me with an ...

I have designed my business forms in info path.  The completed entries on
these forms will be sent to an access db is that right? i need a customer
database but i am struggling somewhat.

I have used the built-in Delete Record command button to enable users to
delete certain records, but I would like to add a popup that says "Are you
sure you want to delete this?" with Yes/No options.
I'm sure I've seen how to do this somewhere - is it a dialogue box that I

I'm working on a Q&A Database, where each QuesID has a different set of
possible Answers.  I have not been able to figure out how to get my answer
field's pull-down to change based on the QuesID of the current record.  The
code I tried is:

I have a field in my 'Customer' table based on a template database.  It has web link
properties and executes successfully by double-clicking on the link.
I wish to convert it to an email link, so that it opens up the default email client
on the local computer.

I have a 2.2 GB CSV file. Every time I try to import it I get the jet
engine error, which I assume is because the file is so large. The file
is essentially a massive statewide address book and I only need
records from one city (which represents about 20% of the file). So, is

i'm uploading data from excel to access via excel object
i would like to know if there might be some deviation in the
calculations when the number is too small(for example 0.00012) so when
it multiply the amount by this figure it will round the small number

I maintain a shared Access 97 database. I have developed an export
process whereby I use DoCmd.TransferDatabase acExport to copy queries,
forms and selected rows from tables to a subset of the database which
I then send to a remote user who is specifically responsible for that

Can I limit what can be typed into a text box? I only want to be able to
enter six characters (alpha or numeric).
Thanks for the help!

I'm trying to finish a project which is going be about 114 pages on MS Word
which will require a lot of repetitiveness on my part. The other day I spent
several hours making macros which worked perfectly. Today when I opened the
document I discover none of the saved macros were ...