Is there a club membership management template for Access?

I created a database on a corporate server with 20 users,
4 tables, 30 forms (that contains simple code) and 20
queries.  Size prior to split is 14 MB.  After the split
FE is 14MB and BE is 11 MB.  Hopefully, I am done with

The following code worked for a while and now I get an error:
Couldn't create; no modify design permission for table or query
Any Ideas.
Thanks in advance.

When i have multiple table links together, i make the link in the query
each time i need it.
I have a lot of query with different kind of relationship. They are
independant.

I'm trying to set up referential integrity between two
tables.  Here's what I have:
Table 1:
Primary key is made up of two fields:

I have a database that we use to track circuit status, to
this point we have been using it as a one to one
relationship.   Now we need to track what are
called "lowers" a circuit can have as many as 24 lower

I there any way to set a date field to allow incomplete dates?
Most of the dates I have would have a format like:
10-25-2004
But sometimes It could be missing information.

I have a Table and form for the entry of Bus Route costs
by route.  Now my boss wants to split up the entry by
departure city and arrival city. I have this table and
form already setup for Departure city (One-to-many)

I have a problem With Access, I have 1 combobox and 1
subform and I want to filter the objects in subform due to
combo choice, but I didn't know how start id because first
my combo have repeated index (such as 1997, 1997, 1997)

How do you create a header on a table?  Thanks in advance
SteveR7138@msn.com

My objective of this project is to have my co-workers,
who are not familiar with Access, to input data in Excel.
Meanwhile I will either establish a link or a macro to
transfer data to Access which, at the end will be picked

Am working in an Access tracking program at my office.  I have to go through
several levels to finally get to the cost information on a tabbed screen
behind the main screen.  I am able to view the design view of the main
screen, but not any of the tabbed screens behind this main ...

Two types of numbers.
First type:
I have a 20 digit number that will be scanned into the
database and it can store with or without spaces (I am

I have updated a text field with one of a memo field.  
There are entries that have been truncated.  Is there a
way to search for all fields with 255 characters?
Thank you in advance,

Here's the code to create a table "tblTest" and create two
fields (ID and Name).
I want to set the first field "ID" as Primairykey and also
set it as autonumber.