Modifying a front end datatbase

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

Guest

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
 
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.
 
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/
 
Back
Top