Re: Separate PK in Jxn Tbl?

Frank Hamersley <terabitemightbe_at_bigpond.com> 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/