How can we create a unique and non-editable ID from client's first and
last name?
eg.: SmitJ1 for John Smith
Matuag
May 24 '07
28  4109 
"Matuag" <ma****@gmail.c omwrote in message
news:11******** ************@n1 5g2000prd.googl egroups.com...
>
Define "to identify the record". The PK already does that.
Keith.
I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
It's a good ideal to hide the primary key, but changing the auto number
field to random would eliminate that as a source for counting number of
clients.
On May 25, 6:57 am, Matuag <mat...@gmail.c omwrote:
Define "to identify the record". The PK already does that.
Keith.
I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
Primary key has nothing to do witrh the nuimber of records nor does
autonumber.
On May 25, 12:15 pm, "paii, Ron" <p...@packairin c.comwrote:
"Matuag" <mat...@gmail.c omwrote in message
news:11******** ************@n1 5g2000prd.googl egroups.com...
Define "to identify the record". The PK already does that.
Keith.
I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
It's a good ideal to hide the primary key, but changing the auto number
field to random would eliminate that as a source for counting number of
clients.
Autonumber NEVER is a reliable determiniation of recrod count whether
you use random or not. That is NOT what autonumber is intended for.
Using Increment may give the APPEARANCE of the value equating to some
sort of record number but it does not actually do that. I always use
Random in my autonumber fields just so noone makes the false
assumptions that often follow an incremental autonumber.
Matuag <ma****@gmail.c omwrote in
news:11******** **************@ u36g2000prd.goo glegroups.com:
How can we create a unique and non-editable ID from client's first
and last name?
eg.: SmitJ1 for John Smith
Don't. There is no need for such codes these days. Anyone who is
using them is stuck in 1970s thinking, back in the days when it
wasn't really possible to have onscreen lookups in your mainframe
computer application.
Now, to choose a client, you'd just have them search on name, and
then they'd select from the list of matches.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Matuag <ma****@gmail.c omwrote in
news:11******** ************@n1 5g2000prd.googl egroups.com:
I want an alphanumeric ID rather than its auto numbered ID, for
using it on all manual records for clients.
What's wrong with the client's name?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
rkc <rk*@rkcny.yabb a.dabba.do.comw rote in
news:46******** *************** @roadrunner.com :
(PeteCresswell) wrote:
>Per Matuag:
>>I want an alphanumeric ID rather than its auto numbered ID, for
using it on all manual records for clients. I am reluctant to
use primary key because I do not want users to know the total
number of clients.
The junk mail that I get in my mailbox seems to use a fraction of
the last name, the house number, and some fraction of the street
name a lot.
But it all still begs the question "Why". Is it so customers
can say over the phone something like "Cresswell 303 Friendship"
and the person at the other end can look up "Cress303Friend "?
It sort of makes sense if it used on paper work (manual records?).
Cress303Friend would be entered to bring up the exact records for
Pete Cresswell instead of searching on something that brings up
more than one record.
Sort of.
You could also use the Autonumber PK if that's what you need.
And if you want to make it look cool and take up fewer characters,
run it through Hex().
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Matuag <ma****@gmail.c omwrote in
news:11******** ************@n1 5g2000prd.googl egroups.com:
I am reluctant to use primary
key because I do not want users to know the total number of
clients.
Then run it through Hex() -- then it will look like a semi-random
string of numbers and letters.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"DavidB" <je***@yahoo.co mwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...
On May 25, 12:15 pm, "paii, Ron" <p...@packairin c.comwrote:
"Matuag" <mat...@gmail.c omwrote in message
news:11******** ************@n1 5g2000prd.googl egroups.com...
Define "to identify the record". The PK already does that.
Keith.
I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
It's a good ideal to hide the primary key, but changing the auto number
field to random would eliminate that as a source for counting number of
clients.
Autonumber NEVER is a reliable determiniation of recrod count whether
you use random or not. That is NOT what autonumber is intended for.
Using Increment may give the APPEARANCE of the value equating to some
sort of record number but it does not actually do that. I always use
Random in my autonumber fields just so noone makes the false
assumptions that often follow an incremental autonumber.
My take on the original post was to hide even the APPEARANCE of a client
count.Using a random auto number will eliminate even the appearance of
meaningful information.
Per DavidB:
>Autonumber NEVER is a reliable determiniation of recrod count whether
you use random or not.
Which brings a thought to mind... If the OPs reason for not
wanting outsiders to see an AutoNumber value stems from not
wanting somebody to see that the endeavour doesn't cover that
many people, one could massage the table a little - by appending,
say 250,000 records via a query and the deleting them.... making
the first "real" record's AutoNumber PK be 250001... and thus
making the endeavour look larger that it is.
--
PeteCresswell
"paii, Ron" <pa**@packairin c.comwrote:
>My take on the original post was to hide even the APPEARANCE of a client
count.Using a random auto number will eliminate even the appearance of
meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tony Clarke |
last post by:
Hi,
I'm trying to write a system thats used for about 50 clients that uses html
forms and php to log details. The problem is that when a client loads the
form page it's given a value which is the last record in a table +1 (i.e. so
its the next record). The problem with that is that a client could sit on
that page for 20 mins (or whatever length of time) and a different client
could use that record number and there what be an error...
|
by: Louis Frolio |
last post by:
Greetings All, I have read many upon many articles here regarding GUID
data types and uniqueness. There have been many opinions regarding
the effectiveness of GUID's and when they should/should not be used.
However, every article strongly implies, if it does not state it
outright, that GUID's are always unique. My question is this, what
happens if you have a database that uses GUID's and the NIC is changed
out on the box? From what I...
|
by: UJ |
last post by:
Is there any number I can get that is truly unique for a computer that can't
be changed? I want to have a system whereby I have a computer that accesses
a web service based on some unique value that can't be changed. Or at least
if it is changed, it's not changed frequently. (IP address won't work
because that can change frequently).
Here's my thought - the program boots up, finds some unique piece of
information, sends that off to the...
|
by: bwmiller16 |
last post by:
Guys -
I'm doing a database consistency check for a client and I find that
they're building unique indexes for performance/query reasons where
they could be using non-unique indexes.
Note that these columns in the unique indexes are truly unique and
don't constitute a collision hazard of any kind.
Now, I personally wouldn't use unique where non-unique would do but I
|
by: Mamuninfo |
last post by:
Hello,
Have any function in the DB2 database that can generate unique id
for each string like oracle, mysql,sybase,sqlserver database.
In mysql:-
select md5(concat_ws("Row name")) from tablename;
Here this function generate unique id for each row of the table.
Regards..
| | |
by: Goh |
last post by:
Hi,
I would like to know how can we implement a web page that
intelligent enough to unique identify that pc have been visit before without
any cookies and login user require.
I have try implement this by MAC address. When user browser the web
site I sometime can get user pc MAC and sometime no.
Why this type of implementation are so not consistency? Does any
|
by: Jimmy Stewart |
last post by:
Ok, I'm trying to write a query that is starting to wear me down.
What I'm trying to do is create a year end report that gets sent to all of
my customers who meet two criteria. One they are 'Residential' customer AND
they have had business with us during this past year.
My report is based on a query.
The query has two tables associated with it. One is tblClients which
provides client name, account type and the other relevant mailing...
|
by: tony obrien |
last post by:
Hi,
I have written a Class Library in VB.net which provides Props/Meths to a
caller to hide the uglinesses of a TCP message protocol between a Client
and a Server.
All this works just fine.
Now I am trying to develop a LOAD TESTER app which spawns lotso' threads
each with this capability to bang the server.
|
by: Mufasa |
last post by:
I'm looking for a way to get a truly unique identifier for a machine for our
client software. I'd like to have it so that there's little or no setup by
the end user. (We set up the machines and then ship them out for most cases
but some of our customers do provide their own machines.) Our concern is if
somebody takes one of our machines and ghosts it so they have a complete
copy of the machine, it will allow them to continue working.
We...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
