access lan

Question

can someone help me with how i can connect to a database via Lan in a company

Answer 1

you've several options to access data in a database in a Lan.

1) SQL Server Management Studio or SQL Server Management Studio Express (free)

2) a development environment, eg. Visual Studio with database support

3) a client application which allows you to access the database.

if you need a more detailed answer, please give us more information what you want to do.

Answer 2

Hi ebukeez,

Could you please provide more information? Which version and edition of SQL Server is it? Do you use SQL Server Management Studio or another application/client to connect to SQL Server?

You may have a look at the following links to enable remote connection in SQL Server:

http://support.microsoft.com/kb/914277

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.

Answer 3

Hello,

Follow the threads below. It may help you.

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/d5194246-ab98-4d3c-be54-779dd62a3927/

http://stackoverflow.com/questions/6667400/how-to-connect-database-over-local-area-network-sql-server-2008

Answer 4

i am not using an sql server am using access file as my database

Answer 5

Hello,

Please, could you have a look at this link ?

http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/48f81330-92b3-410a-a43f-f47b2eefbadf 

Just a little remark : an useful habit would be to provide the version/edition of the SQL Server ( when you are using this DBMS ) and the version for Access. You will get quicklier a full answer.

Don't hesitate to post again for more help or explanations.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 6

i am not using an sql server am using access file as my database

Hi ebukeez,

This forum is for posing questions about data access to SQL Server. Since you are using Access not SQL Server, I would suggest you post it in an Access-related forum for more help.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.