• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

Append query Split Database Ms access

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
TonyMannella
Asked:
TonyMannella
  • 3
  • 3
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>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
 
TonyMannellaAuthor Commented:
Ok Let me try on Monday and will let you know how I make out
0
 
TonyMannellaAuthor Commented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Did my comment help?  'Let me try on Monday and get back to you' isn't exactly a valid solution.
0
 
TonyMannellaAuthor Commented:
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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Ok.  Thanks for the grade.  Good luck with your project.  -Jim
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

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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