[AccessD] 2 Questions

Stuart McLachlan stuart at lexacorp.com.pg
Tue Mar 9 15:46:34 CST 2010


Anyone who doesn't enforce relational integrity on a relational database is just asking for 
trouble.   Since the tool is there, why would anyone not use it?

-- 
Stuart

On 9 Mar 2010 at 22:31, Asger Blond wrote:

> 2. I use Tools | Relationship to create foreign key constraints ("enforce referential integrity"). Without foreign key constraints the data will soon loose consistency.
> 
> Asger
> 
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Max Wanadoo
> Sendt: 9. marts 2010 21:45
> Til: 'Access Developers discussion and problem solving'
> Emne: Re: [AccessD] 2 Questions
> 
> Tony:
> 
> 1. At the top of  the module put
> Option explict
> 
> Then compile it, all the unspecified variable will be picked up.
> 
> 
> 2. Me neither.  I seldom use relationship and much prefer to handle them in
> code.
> 
> Max
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Tuesday, March 09, 2010 7:25 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] 2 Questions
> 
> Hey All
> Just pondering
> 1. Access2003 does not seem to pick up erroneous variables.
> If on a form I assign for a control
> Dim JTnum as double
> then in code
> ..................
> I make a spelling error
> Jnum = rst.Pnum
> ...................
> rst!dnum=jnum (which gives me 0).
> When I run a compile I do not get an error message.
> In previous versions of Access I am pretty sure the above would generate an
> error message. Have I inadvertently turned something off????
> 
> 2. I do not use the Tools Relationship.
> I establish them in my queries and in my forms/subforms link or in code.  I
> also (because I have never liked Access's error messages) warn users with my
> own error message if a problem might occur.  Is this a feature designed for
> non-developers just like the table lookup (which I don't use either) or am I
> missing something (life has been good without it, just curious)????
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list