Hi everyone, santosh here.
I need some help regarding creation of tables for a vb.net web-based application.
DATABASE TO BE USED: MS-ACCESS 2003
Database name: Physician
I want to run this script to create new table(PC_USER).
Please let me know how can i do this? I am just a average coder in VB.net, not well knowledge in connection codes for DB. Thank you.
I need some help regarding creation of tables for a vb.net web-based application.
DATABASE TO BE USED: MS-ACCESS 2003
Database name: Physician
I want to run this script to create new table(PC_USER).
VB.NET:
CREATE TABLE [dbo].[PC_Users] (
[User_ID] [smallint] IDENTITY (1, 1) NOT NULL ,
[User_Name] [varchar] (25) ,
[User_Password] [varchar] (50) NULL ,
[User_Facility_ID] [int] NULL ,
[User_Admin] [char] (1) NULL ,
[Insert_dt] [datetime] NULL ,
[Update_dt] [datetime] NULL ,
[Insert_by] [varchar] (50) NULL ,
[Update_by] [varchar] (50) NULL ,
[Active] [char] (1) NULL
) ON [PRIMARY]
GO
Please let me know how can i do this? I am just a average coder in VB.net, not well knowledge in connection codes for DB. Thank you.
Last edited by a moderator: