I have database with four users. Users were created by user-level security
wizzard.
How can I (as admin) know who is using the database and somehow log this
sessions?

I am new to using Microsoft Acces, I know I need to use some VBA code
to do this job. Not sure where to start is someone could put me in the
right direction. Any help would be appreciated.
I have a connection string I need to use to import data into a single

I think I already know the answer to this but...
Is there a way, in the Query Design Grid tool, to create a make table
query that prompts the user for the name of the table at run time? I
know it can be done in a VBA module, which is probably the preferred way

Lets say I've got a list of 50,000 records, and the user has half of
them selected, not in any particular order.  I need to update one
field on all selected records.  There is a primary key on the table.
What would be the *fastest* way to update those records?

Images stored in our database (stored as filenames but held elsewhere)
will form part of a long report. It is critical that when the report
prints the images appear at the highest possible quality (colour laser
with 100gsm Xerox Colotech+ paper). All tips, including

I'm embarrassed to ask this. I have a form with a bound object frame
which displays an embedded bitmap stored in the table that the form is
based on. How do I, by single or double click, get the image to open
in Paint (the current Windows file association). I'm reduced to using

I'm using VB6 to create a new record in a Access db. I'm doing so like this:
INSERT INTO Customers (Name Prefix, First Name, Last Name, Name Suffix,
Company, Phone, Email, Address1, Addres2, City, State, Zip, Country) VALUES
('', 'Din W.', 'Cambell', '', '', '1 8055553128', ...