Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using SQL to add fields to Access 97 or 2K

Status
Not open for further replies.
KeithFrench

KeithFrench

Programmer
Jul 20, 2001
25
0
0
GB
When using SQL to add fields to a table in Access 97 or Access 2K, specifying the data type of the field does not match Access itself. For example in an SQL query if you want to add an autonumber field you have to specify it as a Counter. Some data types within the SQL query seem to differ between Access97 & 2K. Can anyone give me a definitive list of what you must specify for each data type for the SQL in both versions of Access?
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
214
TheresAlwaysAWay
TheresAlwaysAWay
RobJaxon
  • Locked
  • Question
RST .add
Replies
2
Views
63
RobJaxon
RobJaxon
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
137
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
184
lameid
lameid
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
171
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top