I am more or less done with my design of a web where one page is a user
questionnaire. This form was designed in FP and is coupled to an Access
database. When testing the form I wrote some dummy entries to it while at the
same time some real users entered their data too.

So, I downloaded the database deleted my dummy entries and renumbered the
entries from 1 and up so there were no gaps where I had done my testing.

The form still works, but the counter keeps on numbering the entries as if
all entries were still there.

Where is this counter located and how can I reset it or set it to a desired
number?

Best,

Tomas

From FrontPage, Export the database to your desktop.
Open the (exported) database in Access, then Tools->Compact and Repair
Database.
In FrontPage, Import the compacted database, replacing the current copy.

The record counter is stored in a system table (not accessible to users) in
the database.

--
Ron Symonds (Microsoft MVP - FrontPage)
Reply only to group - emails will be deleted unread.


"Tomas" <(E-Mail Removed)> wrote in message
news:373F9C55-7D0A-4797-B557-(E-Mail Removed)...
>I am more or less done with my design of a web where one page is a user
> questionnaire. This form was designed in FP and is coupled to an Access
> database. When testing the form I wrote some dummy entries to it while at
> the
> same time some real users entered their data too.
>
> So, I downloaded the database deleted my dummy entries and renumbered the
> entries from 1 and up so there were no gaps where I had done my testing.
>
> The form still works, but the counter keeps on numbering the entries as if
> all entries were still there.
>
> Where is this counter located and how can I reset it or set it to a
> desired
> number?
>
> Best,
>
> Tomas

Compacting does not reset any autonumbers
(if that is what he is referring to)
The only way to reset autonumber fields in Access is to either
- delete the autonumber field, and all records, compact the DB and recreate the field
- make a copy of the table - structure only if you want it empty
(then delete the original table and rename the copy to the original table name)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Ronx" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| From FrontPage, Export the database to your desktop.
| Open the (exported) database in Access, then Tools->Compact and Repair
| Database.
| In FrontPage, Import the compacted database, replacing the current copy.
|
| The record counter is stored in a system table (not accessible to users) in
| the database.
|
| --
| Ron Symonds (Microsoft MVP - FrontPage)
| Reply only to group - emails will be deleted unread.
|
|
| "Tomas" <(E-Mail Removed)> wrote in message
| news:373F9C55-7D0A-4797-B557-(E-Mail Removed)...
| >I am more or less done with my design of a web where one page is a user
| > questionnaire. This form was designed in FP and is coupled to an Access
| > database. When testing the form I wrote some dummy entries to it while at
| > the
| > same time some real users entered their data too.
| >
| > So, I downloaded the database deleted my dummy entries and renumbered the
| > entries from 1 and up so there were no gaps where I had done my testing.
| >
| > The form still works, but the counter keeps on numbering the entries as if
| > all entries were still there.
| >
| > Where is this counter located and how can I reset it or set it to a
| > desired
| > number?
| >
| > Best,
| >
| > Tomas
|
|

Thank you both. I'll try it.

Best,

Tomas

"Stefan B Rusynko" skrev:

> Compacting does not reset any autonumbers
> (if that is what he is referring to)
> The only way to reset autonumber fields in Access is to either
> - delete the autonumber field, and all records, compact the DB and recreate the field
> - make a copy of the table - structure only if you want it empty
> (then delete the original table and rename the copy to the original table name)
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Ronx" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> | From FrontPage, Export the database to your desktop.
> | Open the (exported) database in Access, then Tools->Compact and Repair
> | Database.
> | In FrontPage, Import the compacted database, replacing the current copy.
> |
> | The record counter is stored in a system table (not accessible to users) in
> | the database.
> |
> | --
> | Ron Symonds (Microsoft MVP - FrontPage)
> | Reply only to group - emails will be deleted unread.
> |
> |
> | "Tomas" <(E-Mail Removed)> wrote in message
> | news:373F9C55-7D0A-4797-B557-(E-Mail Removed)...
> | >I am more or less done with my design of a web where one page is a user
> | > questionnaire. This form was designed in FP and is coupled to an Access
> | > database. When testing the form I wrote some dummy entries to it while at
> | > the
> | > same time some real users entered their data too.
> | >
> | > So, I downloaded the database deleted my dummy entries and renumbered the
> | > entries from 1 and up so there were no gaps where I had done my testing.
> | >
> | > The form still works, but the counter keeps on numbering the entries as if
> | > all entries were still there.
> | >
> | > Where is this counter located and how can I reset it or set it to a
> | > desired
> | > number?
> | >
> | > Best,
> | >
> | > Tomas
> |
> |
>
>
>

From Access help:

Compacting has no effect on autonumbering in an Access project. However, in
an Access database, if you have deleted records from the end of a table that
has an AutoNumber field, compacting the database resets the AutoNumber
value; the AutoNumber value of the next record you add will be one greater
than the AutoNumber value of the last undeleted record in the table.


In practice, if you empty the table and compact the database, the first
record entered will have autonumber 1. If you do not empty the table, the
counter may be reset as the help says, or not - seems quirky.

--
Ron Symonds (Microsoft MVP - FrontPage)
Reply only to group - emails will be deleted unread.


"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:%23F%(E-Mail Removed)...
> Compacting does not reset any autonumbers
> (if that is what he is referring to)
> The only way to reset autonumber fields in Access is to either
> - delete the autonumber field, and all records, compact the DB and
> recreate the field
> - make a copy of the table - structure only if you want it empty
> (then delete the original table and rename the copy to the original table
> name)
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Ronx" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | From FrontPage, Export the database to your desktop.
> | Open the (exported) database in Access, then Tools->Compact and Repair
> | Database.
> | In FrontPage, Import the compacted database, replacing the current copy.
> |
> | The record counter is stored in a system table (not accessible to users)
> in
> | the database.
> |
> | --
> | Ron Symonds (Microsoft MVP - FrontPage)
> | Reply only to group - emails will be deleted unread.
> |
> |
> | "Tomas" <(E-Mail Removed)> wrote in message
> | news:373F9C55-7D0A-4797-B557-(E-Mail Removed)...
> | >I am more or less done with my design of a web where one page is a user
> | > questionnaire. This form was designed in FP and is coupled to an
> Access
> | > database. When testing the form I wrote some dummy entries to it while
> at
> | > the
> | > same time some real users entered their data too.
> | >
> | > So, I downloaded the database deleted my dummy entries and renumbered
> the
> | > entries from 1 and up so there were no gaps where I had done my
> testing.
> | >
> | > The form still works, but the counter keeps on numbering the entries
> as if
> | > all entries were still there.
> | >
> | > Where is this counter located and how can I reset it or set it to a
> | > desired
> | > number?
> | >
> | > Best,
> | >
> | > Tomas
> |
> |
>
>

Finally got it to work. Thanks!

This is how you do it:

1. Delete unnecessary records
2. Remove the counter field and save
3. Inser counter field with a new name and save
4. Rename to original name and save
5. Tools > compact and repair database
6. Upload

Best,

Tomas

"Ronx" skrev:

> From Access help:
>
> Compacting has no effect on autonumbering in an Access project. However, in
> an Access database, if you have deleted records from the end of a table that
> has an AutoNumber field, compacting the database resets the AutoNumber
> value; the AutoNumber value of the next record you add will be one greater
> than the AutoNumber value of the last undeleted record in the table.
>
>
> In practice, if you empty the table and compact the database, the first
> record entered will have autonumber 1. If you do not empty the table, the
> counter may be reset as the help says, or not - seems quirky.
>
> --
> Ron Symonds (Microsoft MVP - FrontPage)
> Reply only to group - emails will be deleted unread.
>
>
> "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> news:%23F%(E-Mail Removed)...
> > Compacting does not reset any autonumbers
> > (if that is what he is referring to)
> > The only way to reset autonumber fields in Access is to either
> > - delete the autonumber field, and all records, compact the DB and
> > recreate the field
> > - make a copy of the table - structure only if you want it empty
> > (then delete the original table and rename the copy to the original table
> > name)
> >
> > --
> >
> > _____________________________________________
> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> > "Warning - Using the F1 Key will not break anything!" (-;
> > To find the best Newsgroup for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > _____________________________________________
> >
> >
> > "Ronx" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > | From FrontPage, Export the database to your desktop.
> > | Open the (exported) database in Access, then Tools->Compact and Repair
> > | Database.
> > | In FrontPage, Import the compacted database, replacing the current copy.
> > |
> > | The record counter is stored in a system table (not accessible to users)
> > in
> > | the database.
> > |
> > | --
> > | Ron Symonds (Microsoft MVP - FrontPage)
> > | Reply only to group - emails will be deleted unread.
> > |
> > |
> > | "Tomas" <(E-Mail Removed)> wrote in message
> > | news:373F9C55-7D0A-4797-B557-(E-Mail Removed)...
> > | >I am more or less done with my design of a web where one page is a user
> > | > questionnaire. This form was designed in FP and is coupled to an
> > Access
> > | > database. When testing the form I wrote some dummy entries to it while
> > at
> > | > the
> > | > same time some real users entered their data too.
> > | >
> > | > So, I downloaded the database deleted my dummy entries and renumbered
> > the
> > | > entries from 1 and up so there were no gaps where I had done my
> > testing.
> > | >
> > | > The form still works, but the counter keeps on numbering the entries
> > as if
> > | > all entries were still there.
> > | >
> > | > Where is this counter located and how can I reset it or set it to a
> > | > desired
> > | > number?
> > | >
> > | > Best,
> > | >
> > | > Tomas
> > |
> > |
> >
> >
>
>
>