Re: Quick Question on SQL Server 2005 Express

That is correct. None of the versions of SQL Server support the database files residing on a networked share. But you don't attach the db from the server to a client anyway. The client should not be the sqls server service itself, it should be an application suing the client / server approach. The client talks to the server and hence the db thru the SQL Server service on the server and thus the client has no need to access the files directly.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"David Clifford" <someone@microso> wrote in message news:%23xkWz432IHA.4988@xxxxxxxxxxxxxxxxxxxxxxx
Hello All

A quick question. We are moving an Access database over to SQL Server 2005. No problems. The SQL Server database will be located on it's own server. To test the system, I installed SQL Server 2005 Express onto the server, got the database attached etc. No problems. I installed the same Express version onto a client computer so that the operator could use the database from his workstation, tried to attach the database, but the network drive was not listed in the file dropdown box..only the local C: and D: drives. My gut says that Express won't look at network drives, anyone care to comment?

Thank you

David.


.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Other Users dont see table updates
    ... Database systems are not real time network communication ... Where people really want real-time network ... people used sql server to send mail messages - ...
    (comp.databases.ms-access)
  • Re: changing db location on sql2000
    ... Can you not back this database up? ... backups do support UNC paths...and ... manipulated some and put into a new sql server system. ... Therefore I wish MS had let us decide if it was ok to use a usb or network ...
    (microsoft.public.sqlserver.setup)
  • Re: changing db location on sql2000
    ... Tibor Karaszi, SQL Server MVP ... Therefore I wish MS had let us decide if it was ok to use a usb or network share or whatever to store the data. ... Since your USB drive was showed as a network share, SQL Server could not use it for storing database files. ... If your database is very large, you may consider using SAN, NAS etc which are fast and scalable network storage solutions. ...
    (microsoft.public.sqlserver.setup)
  • ODBC Connection with SQL Managed Provider
    ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
    (microsoft.public.dotnet.framework.adonet)