Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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