Issue:
I have a linked table (ODBC) each time I run a query a pop-
up box appears asking for my password for the other
system. I then design a make table query using the Access

I have information in the same table but in seperate fields, how can I add
the contents of one to the other?
Field = Projects + Field = RSS No
Thank you

How can I return with access programming the following
information of an access file:
1). The created date and time.
2). The user that created it.

I don't know if I should be asking this question in the
table structure section or forms design, but I'll start
here.  I am in the process of creating a database for
energy sales and purchases.  I currently have four tables

I am just frustrated.  I did not think anyone would
actually read what I wrote.  I should have just reposted
the question without venting.  I understand not actually
speaking with the person can create difficulties.  I will

  I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click > properties doesn't reveal this
Paris

I am using the lookup wizard to create a lookup column
using an existing table within my database however I get
an "automation error".  I can get as far as choosing the
table and the fields then get "Automation error. The

One of the advices on MVPS.org is not to use lookup fields in tables, their
commandment reads:
'thou shalt abhor the use of "Lookup Fields" which art the creation of the
Evil One'

Is there a way to return when a mdb file was created?
Like CurrentDb.Name will return the Name of the file.
What is the command the will return the date and time the
file was created?

My customer received a message from Access indicating
that his db was corrupt and did he wish to repair it.  He
said Yes!
Since then he is unable to open the db at all and

I have three tables each containing separate but related information.  The
first table is the address table, which is the main table.  The second table
is a customer table and the third table is roofinfo.
What I need to do is link any number of customers to one address and any

I am trying to create a smaller database table extracted from a rather large database table of slightly over 1,000,000 records (1MR), supplied by another person.  Access 2000 will slowly open, sort, and/or filter the original 1MR table, but will NOT permit saving a smaller ...

Help
I am a longtime paradox programmer is having a hard time
seeing the "light" in ACCESS.  One to many in ACCESS
seems beyond my..

help how do i make up a table , record sheet with names, date, amoun
payed, signature on it ??
i have never had to use any of these programs before and am ver
confussed please help ??

Can I specify a table for Access to save import errors in
rather than have it create a new errors table each time?