Prev: Can you improve this TSQL: I am converting DATETIME to CHAR()
Next: Connection strings going from local drive to a network drive using Wizards in Visual Web Developer?
From: Erland Sommarskog on 8 Feb 2010 18:06
SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. (sanjay(a)microbrain.in) writes:
> This my Access Database is only to save setting of user. If there is no
> other way, I have to open then with other connection.
If you have a client program that access SQL Server, the client program
would have to access the Access database directly. Which is a better
solution, even if you could access the Access database from SQL Server.
To borrow a proverb from Swedish, that would be to cross the brook for
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx