Hello, I have a question about some MS Access issue I am having.  My
goal is to make a field that will list any revisions to the data that
have been made and when they were made.  I have it mostly working but
the one thing I can't figure out is how to list what the data was

am currently working on a project which the main application we
intended to use has fell through, so we have falled back on Access to
work through this.
The information we have imported into a single table contains

I have an old database which started out life in the Access 2 days!
It's full of lots of stuff which I'm not convinced is relevant any
longer. Would a good way forward be to create a new, blank database in
Access 2007 and then import the existing objects, re-create the

I have the following saved UNION query named qryPeople2NameInNPaperAd:
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] & "  " &
[AddnlOwnrAddr] & " " & [AddnlOwnrCity] & ",  " & [AddnlOwnrState] & "
" & [AddnlOwnrZip] AS Item, tblVehicleJobs.VehicleJobID

I did some work with Access .mdb's a couple of years ago. I was able
to save both the VBA code and a listing of properties for all form
objects to a text file that I could read without access to Access.
I've again begun to do some work with Access, but I've forgotten

I'm attempting to implement User-level security on an Access 2003
database in Access 2000 format and have hit a brick wall.  I created a
Workgroup Information File with myself as admin and added users without
any privileges as suggested by Access.  Next, I created a Group with ...

I'm using A97 import data wizard to import text file N2 a
table. The text file is a DIR listing produced by running
dir jdc*.* /s > c:\JDCs.txt
The wizard is chopping the lines off at the leftmost 80

I have a single table delete query in ACC2003 that will only delete if
I drop in a specific field and put the criteria 'is not null' I am
just simply trying to delete all records from the table. If I change
it to delete from *, it will return '0 records will be deleted, if I

I'm currently designing a database for a construction co and learning
how to use access on the fly.  I'm having a few problems with the re-
use of data if I link tables using relationships and enter the data
into one table it doesn't seem to show the data in the other table

i have a huge dataset that i am trying to summarize into one simple
report /
pivot table / query.
i have tried everything i know to get it to work, but the biggest

My Customers/Sales/Contacts management database interface is modeled
as if Customers are objects, Sales are objects owned by Customer
objects, etc.  (I'm running Access 11)
I have Listviews located just about everywhere for the purpose of

i have been writing an app for my work for 18 months now, in a fairly
organic manner! my boss has never used a computerised system and i
have been learning access along the way.
we are a tyre/exhaust garage and the app will cover buying stock,

I have an Access Table with following columns:
GID (auto number)
PID number
TreeID Text

Working with a database that's new to me and they have a make table
query that creates a variety of fields, a handful of which are
designated as datatype 'Number' to start.  It is then required to go
change many of these to datatype 'Currency'.  How can specify those

I keep getting a syntax error when attempting to use the INSERT command on a
Access db using VB6. I've narrowed the issue down to the date field. In the
db I have the Date field set as a Date/Time property. My SQL statement looks
like this: