phatnq2002
Registered User.
- Local time
- Today, 06:59
- Joined
- Mar 28, 2007
- Messages
- 23
In Access, we can make a project file which connect to a SQL Server.
So we can inhirit all features of SQL Server.
When using project file, we can run a store procedure by:
CurrentProject.Connection.Execute "EXEC storeprocedure"
or any action query:
CurrentProject.Connection.Execute "INSERT|UPDATE|DELETE clause"
We also use a ADODB Recordset to get data from a table or a view:
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
With rs
.ActiveConnection = CurrentProject.Connection
.LockType = ...
.CursorType = ...
.Open stSQL
End With
Here is some words of mine.
So we can inhirit all features of SQL Server.
When using project file, we can run a store procedure by:
CurrentProject.Connection.Execute "EXEC storeprocedure"
or any action query:
CurrentProject.Connection.Execute "INSERT|UPDATE|DELETE clause"
We also use a ADODB Recordset to get data from a table or a view:
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
With rs
.ActiveConnection = CurrentProject.Connection
.LockType = ...
.CursorType = ...
.Open stSQL
End With
Here is some words of mine.