Re: create access table with ado sql (cannot change table properties)
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/25/05
- Next message: Brian Bushay TeamB: "Re: smalldatetime overflow error"
- Previous message: kolja2003: "About deleting."
- In reply to: ercan: "create access table with ado sql (cannot change table properties)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 24 Mar 2005 20:23:10 -0600
>we have an access database and we want to modify the table field
>properties.like format of double field to Currency .
>is it possible to do it with sql ado.if yes how?
I think currency and Double are different field types in the Access table.
Try
Alter Table YourTable
Alter Column yourField Currency
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: smalldatetime overflow error"
- Previous message: kolja2003: "About deleting."
- In reply to: ercan: "create access table with ado sql (cannot change table properties)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
