Re: [MSAccessProfessionals] Sandbox environment

Hi Jane

 

Coming up with a test database after a live database is in use can be very tricky.

First off, you will need data that is not live. That is something you will have to deal with. My applications always start out with test data as I develop so I can easily present that data to testers if required, but having to create new test data on the fly is tedious at best. Can the live data be altered enough to point primary keys to fake entities?

Secondly, you will need to build a front end that is linked to the test database and restricted to users doing the testing.

 

I hope this gives you some idea as to where to start.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jane via groups.io
Sent: Monday, April 22, 2024 11:51 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Sandbox environment

 

Hi all
I've been asked to create a sandbox environment for an existing database, so that another company can go through it & try out some scenarios, not on live data. 
I understood that you usually create a Windows sandbox on your own PC for development work, but that it's not something that you share. Am I hopelessly out of date / my depth? :-)
Any advice/help gratefully accepted.
Thanks
Jane