UtterAccess Discussion Forums > Specify new table's field types in Make Table query?

Full Version: Specify new table's field types in Make Table query?

UtterAccess Discussion Forums > Microsoft® Access > Access Queries

kinggi

Sep 7 2006, 03:39 AM

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

AQM_UK

Sep 7 2006, 04:49 AM

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

ace

Sep 7 2006, 05:48 AM

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)
)

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.