Insert table into backend database

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?
LVL 1
wipnavAsked:
Who is Participating?
 
omgangIT ManagerCommented:
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
 
omgangIT ManagerCommented:
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
 
wipnavAuthor Commented:
Cool, thanks. Any idea about the indices?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
omgangIT ManagerCommented:
I'm not sure but I think the answer is yes.  Will need to do some checking.
OM Gang
0
 
omgangIT ManagerCommented:
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
 
wipnavAuthor Commented:
Great answers! Thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.