I wanted to try my idea to do a shared database

To do the map network drive or sharing
And summoned the database file from the program
sql server software but does not show the files on the network

You can modify the program settings to access the files in a computer network?

You may need to open the SQL server TCP/IP port 1433 and maybe 445 in any firewalls, and/or forward these ports through any routers between your client and server.

Originally posted by Carefree
Try changing the provider to SQLOLEDB

Professor Carefree same error when you change to SQLOLEDB


Professor Carefree same error when you change to SQLOLEDB


'strConnString = "Driver = {SQL Server}; Server = 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 5555555;"
'Provider = SQLNCLI10; Server = tcp: 192.168.1.2; Database = ahmed; UID =ahmed; PWD = 5555555;
'Conn.Open "Provider = SQLNCLI10; Server = tcp: 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 55555555;"
'Conn.Open "Provider = SQLOLEDB; Data Source = 192.168.1.2; database = ahmed; uid = ahmed; pwd = 5555555;"

'Conn.Open "Driver = {SQL Server}; Server = 192.168.1.2; Database = ahmed; UID = ahmed; PWD = 5555555;"

Try changing the provider to SQLOLEDB

That's easy enough. Create the database, then with your second computer, access it using the IP address of the first computer, something like this: