Changing enddate on price file

[Zbob]

Anyone know how to change the end date in the price tables, It is a primary key and cannot be changed with access. We need some changed by Item and others by Customer.

The users do not want to change manually.

Thanks

 

[vbajock]

If you know how to use Access with Macola and are confident in your skills:

Have users exit Macola

Back up the Macola file.

Use a Make table query in Access to make an exact copy of the Macola file as an Access table. Visually check the Macola file and the Access table to make sure the record counts are exactly the same.

Initialize the Macola file in System manager, which will delete all the data from the file, leaving you with an empty structure.

Make your changes to the Access clone table using Update queries.

When done, do an Append query in Access, using the Access table as the source and the empty Macola table as the target. When finished check record counts.
Test it.

If you have any problems, restore the backup. If you get any errors doing the Append, restore the backup.
If this fails, there are a number of utilities out there you can buy to do the job.

 

[MacolaHelp]

Macola added a utility on the OE processes menu to extend the end date of price codes. You do, however, need to have a consistent prior end date on the codes you want to change. Barring that, I often use ultraedit, a $50 utility to export the file to text, select & update ranges in the text file (which doesn't care about the index keys that Access & the pervasive SQL manager do care about). Then import the file in again after initializing & you are off to the races.