UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Specify new table's field types in Make Table query?    
 
   
kinggi
post Sep 7 2006, 03:39 AM
Post #1

UtterAccess Veteran
Posts: 320
From: Melbourne, Austraila
Hello,

Is there any way to specify the field types of a table created by a MakeTable query?

I have a large text field that is being created as text instead of memo, and hence is truncating data....

Thanks,

-Steve
Go to the top of the page
 
+
AQM_UK
post Sep 7 2006, 04:49 AM
Post #2

UtterAccess VIP
Posts: 4,447
From: Suffolk, England
Why are you using a make table query.

Why not append data to the table. This will avoid this problem. I rarely use a make table query more than once, during the initial make.

Jim
Go to the top of the page
 
+
ace
post Sep 7 2006, 05:48 AM
Post #3

UtterAccess VIP
Posts: 5,280
From: Upstate NY, USA
Yes. Here is the basic ddl for the Northwind Employees table.
CODE
CREATE TABLE Employees77 (
     EmployeeID                    AUTOINCREMENT,
     LastName                      Text(20) NOT NULL ,
     FirstName                     Text(10) NOT NULL ,
     Title                         Text(30),
     TitleOfCourtesy               Text(25),
     BirthDate                     Date,
     HireDate                      Date,
     Address                       Text(60),
     City                          Text(15),
     Region                        Text(15),
     PostalCode                    Text(10),
     Country                       Text(15),
     HomePhone                     Text(24),
     Extension                     Text(4),
     Photo                         Text(255),
[color="red"]    Notes                         Memo,[/color]
     ReportsTo                     Long,
  CONSTRAINT pkEmployees PRIMARY KEY (EmployeeID)
)
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 03:55 AM