Exceeing 100 field limit with Data Tracking wizard

I' ve created a form and am using the Template Wizard to create the database
for data tracking. However, there is a 100 field limit to the Template
Wizard. Does anyone know how to bypass that 100 field limit or how the links
to the database are established so I can create the additional fields needed
for tracking all areas of the form over field 100.
--
Thanks for your help in advance...

Laura

What do you mean 100 record limit?
I have databases with many times this and use it daily!

Cheers

John
"Laura" wrote in message
...
I' ve created a form and am using the Template Wizard to create the
database
for data tracking. However, there is a 100 field limit to the Template
Wizard. Does anyone know how to bypass that 100 field limit or how the
links
to the database are established so I can create the additional fields
needed
for tracking all areas of the form over field 100.
--
Thanks for your help in advance...

What do you mean 100 record limit? actually Laura said that she was having an issue with the 100 *FIELD*
limit

and of course that prompts the question :

Laura - why are you creating a db that would contain so many fields ???


it's probably a good time to plan/configure your db better (or you will
be sorry for not doing so at a later date).


---
Message posted from http://www.ExcelForum.com/

Yr right Tommy
Tired eyes and a willingness to help is not a good combination!

I will now go and beat myself with a dead fish until I learn to read.

Cheers

John

"tommy03 " wrote in message
...
What do you mean 100 record limit? actually Laura said that she was
having an issue with the 100 *FIELD*
limit

and of course that prompts the question :

Laura - why are you creating a db that would contain so many fields ???


it's probably a good time to plan/configure your db better (or you will
be sorry for not doing so at a later date).


---
Message posted from http://www.ExcelForum.com/

Thanks for your suggestion, Tommy. The database isn't for me. I tried to
talk this person into an Access db, but no go. And while that is a possible
option for the future, it is not the case right now.

In thinking about this, I'm wondering if I can create a second "dB" and then
copy the fields to the 1st database.
Thanks,
Laura

"tommy03 " wrote:

What do you mean 100 record limit? actually Laura said that she was having an issue with the 100 *FIELD*
limit

and of course that prompts the question :

Laura - why are you creating a db that would contain so many fields ???


it's probably a good time to plan/configure your db better (or you will
be sorry for not doing so at a later date).


---
Message posted from http://www.ExcelForum.com/

I have actually found the solution to my initial problem. So I'm posting
this for reference for others. Create the database using the template wizard
with data tracking. Open the database file and insert and name additional
sheets. The 100 field limit applies only to each individual sheet. The more
sheets you have, the more fields you can utilize. Close the database file
and reopen the template you have created previously. Now, re-open the
template wizard (this is one of the few wizards you can go back into with MS
Office apps). Repoint the database to the database file where you have added
the new sheets. Now, when you get into Step 3 of the template wizard, use
the drop down list to select the sheets where you want to add additional
fields.

Although this isn't the best way to create a database, I realize there are
lots of people out there who do not have Access installed or who are just
more comfortable with Excel.

Good luck.

"Laura" wrote:

Thanks for your suggestion, Tommy. The database isn't for me. I tried to
talk this person into an Access db, but no go. And while that is a possible
option for the future, it is not the case right now.

In thinking about this, I'm wondering if I can create a second "dB" and then
copy the fields to the 1st database.
Thanks,
Laura

"tommy03 " wrote:

What do you mean 100 record limit? actually Laura said that she was having an issue with the 100 *FIELD*
limit

and of course that prompts the question :

Laura - why are you creating a db that would contain so many fields ???


it's probably a good time to plan/configure your db better (or you will
be sorry for not doing so at a later date).


---
Message posted from http://www.ExcelForum.com/