Creating a database with an existing Database

[118600]

Hi,

I am new user for Access database programming stuff. My objective is to develop a secondry database out of main Database by taking out 4 to 5 tables to build a new secondry database.
I have to link this secondry database with the main database. it did it ( by File ---> get external data and then to Link tables.. )

My question is that after creating it if there will be any change in the main database it must be indicated ( by font change or color )in the secondry database.

anyone have a clue about it.

Thanks

 

[smandoli9]

Well done on the secondary DB. Now be aware this is not relevant to your need. If I see it right, even if it were still one database, you would need this indicator for "changed" or "recently changed." Remember, a linked table is the same as a native table for all your purposes.

Which is it? If it's "recently changed," you should provide a datestamp on the table that is updated whenever the record is changed. Then query to include "changed within the last 30 days" or whatever.

If it's "changed", period, then the date field would still work. Alternatives would be available: use a Yes/No field, which is simpler, or keep a copy of the table as originally populated and run a comparison.

A note about font and color: For visual cues, your options are many when using single forms. Continuous forms don't allow you to toggle the appearance. Yet there are code workarounds for that.

[purple]_______________________________
_{Never confuse movement with action -- E. Hemingway} [/purple]

 

[118600]

Thanks for your reply,

The main database is changing each day so it means its "recently changed" I have a secondry database linked with the main database. There are some fields in the secondry database/main database like serial number, order number, items details and done/not done, i have to keep record of each change in them. These fields are in one table.

I have to show each day change in my secondry database.
There is no date option in the main database.Actually, i want to avoid too much programming stuff here. is it possible to work on it by queries ? as u said by putting datastemp. Can you tell me how ?

I am working on Access 2000.If its gonna help you.

Looking forward to your kind reply.