Solved

Insert table into backend database

Posted on 2011-02-17
6
276 Views
Last Modified: 2012-05-11
I have an Access application that is split in a front end/back end configuration. Before a particularly large update procedure is called, I would like to save a copy of one of the back end tables in case the user input the incorrect parameters and the table needs to be restored to the previous version.

My question is: Is it possible to insert the table into the back end file from the front end?

*Bonus question: How does Access handle index fragmentation? Does Access rebuild the indices during a compact and repair?
0
Comment
Question by:wipnav
  • 4
  • 2
6 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 34916531
Create a make table query in your front-end database.  During the process you'll see the option to create the query in another db (current db is default).
OM Gang
0
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 34916535
Sorry, should have been
 During the process you'll see the option to create the table in another db (current db is default).
OM Gang
0
 
LVL 1

Author Comment

by:wipnav
ID: 34917213
Cool, thanks. Any idea about the indices?
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 28

Expert Comment

by:omgang
ID: 34917508
I'm not sure but I think the answer is yes.  Will need to do some checking.
OM Gang
0
 
LVL 28

Expert Comment

by:omgang
ID: 34917690
Here's some info
http://support.microsoft.com/kb/209769/EN-US/

Note the response in this forum Q that states indexes can be rebuilt in Access but there is often no need to do so because compacting does this anyway.  Seems to answer your question
http://msgroups.net/microsoft.public.access/Rebuilding-Table-Indexes

OM Gang
0
 
LVL 1

Author Closing Comment

by:wipnav
ID: 34918188
Great answers! Thanks for your help!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now