[AccessD] Assistance

Gustav Brock Gustav at cactus.dk
Wed Mar 1 11:52:09 CST 2006


Hi Dan

It really is a matter of preference, I feel. All I can say is that it has never caused any trouble for me.
Also, I always prefix table names "tbl" to separate them in SQL clearly from query names.
But I never prefix field names with "fld". Again, matter of taste.

/gustav

>>> dwaters at usinternet.com 01-03-2006 17:39 >>>
Gustav,

I usually don't argue in this list but now I have to.  Do you really want
one field in every table called ID?  Typing is easy!  Trying to hunt down
which of 50 fields all named ID is causing the problem sounds like a good
all-day exercise.

Dan 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, March 01, 2006 9:13 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Assistance

Hi Dan

Actually you are denormalizing the naming of the database schema this way
...
ID is fine. Outside the table it is tblMyTable.ID. Access does this for you
automatically.
Why having trouble with tblMyTable.MyTableID? Too much typing.

Sorry, couldn't resist. Boring day here - and remember: Clients do lie. "I'm
are experiencing locked records but everyone else is locked out." My
colleague drives to the client just to spot a laptop with wireless network.
You have one guess: Was this machine logged in to the application?"

/gustav


>>> dwaters at usinternet.com 01-03-2006 14:28 >>>
AND, the name of the autonumber field MUST be the same as the table name.

For example, tblMyTable has a PK Autonumber of MyTableID.

It MUST be this way!

;-)

Dan 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Tuesday, February 28, 2006 10:59 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Assistance

ROTFLMAO.

Some things are just worth doing, always. 

Because of my dictatorial methods I am able to just look at my tables and
see the relationships, know what tables a field is in etc.  Works for me.
Most of my subjects don't dare speak up anymore, knowing my "out the door,
without a parachute" mentality.

;-)

John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Tuesday, February 28, 2006 11:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Assistance

Well, thanks to you and your dictatorial methodology I find I am now
completely unable to create a new table without defining an autonumber PK as
the very first field.  With ID as the suffix of the field name.

Thanks a lot.

And I mean that.

Rocky




More information about the AccessD mailing list