Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a database with more than 500.000 records, I am using Table_a to Accessing the files by the ID number,Name, Date, Address, Tel, ..... And then I used Table_b to archive files and locate the position where should I keep that file, just by entering the ID.
Is there any way to update the Database to have it all in one action? I mean after Accessing the file, I should have a check box, or a drop drown list to move the record directly to the Archive at the same time?

share|improve this question
    
Your question does not supply enough information on the flow of your database. which files are you tring to archive? is archiving necessary? "Is there any way to update the Database to have it all in one action?" What do you exactly mean by this? –  CrashOverride May 30 '13 at 9:09
add comment

closed as unclear what you're asking by Mark Storey-Smith, Jon Seigel, Paul White, Mat, dezso Jul 31 '13 at 10:19

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

Your question is not clear but I want to give some suggestions about the errors:

1.you should use specific tables for archive and other details.

2.you should maintain specific DNS servers on ODBCcad for regular data and archive files.

these two points would certainly help you a lot.

share|improve this answer
add comment
  1. Your questions is a little foggy
  2. You don't mention how the archiving process works
  3. You're basically asking about a feature on the User Interface side ... not on the DB side.

In the first use case, you (or the application) do a select to retrieve some metadata about a file; In the second one, you enter an ID (select query) and the application does the archiving (insert statement into table_b);

What exactly do you need to automate here ?

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.