Upgrading application

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

Guest

I used to work on site enhancing the live database application. Now that I'm
working off-site, how do I implement enhancements into a live database
without clobbering the data additions which have happened since I took a copy
of the mdb file? What's the most efficient way to maintain a live database.
Please let me know.
 
You would need to split the database. The backend should contain your
tables and data. The front-end would contain the forms, queries, and
reports and would be linked to the back-end. You would keep a master copy
of the front-end and when changes were made, you'd distribute the new file
to your users.

Rick B
 
How do I split the database? How do I link the forms,queries, and reports to
the backend? Thanks!
-Howard

Rick B said:
You would need to split the database. The backend should contain your
tables and data. The front-end would contain the forms, queries, and
reports and would be linked to the back-end. You would keep a master copy
of the front-end and when changes were made, you'd distribute the new file
to your users.

Rick B
Click to expand...
 
On the main menu bar select Tools and look down the list for Add-Ins.
Select Database Splitter. This will create another database with all
of your tables. Say for example your database is named Customers your
should consider naming the new database CustomersData. Now you have a
main and data of your app. Checking your table should now show an
arrow next to all tables that are linked to the data database.

Hope this helps.

How do I split the database? How do I link the forms,queries, and reports to
the backend? Thanks!
-Howard
Click to expand...
 
Back
Top