如何获取信息连接到Lan中所有计算机的数据库访问 [英] How Do I Get Information Connect To Database Access Of All Computer In Lan

问题描述

各位大家好！



我有一个使用Microsoft Access的数据库。

我有一个内部网系统，一个服务器和五个客户端。



现在我把我的数据库放到服务器上连接到客户端。

如何获取信息（计算机名，用户名，时间） ）从客户端访问/连接到此数据库？可能吗？



我使用c＃，Windows Forms，用于桌面窗口的Visual Studio Express 2013，Microsoft Access 2013.



任何想法或任何帮助我都非常感激，并认为这对我来说是一个教训。

非常感谢你！

解决方案

< blockquote>首先，不要尝试将五个客户端连接到Access数据库 - 它实际上并不擅长，并且除了单个用户访问之外，总是遇到问题。对于任何多用户，您应该查看SQL Server或MySql - 您的大多数代码应该只使用微不足道的更改（连接字符串，使用SqlConnection和SqlCommand对象而不是OdbcConnection和OdbcCommand，这种事情）。



其次，您无法在数据库中获取连接信息 - Access不会在服务器上执行任何处理，只是将DB内容提供给客户端PC，因为它实际上很大文件。

Hello everybody!

I have a database using Microsoft Access.
I have an intranet system with one server and five clients.

Now I put my database to the server to the client connection.
How can I get the information (Computer name,username, time) from the client access / connect to this database? Is Possible?

I use c #, Windows Forms, Visual Studio Express 2013 for desktop window, Microsoft Access 2013.

Any ideas or any help I am very grateful and consider it a lesson for me.
Thank you very much!

解决方案

Firstly, don;t try to connect five clients to an Access database - it really isn't good at that, and has always given problems in anything other than single user access. For anything multiuser, you should look at SQL Server or MySql - most of your code should work with only trivial changes (Connection string, using SqlConnection and SqlCommand objects instead of OdbcConnection and OdbcCommand, that kind of thing).

Second, you can't get the connection info at the DB - Access doesn't do any processing at the server, that just serves up the DB content to the client PC as effectively a big file.

这篇关于如何获取信息连接到Lan中所有计算机的数据库访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！