primary keys having text data type
- From: "Paul Ponzelli" <pponzelliREMOVE@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Apr 2005 21:40:48 -0700
I've got some primary keys whose values look like numbers, such as 100434,
100435 etc., but they have a text data type instead of a number data type.
If I had built these tables myself, I would have defined them as Long
Integer data types, but I inherited the database from another developer.
I ran the Performance Analyzer, and it suggested converting the data types
of these primary keys to Long Integer. However, there are existing queries
that use these fields, and a number of references to these fields in form
and report modules that punctuates these fields as text data. So if I
change them to Long Integer like the Analyzer suggests, I'll have to spend
some time modifying the queries and the VBA code that refers to the fields.
My question is this: is it worth going through the effort to make the
changes? How important is it to change the data type of these primary key
fields to Long Integer?
Thanks in advance,
Paul
.
- Follow-Ups:
- Re: primary keys having text data type
- From: John Vinson
- Re: primary keys having text data type
- Prev by Date: Re: Access and Linked tables to Oracle
- Next by Date: Getting fatal error that shuts down outlook when launching?
- Previous by thread: Parameter Value not found in Query
- Next by thread: Re: primary keys having text data type
- Index(es):
Relevant Pages
|
