I am trying to import a text file.  The first column of
this file has an account reference # that is 6 characters
long "  1234"  When viewing the text file those spaces
exist.  When I import the file access is eliminating those

Hy,
A problem from a non-experimented programmer in a multi
user environment:
I have a database MasterAchat which contains a linked

How do you print a list of the field names in a table in
Access 2000?

Using access 2000
How does one create a table link (to a table in another
access database) that is read/append only?
Here's what I'm trying to do. We need to enforce data

My issue is this:  My office uses Access 97 and I have
designed an application that uses an Access 97 front end
to execute inserts and updates through an ODBC link to
Oracle tables on the back end.  Recently, some of our

When upsizing an access database to SQL 2000 the Yes/No
column moves to a Bit type field,  But micorsoft has a
problem with this.
The forms that try to update data in a Table/Query with

I've got two tables; t_ORDER and t_QUOTE.
I want to relate the primary key of t_QUOTE to the primary
key of t_ORDER in a one-to-one relationship.
The tricky part is that there can be a quote ID, but not a

I just purchased a Laptop,and I'm trying to transfer my
database data from my home computer to my laptop....they
both have access 2000.Please help

In my application, I have some external excel worksheets that are
attached (linked) to my database and they work very well.
I have set up the links as "path\filename.xls" (where path is the
directorory containing both the .mdb application and the excel files)

Im trying to get a field in an access table to hold
percentages.
In the design, I have set the data type to number and the
format to percentage.

Is it possible to delete an entry that I added to the
Input Mask Wizard list? If so, how?
Thanks
Claire

I made the mistake of using "Date" as one of the field names in a
table I use to track attendance. Can I rename that field in the table,
and then have it automatically changed everywhere else that field is
referenced, in the forms, querys and reports? How do I do this simply

I have created a database with numerous tables.  At the
present time, there are no links between tables.  There
are no forms.  There are no queries.  I can go to Design
view on all tables but one.  On that table I get the

i had to create a database and then find my record and
the related transactions...access says the screen i
created cannot be used to add a brand new member to the
database, but it can be used to add new expense records

Acc2K
I have a lookup table and want to limit the possible records to <=10
entries.
How/where would i code the table to set this limitation?