Hi.
MerbershipID in my main table is the primary key. Is it possible to convert
it to Number type without affecting my data.
If the MembershipID (sp?) is a text value holding only numbers, a decimal,
and a negative sign or positive sign, then it's possible to change the data
type. This won't affect the other data in the table. However, if this
primary key has a relationship with any other table, then you won't be able
to convert the data type without first dropping the relationship, then
converting the data type, then recreating the relationship.
Bear in mind that any existing VBA code or SQL that relies on the primary
key's data type to be a string will fail unless you change that code and SQL
statements to expect a numerical data type, instead. And any external
databases that link to this table must have these links dropped and new links
recreated (not refreshed, which keeps the original table structure instead of
using the current table structure).
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
