Do the graduation design, it is in the machine, using the access database, function is the administrator login later can enter the students information, employment information, etc., these students can see after landing information, but I learn less time, don't know how to put the system connected to the Internet, let the student after download exe can use,,, ace to give directions ~ ~ ~ ()

CodePudding user response:

Using ado to connect

CodePudding user response:

reference 1st floor sfl88888 response:

using ado connection

Probably you don't know what I mean is now both administrators and users, the system can only be done on my computer, I want to ask, how to connect to each place user just download the exe file, you can into the system, you can see the administrator to update information, feeling with network database, but after the download how to connect to? Right is similar to QQ, based on UDP protocol can be achieved?

CodePudding user response:

1, can be found on the Internet, your computer needs to have a fixed IP or with peanut shells and other tools,
2, want to use MSSQL database, or other online data, using the ACCESS with three layers of software is required to implement,
The original poster can try first online database implementation within the local area network (LAN), then try to put on the Internet,

CodePudding user response:

Temporarily open a network connection with the words you can!
With no difference in the local!
But more dangerous!

CodePudding user response:

According to the requirement as you describe only the database on the public has nothing to do with the UDP, rent a server, and get a free trial (online a lot of trial 1 month)

CodePudding user response:

The building Lord, your question is as follows:
1, you chose to access database, in general, the access is suitable for the stand-alone version, if you must implement the other students can access your access, personal feel that there is only one way,
Is to put your hard disk access database directory Shared out, others mapping your hard disk directory, then run your exe file operations,
This should not be what you want,

2, if you want to realize the web/Internet access to your access, then you have to do a server, and then do a B/S system, through B/S system to access your access,
This method can't seem to by your exe files,


So, you must confirm that your development framework, or B/S system, either a C/S system, you want to use C/S system to achieve B/S system is not ah, personal opinion, please correct me warrior,

In my opinion, you visit access database development EXE software, is clearly a C/S system, so can't through the Internet to access your access database,
If you take a step back, as long as the implementation within the local area network (LAN), so the fastest way is to I said the first approach, in fact, local area network (LAN) student system, formal, exe + network database, such as: SQL

If you have to realize the Internet, then will develop B/S system,

The hope can help you,

CodePudding user response:

datasnap

CodePudding user response:

To request is operating on the Internet so you develop your software system for B/S
Delphi intraWeb mode and ExpressWeb mode can help to you

Now that all development B/S system. Why don't use JAVA and.net?

CodePudding user response:

On the network using the ACCESS system, the database is too small, if you want to achieve, I can help you

CodePudding user response:

If only for the test can be used to ACCESS the
If a large project, it is recommended to use MSSQL, like ORACLE, MYSQL

CodePudding user response:

Use Delphi WebService technology or Com component technology, if Delphi is high version, version 2009 or more, you can use DataSnap, you can also use third-party RO technology, etc.,

CodePudding user response:

On the third floor of feasible
You can use your computer from test
1, a computer can connect to the Internet
2, do a fixed IP (peanut shells) such as your local IP: 127.0.0.1 after fixed: 221.45.68.17
3, when ADO connection directly fill in the fixed IP can!
Regardless of security, no technical content.

CodePudding user response:

The ACCESS database, let others to see through the network, or even edit, written in ASP website, thus achieve the purpose of you
The user in the browser is open

CodePudding user response:

The use of a peanut shells in the dynamic analysis, using ado package, only is theoretically possible, also may consider many concrete implementation, such as safety problems
Access the remote connection to access this file exposed, such security can't guarantee
2, the efficiency problem, access the network directly connected, the client direct database operation, in the big data retrieval, browsing will cause interface can't response for a long time, therefore, must use three layer technology, build the middle server to handle
More than 3, synchronization problems, database operation, to ensure data security, the need for data synchronization and lock, and this would have been unthinkable in the Internet,,

So 1, database change essentially 2, create an application server to process the data, and 3, using peanut shells to parse,

CodePudding user response:

Problem, graduation design need not make so big ah,

CodePudding user response:

The Access cannot be directly connected to the Internet, only do three layer