I opened an access database for the first time in access 2007.  It opened
read only.  If I wanted to make design changes I should save a copy and work
on that.  This is really irritating.  I also see no way of determining the
key index and setting the type for a field in a table ...

I'm looking to see if someone can tell me how to write a module that
will import csv files into a table.
The file names ALL have the word containing  TRKR and they are labeled
differently.

Without having to buy a book, does microsoft have an introduction to access
2007?
Thankis folks.
dennist

I used the term connections instead of relationships, hoping to avoid
relational database confusion.
I have an Animal Records table that has unique IDs for each animal.  I want
to create an Animal Relationships table that will track the type of

I have an Excel spreadsheet with five numerical columns.
I need to link it to an Access table. When I do that three fields
finish as numeric and two as text and subsequent operations within
Access report violations.

I have imported data from Excel into an Access database. Even though I have
changed the data type from "text" to "memo" / insured that the "can grow" is
selected my data is still truncating in my report. What am I doing wrong?

i created a combo box with row source type Table /Query, Row Source SELECT
[CustomerTbl].[CUSTOMERID], [CustomerTbl].[CustomerName] FROM [CustomerTbl];
thats the query i saved the form but when i open in view and try to type it
shows error

Dear Sir / Madam,
I have a Domain Controller 2003 Server and aroun 50 XP Clients.
I want to do on XP Clients, Domain users have only read access of hard
disk drive.

I have a text field with both letters & numbers.  I know how to eliminate
the letters, leaving only the numbers.  This string of numbers has a group
of leading zeros.  My question is:  After eliminating the letters, how can I
create a Make Table query to convert this field into a ...

Can someone help me please, I am doing a course on Access Database, my
homework is to set up columns and sort out in alphabetical order and deleting
information and the last two question I have is to sort out the items after a
certain year and there are about 10 different years ...

Stupid question I know, but what it the difference between the two. When
would I use a combo box, when would I use a list box?
Regards
Juparo

I have a database with several forms being loaded from a Main Menu.  I
created the command buttons using the tool box.  When I open a form I
generally like to close the first one (don't know why) but there appears to
be a slight delay occuring between closing the main menu and ...

I have spent many hours trying to create a form. I have created Forms that
are read only and others that flat out dont work. What I am trying to do is
create a form that updates 1 table but relates information from 2 other
tables(Customer Table and Asset Table into an Event Table). ...

I have two tables in Access that i want to combine, but the issue is they
have unique columns with some shared columns that i need to combine so that
in the final product the shared columns combined and the unique comlumns
alined with them or "reconciled"

I am a beginner in Access!
I have created a form where i will be able to type in a value. When I press
enter, I want that value to check against another query and return any
matches associated with the original value. This function needs to be a