VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Resetting categories and products
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

savage943
Starting Member

USA
26 Posts

Posted - June 09 2006 :  06:59:56  Show Profile  Visit savage943's Homepage  Reply with Quote
I would like to reset both of these to 1, however, they both insist on going to the next number in the sequence. With the package came 61 products and 19 categories. I deleted them all and then added a new category and product. The new category is 19 and the product is 62. Have run the convertcategories.asp and convertproducts.asp, but still the same results.

devshb
Senior Member

United Kingdom
1898 Posts

Posted - June 09 2006 :  07:29:58  Show Profile  Visit devshb's Homepage  Reply with Quote
strange coincidence, I just posted something relevant on a previous message:

http://vpasp.com/virtprog/vpaspforum/topic.asp?TOPIC_ID=5234

(make sure you delete your prodcategories records first)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

savage943
Starting Member

USA
26 Posts

Posted - June 09 2006 :  08:10:11  Show Profile  Visit savage943's Homepage  Reply with Quote
I am using the access database, not mysql or sqlserver. I do appreciate the help though. Have removed all of the category records and product records, then run the converts and still get the same.
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - June 09 2006 :  09:10:59  Show Profile  Visit devshb's Homepage  Reply with Quote
try doing a compact+repair on it (I'm not sure if that'll do the trick, but it's worth a try)

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

savage943
Starting Member

USA
26 Posts

Posted - June 09 2006 :  11:11:03  Show Profile  Visit savage943's Homepage  Reply with Quote
Access won't do that as there is no description. Back to the drawing board.
Go to Top of Page

dwight
VP-ASP New User

USA
143 Posts

Posted - September 03 2006 :  19:57:10  Show Profile  Reply with Quote
I have version 6.0 and have the same question If someone could help with this.
Go to Top of Page

support
Administrator

4266 Posts

Posted - September 03 2006 :  23:16:37  Show Profile  Visit support's Homepage  Reply with Quote
If you delete all records from the required table in Access and then run the compact and repair it will reset the auto numbers back to 0.

Alternatively open Access and select the table with your mouse.

Right click and select Cut

Now Paste and enter the name of the table.

Do not select to bring across data.

You will now have an empty table with all fields retined.

Thanks
Cam

VP-ASP Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000