Access

Resolved · Low Priority · Version 2003

Tue 3 Mar 2009, 16:08 Delegate Andrew said...

Andrew has attended:
Access Intermediate course

Access

why is the sky blue some days and not blue on others even though there appears to be no clouds?!
Okay for real now:
Why is it so important to cascade delete update records, would this not be inappropriate when dealing with health records - please elaborate and explain some rules for application of table linkage?!

Thu 5 Mar 2009, 15:46 Trainer Simon said...

RE: Access

Hi Andrew,

Thank you for your question.

It is an option when you are linking tables but the case you talk about it, it would not be appropriate as you would want to keep the data.

It may be more appropriate to archive the old data rather than using cascade delete related records.

This option should possibly only be used by Senior Developers or Managers when there is no need to keep the old data.

I hope this answers your question.

Regards

Simon

Thu 12 Mar 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips