Need Your Help

Hi,

I have a problem with SQL 2005, i need to access sql database as i do with MS

Access 2003.

I mean that if i can backup my database and then access it as a direct file and do the

transactions on that copy of the database without refering to SQL 2005.

Hi,

direct file access on SQL Server files is not possible. SQL Server 2005 introduced a new feature called "user instances" which will enables you to wire a data file to a SQL Server express instance, without actually attaching it as we used to in SQL Server 2000 and in prior version. You should take a deeper look in the BOL to see if that fit your needs. Be aware that you will need a SQL Server Express Service running for that on your computer.

Jens K. Suessmeyer.

http://www.sqlserver2005.de