SQL Express 2005 question

[RustyAfro]

This is probably a very simple noobie question, but I can't find the answer yet.

If I install SQL Express and create a database, I understand it to be that one or more files are created to store all the tables, views, sps, etc.

My question is:

If I place that file(s) on a shared network drive that is on a file server and someone else also has SQL Express installed, can they "link" to the database file to query and work with the tables, views, etc?

I understand if the server itself hosts SQL Express, this can be done, but I want to mimic Access style databases (where access .mdb is stored on server and a client .mdb is on a client machine linked to the tables, queries, etc on the file server). For this particular project, I cannot use a hosted instance of SQL express but the project needs to be multi-user database driven.

Thanks for your help!

Joel

 

[nomadicalloy]

Please use sql express from a visual studio project, that way you will have client application in .net code and sql express as backend database.



This is Signature

http://www.xpherion.com/

 

[RustyAfro]

Nomad, thanks for the response. I did more research and found that I cannot just host the files on a network drive and have each persons local instance of SQL Express use the files (like a file database can ala Access).