Solved

Append query Split Database Ms access

Posted on 2013-02-01
6
405 Views
Last Modified: 2014-01-29
Hi,

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?
0
Comment
Question by:TonyMannella
[X]
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
6 Comments
 
LVL 66

Accepted Solution

by:
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.
0
 

Author Comment

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

Author Comment

by:TonyMannella
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
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 66

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.
0
 

Author Comment

by:TonyMannella
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.
0
 
LVL 66

Expert Comment

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

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

717 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