[AccessD] Changing Data Types - URGENT

Charlotte. 

Access 2K. - and I would like to change a field in a table from (whatever 
it is...text,numeric, etc.) to datetime.
This change will take place after the table has been created.

TIA
Ryan





"Charlotte Foust" <cfoust at infostatsystems.com>
Sent by: accessd-bounces at databaseadvisors.com
05/03/2004 16:37
Please respond to Access Developers discussion and problem solving 

 
        To:     "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
        cc: 
        Subject:        RE: [AccessD] Changing Data Types - URGENT


Are you asking about changing the table structure?  If so, you can't do
that with a query, although you can with VBA ... And some effort.  If
you provide more specifics about the Access version and what you want to
do, someone should be able to help you.

Charlotte Foust

-----Original Message-----
From: rsmethurst at uk.ey.com [mailto:rsmethurst at uk.ey.com] 
Sent: Friday, March 05, 2004 8:22 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Changing Data Types - URGENT


Hi All,

Is there a way I can programmatically change a datatype in a field,
using 
either VBA or SQL?

TIA
Ryan
 

 
This e-mail and any attachment are confidential and contain proprietary
information, some or all of which may be legally privileged.  It is
intended solely for the use of the individual or entity to which it is
addressed.  If you are not the intended recipient, please notify the
author immediately by telephone or by replying to this e-mail, and then
delete all copies of the e-mail on your system.  If you are not the
intended recipient, you must not use, disclose, distribute, copy, print
or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail
and any attachment has been checked for viruses, we cannot guarantee
that they are virus free and we cannot accept liability for any damage
sustained as a result of software viruses.  We would advise that you
carry out your own virus checks, especially before opening an
attachment.

The UK firm Ernst & Young LLP is a limited liability partnership
registered in England and Wales with registered number OC300001 and is a
member practice of Ernst & Young Global.  A list of members? names is
available for inspection at 1 More London Place, London, SE1 2AF, the
firm?s principal place of business and its registered office.
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



 

  
This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged.  It is intended solely for the use of the individual or entity to which it is addressed.  If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system.  If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses.  We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global.  A list of members? names is available for inspection at 1 More London Place, London, SE1 2AF, the firm?s principal place of business and its registered office.