Modifying a front end datatbase

J

JoeA2006

When modifying the front end of a split database, can I test it without
affecting the live data base since it is referencing the live file
 
B

Brendan Reynolds

Make a copy of the back end data file, and use the linked table manager (on
the Database Utilities sub-menu of the Tools menu) to link your front end
application file to the copy.
 
J

Jeff Boyce

Define "test"...

Any front-end (production or test) that points to the data will be able to
affect the data.

If you need to manipulate data with your test front-end, build yourself a
test back-end and re-reference.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 

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

Top