Exporting forms and other elements

  • Thread starter Thread starter Jerry M. Gartner
  • Start date Start date
J

Jerry M. Gartner

Greetings:

I have a development database and a live database. I add elements
(forms, table columns, etc.) to the dev database and test them. I'd like to
export the tested elements from the dev database and then import them into
the live database. What is the best way to go about this without breaking
anything in the live database? Thanks in advance.
 
Hi Jerry

The usual practice is to split your database in two: a "front-end" which
contains everything except the data (tables) and a "back-end" that contains
only the tables. You then link the tables in the back-end (BE) to the
front-end (FE), so that all your queries, forms, etc work as before.

Now you can use a copy of the BE for development and testing and, when you
want to put a modified FE into production, you simply copy and replace the
entire file and link it to the tables in the production BE.
 

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

Best third-party tool to repair OST files 2
Access 2007 Split Assets db, issue moving to new directory 0
Exporting / Importing forms and tables 2
Copy Relationships between databases 3
Migrate updates from developement to production DB 2
Replacing a Table with a Table from another database - reference issues 1
Why don't my table folders display in expression elements? 2
TimeSpan Data elements 3

Back
Top