On Jun 23, 4:15*pm, joel garry <joel-ga...@home.com> wrote:
> On Jun 12, 7:54*am, timmg <tmillsgronin...@gmail.com> wrote:
>
> > What's the problem, Ed? *The table prefix? *Querying the MSysObject
> > table?
>
> > As long as the poster is using a reasonable naming convention he can
> > move data from Access ...
>
> Fire and brimstone has it's place too, but I'd rather not go there
> either.

Has it's place? Heck, I feel like I have lakefront property on the
liquid brimstone front here in my cube. Stop by if you want some <g>

On Jun 12, 9:54 am, timmg <tmillsgronin...@gmail.com> wrote:
> What's the problem, Ed? The table prefix? Querying the MSysObject
> table?
>
> As long as the poster is using a reasonable naming convention he can
[]
>
> Tim Mills-Groninger
> ...
[]
>
> > > Assuming that your table names start with the prefix "tbl."
>
> > yuck, poohey!
> > Ed

The table name prefix is the problem. Its a form of Hungarian notation
and NOT a reasonable naming convention IMHO. Naming a table of
employees TBL_EMP is useless because the "TBL_" is redundant
information. Funny though, as I write this I realize I disagree with
myself when it comes to constraints and indices. Those I tend to name
a style like: THIS_IDX or BENEFIT_EMP_FK. Guess I should not have
reacted so strongly.

Ed
(as I slink off and slap my own wrist)

On Jun 26, 12:27*pm, Ed Prochak <edproc...@gmail.com> wrote:
> On Jun 12, 9:54 am, timmg <tmillsgronin...@gmail.com> wrote:
>
> > What's the problem, Ed? *The table prefix? *Querying the MSysObject
> > table?
...
>
> The table name prefix is the problem. Its a form of Hungarian notation
> and NOT a reasonable naming convention IMHO....

Ah, the benefits of civil responses over flames - turns out we're on
common ground. I have some troubles with tbl as a prefix as well. I
tend to use it in VB/Access, where knowledge of the datatype - query
v. table makes sense in code. Within Oracle it is, I agree, a bit of
a repetitive redundancy.

And I think that we're in agreement that _some_ kind of naming
convention is a good thing.

Right now I'm working on an application where some of the data will
reside in Oracle - CONTROL_LIST, for example. Within Access there is
a link to that table called tbl_CONTROL_LIST. It's enough to give me
what I need to manage the Access code without worrying about
unnecessary overhead in Oracle.

Tim Mills-Groninger