hi I'm new to SqL server set-ups, my probs is on how to start using the tables in the SQL server2005 after my connection is being open, like for example:
Dim db as database
Dim rs as recordset
Dim StrSQL as string
set db=currentdb
StrSQL="Select * from tblemployees where empid='"&txtempid &"'"
set rs=db.OpenRecordset(StrsQL)
* with that line "tblemployees" is one of those table name at SQL server 2005 database name KPCdb, but my probs was i'm getting an error...So for now Im asking your help people who got enough knowledge on SQL Server2005 if you can give me some lines of program coding that would let me use or query tables in the server..
Thanks
Ben
Dim db as database
Dim rs as recordset
Dim StrSQL as string
set db=currentdb
StrSQL="Select * from tblemployees where empid='"&txtempid &"'"
set rs=db.OpenRecordset(StrsQL)
* with that line "tblemployees" is one of those table name at SQL server 2005 database name KPCdb, but my probs was i'm getting an error...So for now Im asking your help people who got enough knowledge on SQL Server2005 if you can give me some lines of program coding that would let me use or query tables in the server..
Thanks
Ben