Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

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?
0
wipnav
Asked:
wipnav
  • 4
  • 2
1 Solution
 
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
 
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
 
wipnavAuthor Commented:
Cool, thanks. Any idea about the indices?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now