Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tallboy
Starting Member
4 Posts |
 Posted - 2011-10-15 : 08:03:27
|
| Hi Gus, I am mew to SQL Server 2008 (R2) but have a lot of DB programming. I just have a couple of queries that I am sure has been asked before somewhere on the forum so if you could point me tin the right direction that would be great.I have an Access 2003 Front End with linked tables to a SQL Server 2008R2. Everything quite straight forward I have simple tables called TblClient with simple test data. My First query is that I have linked my yales to my access 2003 FE and one of the tables is perfect, while the others show the data in the fields as #DELETED when opened ??Secondly I wish to create an ADO connection (to call Stored Procedures) I'm advised this is the best way to g,o I am no stranger to VB, but find the script difficult to go with My Server instance is called MSSQLSERVER2 and the database is FirstDatbase, and I am using WINDOWS Authentication.Ay help greatly appreciated.Kind regards |
|
|
|
|
|
Connection Strings