It seems Access does not allow the column named Password.
Is it?

Do anyone know how to disable automatic table name change in Access
queries?
Currently, I am testing a set of 30 queries in an Access database and
need to have these 30 queries run on different tables, for example,

I put Office 2003 on my new Vista Home Premium system. Things seem to be
working, except I can not open reports in Access any more. The same file
works great on Windows XP. Any one else come have this same problem? I tried
some other Access files with the same results, looks like ...

I have a question about using the API hide access window module. This
works ok for my forms, but the report preview window always gets
hidden or shows up behind the form. How can I use this module and have
the preview reports in front of the form? I use the code from the

I have a client who has 5 independent consultants working for her.
Each person has their own machine and is responsible for installing
Access.  I am about to distribute a new system using an Access
2002.mde  Of course I get an email today informing me that ONE of the

I'm trying to import data, modify the data then insert it into a new
table.  The code below works fine for it but it takes a really long
time for 15,000 odd records.  Is there a way I can speed up the
processing substantially? as it currently takes about 10 minutes and

I have a Table imported from text file containing Records of books.
BUT the fields and data
value is entered as the First and Second Column (ColA, ColB). The
records are separated by 2 empty rows. Some fields are missing for

Im looking into putting a paper based stock control system (approximately
containing 3000 shoes & bags) into a database.
I would like to know if Access is the ideal solution. (Will it be able to
hold all the data? Will it be able to perform queries quickly?)

access 97, SQL 2005
I am having issues with a UNION query. The query is prompting the user
for the apramter twice. I know if I create a form where the user can
type the parameter, I can reference the value from the form in the

I am running Access2.
In design mode for a report,
File | Print Setup | More
   I change:

I've done several reports and spreadsheet-creators driven by CrossTab queries.
e.g. A report shows totals for "funds" and we never know what or how many funds
will be present.   A CrossTab query sums up the XYZ field for every fund and
flips the totals on their side so there's a ...

Okay, after spending two hours trying to figure out what I thought
would be simple, I give up. If anyone cares to help, here's my
problem. I have a database consisting of a Customers Table. It has
some 1400 entries with name, address, city, etc. O.K., now I need to

I have a form that has a data source of qry_login.
I want to display a value from a table qry_SQLConnect called "SQLServerDB"
I used the expression builder and came up with this,
=qry_SQLConnect.SQLServerDB, but when I view the form I just get #Name?

I have two tables, table a and table b, I want to run a query that
will remove any records from table a that are not contained in table b
the result being table c or something similar. Any assistance would be
appreciated.

any guide for new users for using access