Creating UAT db from existing production db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i'm new to this so will try and be as descriptive and clear as poss. At
work we use Access 2000, to log jobs, the front end is a form, back end are
the tables, and we can run queries/reports. There is no UAT copy of this only
the live db, and we have new reports to write but for obvious reasons want to
do this in a test environment first. I've read about replication and
synchronization, not sure this is the solution as do not want to corrupt live
db and doesn't require synchronizing.
Is it as simple as doing a file > save as?
Any idea?
 
Since from the sounds of it, you've already got the application split into a
front-end and a back-end, all you have to do is replace everyone's copy of
the front-end with the new front-end.
 
Doug,
Thanks for taking the time to respond.
To clarify, this db is a shared network one.
How do i take a copy of the front-end to work on?
Then how do i move it back and save over original?
Thank u
 
You should not be sharing databases. Each user should have his/her own copy
of the front-end, ideally on his/her hard drive.

Sharing a front-end increases the risk of database corruption significantly.
Having the front-end on the server increases network traffic.

If you're concerned about making sure everyone is using the most currently
version of the front-end, see the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

That having been said, just wait until no one's using the current front-end,
and make a copy of it. You can tell if anyone's using it by whether or not
the locking file exists in the same folder as the database itself. (The
locking file has the same name as the database, but with an extension of
..ldb rather than .mdb)
 
claire said:
Hi, i'm new to this so will try and be as descriptive and clear as poss. At
work we use Access 2000, to log jobs, the front end is a form, back end are
the tables, and we can run queries/reports. There is no UAT copy of this only
the live db, and we have new reports to write but for obvious reasons want to
do this in a test environment first.
Click to expand...

What does UAT mean?
I've read about replication and
synchronization, not sure this is the solution as do not want to corrupt live
db and doesn't require synchronizing.
Click to expand...

No, synchronizing is for tables, index definitions and records. It is
*not* meant for the front end objects, such as queries, forms, reports
and modules.

Doug has given you the correct answer on how to handle things. I just
though I'd clarify a few things.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing ODBC Data Source for linked tables 4
Repair a front end DB from another DB 6
Start DB when not connected to network 2
Access 2007 Split Assets db, issue moving to new directory 0
Problem openning DB 1
ACCESS PErmissions Issues 6
replication - FE/BE 2
PLS HELP - Access DB Has slowed right down 5

Back
Top