Separate PK in Jxn Tbl?

On Jan 29, 7:56 am, "Neil" wrote:
"Jamie Collins" wrote in message

Here in the UK I avoid using the word 'moot' when trying to write
'plain English' simply because the US usage has obscured the UK usage
i.e. it can cause confusion.

You could use the alternate "moo" point, meaning that the point is full of
methane gas. At least it would be clear what you mean.... ;-)

Amusingly, a lot of people misperceive the word as "mute."

It's a mute point, meaning it can't say anything any longer.
It sorta vaguely works in a metaphoric way.

Of course, on the internet, you can find many examples of
fractured usage. Ultimately it's just a waist of time.snicker


Marshall

Keith Wilby wrote:
"Frank Hamersley" wrote in message
...

provision of a menu option to reattach a data .mdb!

Is it just me or is that complete gibberish? Reattach?

Just you mate (at least I hope so or we are doomed).

Pray tell how do you distribute new versions of "code"?

Never had that concern? - always just hacked the live .mdb?

Gawd.

Sylvain Lafontaine wrote:
I concede the point that for the two keys of the junction table, using an
autonumber primary key is overkill except for special situations.


Shouldn't a database be designed right from the beginning?

I prefer KISS.

Thus I prefer an autonumber.

Then again, junction tables are rarely needed.

On Jan 29, 8:37 pm, Marshall wrote:
On Jan 29, 7:56 am, "Neil" wrote:

"Jamie Collins" wrote in message

Here in the UK I avoid using the word 'moot' when trying to write
'plain English' simply because the US usage has obscured the UK usage
i.e. it can cause confusion.

You could use the alternate "moo" point, meaning that the point is full of
methane gas. At least it would be clear what you mean.... ;-)

Amusingly, a lot of people misperceive the word as "mute."

This probably comes from you fellas over the pond not pronouncing
words (*cough*) correctly. Mute should of course be pronounced at
though there was a y between the m and the u!

In fact, I challenge you to a dool next Toosday morning to settle the
matter, right after I've eaten my moosli ;P



It's a mute point, meaning it can't say anything any longer.
It sorta vaguely works in a metaphoric way.

Of course, on the internet, you can find many examples of
fractured usage. Ultimately it's just a waist of time.snicker

Marshall

CHP lideri Deniz Baykal, AKP ile MHP'nin türban konusundaki
mutabakatýna sert tepki gösterdi. Türkiye'nin bir yere doðru
sürüklendiðini iddia eden Baykal, "Hedef, Mustafa Kemal Atatürk'ün
Türkiye Cumhuriyeti'dir. Hedef, laikliktir" dedi. Baykal, partisinin
grup toplantýsýndaki konuþmasýnýn büyük bölümünü türban konusuna
ayýrdý. Baykal'ýn sözleri özetle þöyle:

BÝR ÜNÝFORMADIR: Türbanla gelen yaþmak, baþörtüsü deðildir. Gelen Arap
Vahabi, Abbasi, Emevi, Ýslam yorumunun Türkiye'ye yönelik projesinin
bir simgesi olarak, Türkiye'deki iþbirlikçileriyle birlikte dayatmaya
çalýþtýðý bir yabancý üniformadýr. Bunun geliþiyle yükselen Ýslamiyet
deðildir, Kuran'ýn Ýslamiyeti deðildir, gelen baþka bir þeydir. Din
için deðil, siyaset için geliyor. Hedef Mustafa Kemal Atatürk'ün
kurduðu Türkiye Cumhuriyeti'dir. Laiklik, cumhuriyetin özüdür. Hedef
laiklik ilkesidir.

MHP'YE ELEÞTÝRÝ: O formül, bu formül derler, seni kullanýrlar. Sen de
buna alet olmuþ olursun. Bu formül, tüm resmi eðitim sistemi içinde
ithal edilmiþ, dayatýlmýþ bir kýyafetin Türkiye'de devlet sisteminin
içine doðru geniþlemesinin önünü açmýþtýr. Ne yaptýðýný bilerek bunu
yapanlar var, kullanýlanlar, alet olanlar var. Meydaný boþ
býrakmayacaklarmýþ da, o meydanda yarýþacaklarmýþ da... Mesele Türkiye
Cumhuriyeti'nin ebediyen devam edip etmeyeceðidir.

LÝSELERE DE GÝRER: Dokunulmazlýk için Anayasayý deðiþtiremiyoruz,
temel sorunlarýn çözümüne yönelik buna yönelmiyoruz ama türban
konusunda Anayasayý deðiþtiriyorsunuz. "Ben onu istedim, bunu
istemedim" diyerek, sorumluluðunu ayýrmaya çalýþanlar var.

"Salad" wrote in message
...
Sylvain Lafontaine wrote:
I concede the point that for the two keys of the junction table, using an
autonumber primary key is overkill except for special situations.


Shouldn't a database be designed right from the beginning?

I prefer KISS.

Thus I prefer an autonumber.

Then again, junction tables are rarely needed.

Simple is as Simple does.

-CELKO- wrote:

Let's take an example that is a very strong natural key -- (longitude,
latitude). Established for centuries. Well-defined operations, etc.
Validation can be done by GPS or a few million maps. Can you explain
how this immutable key gets changed more often that some "synthetic
key" for locations?

Datums - NAD27, NAD83, and WGS84.all have slightly different meanings for the same
latitude and longitude for North America.
http://en.wikipedia.org/wiki/Geodetic_datum

And there are different latitudes http://en.wikipedia.org/wiki/Latitude

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Bob Badour wrote:

Apparently you have never had to attach an access app to a new instance
of the database it uses. I found that process incredibly awkward, slow
and kludgy.

Now you won't read this because you have me plonked. Nevertheless there are two
basic means of relinking an Access front end (FE) to the data source such as an
Access backend (BE).

You can use the Linked Table Manager wizard to do the work.

However I prefer using the code which, after the first table is linked, then opens a
recordset against that table, relinks the rest of the tables and then closes the
recordset. If someone else is already in the BE MDB this will give you a much
better performance. As much as ten or twenty times as fast.

I use an older version of the code at Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm

Also "ACC2000: Slower Performance on Linked Tables - 261000 indicates that if the
database has many linked tables that also have many relationships, and the table that
you are opening has its subdatasheet Name property set to [Auto], this can make the
table slow to open. Subdatasheets are a new feature in Access 2000 Therefore, you are
more likely to notice this behaviour after you convert a database from an earlier
version.

It is recommended that we set the subdatasheet Name property on each table in the
back-end database to [NONE]. Making this change in the front end won't help if it
even works at all."

Also "Links to tables on MDB which are not accessible. You may have some tables
linked to a secondary MDB for which the server is no longer available or drive letter
is no longer mapped."

The above is from Microsoft Access Performance FAQ on my website
http://www.granite.ab.ca/access/performancefaq.htm

Maybe you should've asked in an Access newsgroup or done some googling?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Frank Hamersley wrote:

Therein lies its criminality g - it screams encouragement for dabblers
and barely offers anything for artisans except stupendous numbers of
mouse clicks!

OTOH do you want them using Excel for data management? Single user?

A friend was telling me of a huge Excel file with many workbooks where data
normalizing meant going through the cells looking for occurances of similar names and
ensuring they all had the same name.

And, of course, Excel is single user as far as I know.

Take for instance the number of versions it took before separating the
data from the "code" was a core feature by way of the provision of a
menu option to reattach a data .mdb!

A97 has the wizard. I don't recall about previous versions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

"Keith Wilby" wrote:

But then again the US don't have colour television programmes either do
they? Or aluminium ;-)

We in Canada do have colour TVs, although I don't actually own one. But we don't
have aluminium. So where does that put us?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/