Randomize existing data

ZaveR
NewLounger
Posts: 17
Joined: 17 Apr 2011, 15:36

Randomize existing data

Post by ZaveR »

I remember seeing years ago a tool to take existing data in a back end and randomly change it so you can use it as a sample database. I tried finding it recently, but wasa unable to. Can anyone help?
Thanks
Thanks
Zave Rudman

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Randomize existing data

Post by Rudi »

ZaveR wrote:I remember seeing years ago a tool to take existing data in a back end and randomly change it so you can use it as a sample database. I tried finding it recently, but wasa unable to. Can anyone help?
Thanks
There are a number of free online data generators and some paid versions to create data for databases (and other sources). I am not aware of being able to generate sample data from existing info in a back end, (AFAIK).
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Randomize existing data

Post by HansV »

Access MVP Mark Davis (aka CyberCow) has posted some code and a sample file on UtterAccess: Data Anonymous (Scramble That Data) III, Any Version. You have to be logged in as a member to download the sample file.
Best wishes,
Hans

ZaveR
NewLounger
Posts: 17
Joined: 17 Apr 2011, 15:36

Re: Randomize existing data

Post by ZaveR »

Good to be back, been off Access for a while
Thanks as usual Hans
Thanks
Zave Rudman

User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Randomize existing data

Post by HansV »

Nice to see you here again, Zave!
Best wishes,
Hans