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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Where do you copy a SQL Server database to?

Author  Topic 

projecttoday
Starting Member

31 Posts

Posted - 2010-04-29 : 22:11:45
I'm trying to deploy an Access database which has a SQL Server Express backend. Is it possible to copy a SQL Server database to a computer that does not have SQL Server installed on it? The database would reside on a network drive.

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-04-30 : 03:46:43
No - SQL Server (all editions) is server based. You should install SQL Server Express on a server and setup the connection string to reference that server. Then, your access database front end can reside anywhere and link to the tables on the server.
Go to Top of Page

projecttoday
Starting Member

31 Posts

Posted - 2010-04-30 : 17:41:49
Apparently I was misinformed. Thank you.
Go to Top of Page
   

- Advertisement -