• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connects and Creates Tables with Multiple Columns and Data Types - EASILY

Connects and Creates Tables with Multiple Columns and Data Types - EASILY

Connects and Creates Tables with Multiple Columns and Data Types - EASILY

API Declarations


'Sets Database Name and Path to Current App's Path
Set db = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\DATABASE.mdb")




Rate Connects and Creates Tables with Multiple Columns and Data Types - EASILY

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

'and Make Three Columns to it consisting of:
'Date - Text Field, NumTimes - Number Field, TotalTime - Memo
db.Execute "Create Table [" & strUserName & "] ([Date] text, [NumTimes] number, [TotalTime] memo)"
db.Close