Append query Split Database Ms access

Posted on 2013-02-01
Last Modified: 2014-01-29

I have a split (FE and BE) databse.  I want to run an append query to append to an exisitng table.  The question is:  Do I run the query in the FE or BE and then relink the table?
Question by:TonyMannella
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 65

Accepted Solution

Jim Horn earned 500 total points
ID: 38845494
>Do I run the query in the FE or BE
Either one works.  Usually this is done in the FE, and the BE is only the tables and relationships.

>and then relink the table?
No, as the table will stay linked regardless of the select-insert-update-delete activity on it.

Author Comment

ID: 38845503
Ok Let me try on Monday and will let you know how I make out

Author Comment

ID: 39817904
I've requested that this question be closed as follows:

Accepted answer: 0 points for TonyMannella's comment #a38845503

for the following reason:

Worked Perfectly
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LVL 65

Expert Comment

by:Jim Horn
ID: 39817905
Did my comment help?  'Let me try on Monday and get back to you' isn't exactly a valid solution.

Author Comment

ID: 39818792
I saw I never responded so I tried to respond and give you credit, but I think I completed the form incorrectly.  Your comment worked perfectly so I just wanted to give you credit for the solution and mark it as accepted.
LVL 65

Expert Comment

by:Jim Horn
ID: 39818801
Ok.  Thanks for the grade.  Good luck with your project.  -Jim

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

726 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