Recent content by Woolfcom

will have a go and let you know.....

In which case, how do I go about altering the field with its existing 1- 500 numbering? Given my novice abillities, is there an simple command I would use to change the existing sequence.....I believe this is the primary key and apllicable only to the one table. w

Its not tied.....I just want it that way....to suit my own requirements egL instead of 1 - 500 i'd like to alter it to : 10001152 to 10001652 etc An alternative would be to see the output string refelcting this pattern. dyou see? w

I have noticed from the years of spamming, there are indeed plentry of gaps. My primary concern is that the numbers increment from my targetted start point. ta w

Noted.....its a fairly simple database structure and the numbering applies to one table only.....am fairly ceratin that there are no cross linking. Howver, I do take your point on board. The record I want to use needs to match an accounting standard...hence needing to re-number. w

The reason for the spam, is that there was no apt CAPTCHA script on the data form in place until recently. This has been fixed. The autonumbers start at 1, I would like to start at 10001152 [and then increment from there] for our records. I should say that I have never looked at much less...

After playing around with the tables aimlessly. I performed a compact and repair. For reasons I have yet to fathom I was then able to delete the offending records manually without the inital error message appearing! Furthermore, the process compacted the database from over 2 gigs to 700k...

Thanks Stopher, Back up done Not sure what you mean by "back" and "Front" end [data and forms maybe?]. Its a fairly simple contruct. For simplicity in identifying the spam, I have grouped the good records like 1 - 500 [say]. The spam is 501 to 350,000 [I kid u not]. I assume that this renders a...

The Access database for my site was hi-jacked by spammers and is now full of enormous amounst of unwanted records. I have tried to maually remove all the spam. There remains a large amount of data to delete, which through up an error message: "The search key was not found in any records."...