In access .mdb I want to create a new table with 5 fields.
Code is like:
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim fld As DAO.Field
Set db = CurrentDb()
Set tdf = db.CreateTableD ef("t_comps2")
With tdf
Debug.Print "Count of fields is: " & tdf.Fields.Coun t
' create the fields =========
Set fld...
3 results in 0.0028 seconds.
-
Access - create table DAO - but table not found
-
varbinary(max) field in sql server 2005 problems
I'm unable to execute the above create table statement. It is giving the following error.Code:CREATE TABLE Upload ( uploadid INT IDENTITY(1,1) PRIMARY KEY, cssid INT NOT Null FOREIGN KEY REFERENCES CourseSemSub(cssid), teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), description VARCHAR(40), video VARBINARY(MAX) NOT NULL )
Msg 170, Level 15,... -
C# and creation of Access database
Hi all!
I need to create MS Access database table row, that have to store "long text" in it.
What type of field I have to use?
I tryed with adLongVarWChar, but it stores only 250 or something characters
Please if you can help me with this.
Thank you in advance!...
