CJWSoft Support Info: Groups

Active Info

Memberlist

Help

ASPProtect Full 7.x Support ( Info Locked)
CJWSoft Support Info : ASPProtect Full 7.x Support

Info: Groups

Author

Message

<< Prev Info | Next Info >>

henkej
New User

Joined: July/18/2007
Location: United States
Online Status: Offline
Info: 1

Added: July/18/2007 at 8:28pm \| IP Logged

Hi,

I have been using ASPProtect for about 6 months and I am now beginning to experiment with Groups. Just for fun, I added a "test group", did some testing, and then deleted the group so that no groups were listed.

When I went back to add my first "real group", the ID was set to #2. I deleted this group (i.e. back to no groups listed) - logged out of Admin and back in - and tried entering my first "real group" and the ID incremented to #3.

My question: Is there any way to reset the Group count back to zero if all groups are deleted? I realize it's just numbers - but - for ease of use and referencing - I would like to start over with my first group entry using ID #1.

Thanks!

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: July/18/2007 at 9:55pm \| IP Logged

I assume your using msacces.

It's because of the way autonumber fields work in MSACCESS. You see the database is making up those numbers and with MSACCESS the auto-numbers dont get re-used.

You can try opening up the database in MSACCESS, make sure the groups are empty, and do a compact and repair.. that may reset the autonumber count

if that doesn't reset the count when you add a new group then removing the groups table completely and then re-adding it with the same exact settings will definetely get the count reset.

Now, if you were using a SQL Server Database I don't think you would have to go through all that but it's just because SQL works differently.

__________________

Best Regards, Christopher Williams www.CJWSoft.com

Sorry, you can NOT post info.
This info has been locked by a info administrator.

Printable version

Info Jump

You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area