-
Anonymous users2024-02-061. Create an access database and create a new table in the database—that is, an additional table. By setting the property values of the attached table, make it linked to the database you want to access.
The program is as follows: dimdbasdatabase dimtdasnewtabledef setdb=opendatabase("") "dbase:database=c:
datadir" "au thor" "dbaseauthortable"Step 2: Set the ini file path. If the Access to Foreign Database operation is used in the VB program, an ini file must be provided after the application generates an exe file.
If the ini file cannot be found, the database cannot be accessed and the error message "notfoundin stollabkisams" will appear. After setting the INI file path, VB's program will look for the INI file with the same name as the application in the Windows subdirectory. Set the ini file path to:
setDataAccessOption1,"Path FileName" III:. The ini file can be used to set different kinds of databases, and the following is an ini file**: options systemdb=c:
mypath\ 〔isam〕 pagetimeout=5 maxbuffersize=128 lockretry=20 commitlockpetry=20 readaheadpages=16 〔installableisams〕 :vb\ :vb\ :
vb\ dbase=c:\vb\ dbase=c:\vb\ btrieve=c:
vb paradoxisam pagetimeout=600 paradoxusername=baiuser paradoxnetpath=p: pdxdb collatingseguence=ascii dbase centry=off data=american mark=47 deleted=on This is done by accessing the new database and table "dbaseau thortabk" to access the external database you want to access. When using this method to access a foreign database, it should be noted that the attached table only establishes a link relationship in the database to which it is added, and the actual location of the table still exists in the original database, and when the table is deleted in the database to which it is attached, only the link relationship is deleted, and the actual table is not deleted.
-
Anonymous users2024-02-05VB is just a programming language for BAI, and it cannot be built.
Du Li Data Zhi
library, and the creation of the access database should be completely carried out in access.
Prerequisites: Microsoft Access database must be installed.
Steps: 1. Find the path where you want to store the database, such as the data path of disk C;
3. At this time, there is an access file under the path, which can be right-clicked and renamed to name the database, for example, name it as the test database;
4. Double-click the access file to create the desired table, function, etc.
You can make an information query system, if you haven't done it before, it is recommended to use ASP to write it first, this is relatively simple, even people who do not have a basic knowledge of network programming can get started in a short period of time. The written web program can be called on the network, and different permissions can be set for different users. In this way, you can achieve the function you want, but this is only the basic, and you should learn more deeply to achieve more complete functions. >>>More
Contact 26819801 and I'll take a look at that for you.
select ,from emp e left jion dept don ;
Left Company. The left link is, the left side prevails, and the right side is useless to make up for it. >>>More
The prospect of learning UI is good, and there are many training institutions, so the local people may choose to visit and understand the real teachers and educational strength of the school before making a choice. Share the general development of the UI, I hope it will be useful to you. >>>More
The database is generally composed of many tables, for example, the school builds a database, which can build a student table (including the student's name, age, student number, class, date of birth), a teacher table (including the teacher's name, age, teaching class, teaching category), a report sheet (including the student's student number, and the grades of each subject), etc. These are the ways in which the files are stored in the database, and try to make sure that the items in a table are closely related and have the same attributes, if this condition cannot be met, a table must be built (the redundancy of the built table has 4 levels). In order to meet the user's query needs, we also need to make a number of views, for example, you can make a view of his items have the name of the student, age, grades of each subject, and the teacher of each subject, etc., we can also export new items according to the existing items, for the purpose of simplicity, for example, the view can add an average grade, we add different permissions and roles to each view, and provide it to different people to query to protect the security of the database. >>>More