Good Morning:
Does anyone know a way to lengthen the maximum size of a
trext field. The default limit is 255 characters. I need
more like 500 or better. Any assistance would be greatly

Does anyone know how to change the column order of an access datababase (Access 2002) table using ADO. I am appending a column to an existing table (ALTER TABLE....). The new column is added at the end of the table. However, I would like to move the new column away from the ...

I have a date default value set as Year(Date()).  I want
it to only show the last two digits of the year in the
field.  Can this be accomplished?

Is there a way to use the function of a module I create as the default
value of a field in a table?
Any help is greatly appreciated. Thank you in advance.
cheers,

I'm designing a database in Access 97 to track attendance
for the year.  The table will contain a field for the
members and 52 fields for the each week of the year.  From
time to time I'd like to be able to get percentages of

Is there a way that you can digitally sign a database that you have created so that it shows who created it without someone going in and changing that info
Thanks
John

I'd like to construct a database for my church cell groups
with Access 97.  We have district leaders over coaches,
which are over the cell group leaders.  The database would
also chart attendance.  I'd like it designed so that the

I am designing a database of people.  Is there a way to
make both first and last names primary keys?
Thanks,
Ellen

when ever someone logs into my database, and another person tries to access the same database in the same location, it displays "COULD NOT LOCK FILE"
I have split the database, and that doesn't seem to work. I have had to resort to setting up different folders for each individual ...

I’d like to create a database that will, among other things, track the location of inventory.  So far I have three tables as follows:
Table 1 – Location   
LocationID (Primary Key)
Location    (Lookup Field of Warehouse; Regional Office; District; or Employee)

I have an interoffice memo table with the first record starting at 001 (primary key).  I need to start over at 001 for 2004 without creating a separate table for 2004.  Would a multi field primary key consisting of the year (03 or 04) and the record number 001, 002, 003 make ...

I've been asked to design a db to track safety inspection
results.  Some of the information will be fairly
consistent (POC, Building, phone, code and description of
hazards) I can figure out how to set up tables for these.

Can triggers be developed against tables in Access 2000?
seeker52

I am trying to create a database that will track tasks
that my boss has with his secretary throughout the day.  I
am having trouble with creating the relationships with the
tables (I think, maybe im way off!).  Here is the design

I am in need to replicate an MS-Word "Outline" structure in MS-Access.
The below is a sample structure that I need to create and be able to
automatically update.
1