Consult, declaration time, business interests and possible work needs, at the beginning I contact is the Excel VBa language,
Before using VB to realize the reader in the designated computer network Access library file
How to solve the public access? Trying to access modification is relatively simple, is both a black eye meng forced on the public network,
Before also checked some database systems, what server are mentally, I have been watching case or for a a problem to solve the problem, sometimes the most terrible is you don't know what is problem

CodePudding user response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, then foreign service, or by VPN, make into a network, but the speed may not satisfactory,

CodePudding user response:

Access to a local database, if you want to access the database through the network, two ways:
1, in SQL Server, Oracle, MySQL and other network database
2, make a network access service program on the public network, the service back then access database, and open interface, your client through this service program sends commands to access data to add and delete,

CodePudding user response:

If you must use Access database, the following methods can have a try, but involves the knowledge is relatively more,

1. First of all, have a fixed IP (or domain name);
2. The Access database in the computer, write a server-side program, the server is responsible for parsing command, and the data returned;
3. Write a client again, via IP access server (or domain name), the client is responsible for sending instructions, and receiving data and display;
4. If you don't think the data transmission security, but also for the transmission encryption,

Suitable for small data applications,

CodePudding user response:

The building Lord will connect MSSQL database under wince

CodePudding user response:

reference 1/f, stupid dog flew first response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, and then the foreign service, or use VPN to make into a network, but the speed even is not satisfying,

SQL server once something I didn't contact with the

CodePudding user response:

reference 4 floor zhstar response:

the original poster will connect MSSQL database under wince

迷茫

CodePudding user response:

reference 5 floor qq_34304893 reply:

Quote: reference 1/f, stupid dog flew first response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, and then the foreign service, or use VPN to make into a network, but the speed even is not satisfying,

SQL server once something I didn't contact with the

Many online tutorial, it is ok to see the dress,
VB SQL and Access even open a database connection string used in different, other database usage almost identical,
There is a time to learn about a day or two is about the same

CodePudding user response:

refer to 7th floor stupid dog flew first response:

Quote: refer to the fifth floor qq_34304893 reply:

Quote: reference 1/f, stupid dog flew first response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, and then the foreign service, or use VPN to make into a network, but the speed even is not satisfying,

SQL server once something I didn't contact with the

Many online tutorial, it is ok to see the dress,
VB SQL and Access even open a database connection string used in different, other database usage almost identical,
There is a time to learn about a day or two is about the same

So magic? Recommend which version of SQL server

CodePudding user response:

reference 5 floor qq_34304893 reply:

Quote: reference 1/f, stupid dog flew first response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, and then the foreign service, or use VPN to make into a network, but the speed even is not satisfying,

SQL server once something I didn't contact with the

Life is always a first time, study the bai, nothing lost again,

CodePudding user response:

The problem in contact I N years ago, something about my experience, 1. The adoption of WEB mode, remote access can be solved together with ASP, I did for a long time, (2) in SQL SERVER2000 + database, and the server, (3) to use VPN to solve

CodePudding user response:

refer to the eighth floor qq_34304893 response:

Quote: refer to 7th floor stupid dog flew first response:

Quote: refer to the fifth floor qq_34304893 reply:

Quote: reference 1/f, stupid dog flew first response:

Access public not, unless the file sharing of what, let's think about other way, such as network host, to summarize all the Access data in a SQL server, and then the foreign service, or use VPN to make into a network, but the speed even is not satisfying,

SQL server once something I didn't contact with the

Many online tutorial, it is ok to see the dress,
VB SQL and Access even open a database connection string used in different, other database usage almost identical,
There is a time to learn about a day or two is about the same

So magic? Recommend which version of SQL server

VB6 to cooperate the best should be to SQL Server 2000, but the compatibility between the database and the new operating system may not be too good, and the old system, more holes,
SQL Server 2005 and 2008, should be appropriate, and then try again after familiar with such high version.

CodePudding user response:

I remember there is a charge netAdo plugin can solve this problem, time is too long, names are forgotten

CodePudding user response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull