雖然這篇Recordset Open鄉民發文沒有被收入到精華區：在Recordset Open這個話題中，我們另外找到其它相關的精選爆讚文章
[爆卦]Recordset Open是什麼？優點缺點精華區懶人包
你可能也想看看
搜尋相關網站
-
#1ADO 記錄集的Open 方法
recordset.Open Source, ActiveConnection, CursorType, LockType, Options. 參數. 來源選擇性。 判斷值為有效的命令物件、SQL 語句、資料表名稱、 ...
-
#2rs.open的參數整理| topcat 姍舞之間的極度凝聚 - 點部落
當我們在撰寫asp的時候，結合資料庫難免會用的ADO的RecordSet物件. 常常寫著rs.open sql,conn,3,3. 但是那些數字代表什麼意義呢....整理如下 ...
-
#3ADO Open Method - W3Schools
The Open method opens a database element that gives you access to records in a table, the results of a query, or to a saved Recordset.
-
#4ADO >> Recordset >> Open | DevGuru
The Open method is called on a Recordset object to open a cursor which gives you access to the records contained in the base table, the results from a query, or ...
-
#5The Recordset Object Open Method - Documentation & Help
Everything you need to open an ADO Recordset is built into the Open method. You can use it without explicitly creating any other objects.
-
#6ADO 教學課程
若指令傳回整列資料，將資料列儲存在儲存物件 (Recordset)。 ... Execute 以及Recordset.Open。這是它們在Visual Basic 的語法：. connection.
-
#7資料庫連接
CreateObject(“RecordSet”) %>. 三、連結資料庫Connection. 連結資料庫. <% Set cn=Server.CreateObject(“ADODB.Connection”). cn.Open “Provider=Microsoft.Jet.
-
#8adodb.recordset.open(rs.open)方法引數詳解- IT閱讀
這篇文章主要介紹了adodb.recordset.open(rs.open)方法引數詳解,需要的朋友可以參考下. ADO Recordset 物件. ADO Recordset 物件用於容納一個來自資料 ...
-
#9C# (CSharp) ADODB.Recordset.Open Examples
Recordset.Open extracted from open source projects. You can rate examples to help us improve the quality of examples. Programming Language: C# (CSharp).
-
#10VBA Error with Recordset, .open doesn't work - Stack Overflow
Update 12/20: put [] around table name. Another option is the following approach: Option Explicit Sub ConnectTODB() 'early binding Dim CustomerTEST As ADODB ...
-
#11rs.Open 參數整理@ 程式 - 隨意窩
來源http://blog.blueshop.com.tw/topcat/archive/2005/09/02/11655.aspx語法Set Rs = Server.CreateObject("ADODB.Recordset")Rs.Open Sql, Connection, [CursorType, ...
-
#12資料庫連結Connection的寫法 - iT 邦幫忙
Open Application("conn") sql ="select A from B" Set rs1 = Server.CreateObject("ADODB.Recordset") rs1.Open sql, conn , 1,1,1 do while not rs1.EOF.
-
#13RecordSet - VBA Databases - BetterSolutions.com
The Recordset.Open method specifies either a connect string or Connection object operand, or uses the Connection object set in its ActiveConnection property. In ...
-
#146.7.1.1 ADO: rs.addNew, rs.delete, and rs.update
Recordset Dim fld As ADODB. ... Open 'create table conn. ... Open "select * from my_ado", conn, adOpenDynamic, adLockOptimistic rs.AddNew rs!ID = 8 rs!
-
#15Recordset.Open Method - ADO: ActiveX Data Objects [Book]
Name Recordset.Open Method — (Versions 2.0, 2.1, 2.5, 2.6) Synopsis recordset.Open Source, ActiveConnection, CursorType, LockType, Options The Open method ...
-
#16VBA / Excel / Access / Word - Recordset Open - Java2s.com
Opening a Recordset Based on Criteria : Recordset Open « Access « VBA / Excel / Access / Word.
-
#17sql-docs/open-method-ado-recordset.md at live - GitHub
Opens a cursor on a Recordset object. Syntax. recordset.Open Source, ActiveConnection, CursorType, LockType, Options ...
-
#18離線的ADO Recordset - 成大醫院
Open Set rs = New ADODB.Recordset rs.CursorLocation = adUseClient '一定要設成Client端的cursor. Set rs.ActiveConnection = cn rs.Open strSQL, cn, adOpenStatic ...
-
#19(四) Recordset 物件的Open 方法
進行交易處理時，通常將資料庫啟成排他性。 二、 ASP環境下使用ADO物件之Recordset Open 方法. 指令：rs.Open [SQL指令], [資料庫連線], [資料集類型], [記錄鎖定類型].
-
#20Working with ADO Recordsets - MS-Access Tutorial
adOpenKeyset, Returns a Keyset cursor. This is roughly analogous to a DAO dynaset. If you are using ADO to open a recordset against a source in an Access .accdb ...
-
#21ADO Example--Open an ADO recordset object using a URL
This example uses a URL to open an ADO recordset. The key point is to specify the "URL=" prefix. That instructs ADO to use the root binder to locate the OLE DB ...
-
#22How to work with recordset (Dao) in MS Access - Code VBA
Open a recordset · Create a new Recordset from a table or query in your database · Use the Recordset property of an Access object, such as a bound Form · Clone an ...
-
#23Recordset Open taking a long time | MrExcel Message Board
now if i run this same query in Excel using open recordset it takes around 4-5 minutes to run rs.Open sqlString is the part it takes ages
-
#24Access VBA Recordsets - Open, Count, Loop and More
OpenRecordSet method to open/create our Recordset. In order to create a Recordset that will allow us to manipulate the data in the table called ProductsT, we ...
-
#25ADO Recordset（记录集） - 菜鸟教程
创建一个ADO 表记录集（ADO Table Recordset） 在ADO 数据库连接创建之后，如上一章所述，接下来就可以建立一个ADO 记录集了。 ... Open "c:/webdata/northwind.mdb"
-
#26VBScript - Open Two Recordsets - VbsEdit
Open Two Recordsets Const adOpenStatic = 3. Const adLockOptimistic = 3. Set objConnection = CreateObject("ADODB.Connection")
-
#27Asp： Open 方法(ADO Recordset) - CSDN博客
recordset.Open Source, ActiveConnection, CursorType, LockType, Options. 参数. Source 可选，变体型，计算 Command 对象的变量名、SQL 语句、表 ...
-
#28Data.Win.ADODB.TCustomADODataSet.Recordset
Provides direct access to the ADO Recordset object. Recordset is the interface through which the records of an ADO dataset are accessed. When you open an ...
-
#29關於access中使用ADO的Recordset的open方法時各蔘數的説明
用ADO的recordset打開錶時，有多箇蔘數選擇，open方法語法如下： Open Source, ActiveConnection, CursorType, LockType, Options.
-
#30the recordset object open method - Translation into Japanese
データ ソースで実行されるコマンドを指定する文字列は、Connection オブジェクト Execute メソッドの CommandText パラメータ、および Recordset オブジェクト Open ...
-
#31adodb.recordset.open方法- 程序员秘密
Recordset.Open 中参数的用法标签： 存储sql 2008-09-29 14:55 8503人阅读评论(0) 收藏举报本文章已收录于： 版权声明：本文为博主原创文章，未经博主允许不得转载。
-
#32ADO RecordSet Populate - AutoIt Wiki
The Open method is called on a Recordset object to open a cursor which gives you access to the records contained in the base table, ...
-
#33ADODB Recordset - VBA for smarties
Open saves the database structure. You can't adapt the saved structure. With CreateObject("ADODB.Recordset") .Fields.Append "text_001", ...
-
#34VBA/Excel/Access/Word/Access/Recordset Open - VB Эксперт
Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic rst.LockType = adLockOptimistic rst.Open "Select * from Employees", ...
-
#35ADO recordset open方法解析 - 台部落
Open 方法. recordset.Open Source,ActiveConnection,CursorType,LockType,Options. Source Recordset對象可以通過Source屬性來連接Command對象。
-
#36ADO Recordset Object Open Method - Webmasters.com
Opens a cursor. Open Method Syntax. recordset.Open Source, ActiveConnection, CursorType, LockType, Options. Open Method Parameters. Source. An optional Variant ...
-
#37Determining (in VBA) if a recordset is open - Bytes Developer ...
Determining (in VBA) if a recordset is open. Microsoft Access / VBA Forums on Bytes.
-
#38C#中如何用ADODB.Recordset.Open（）操作Access数据库！！
Recordset.Open（）操作Access数据库！！ 这是我的代码ADODB.RecordsetServerRs=newADODB.Recordset();stringSSql=SLikeR1(value,fid);//查询语句ServerRs.
-
#39DevGuru ADO Recordset::Open Method - Windows@EPFL
Open Source, ActiveConnection, CursorType, LockType, Options The Open method is called on a Recordset object to open a cursor which gives you access to the ...
-
#40ADO Recordset（记录集） - w3school 在线教程
Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/webdata/northwind.mdb" set rs=Server.CreateObject("ADODB.recordset") rs.Open "Customers", conn %> ...
-
#41VB数据库连接recordset open的语法(转) - 小芹菜- 博客园
VB数据库连接recordset open的语法(转). 下面是我所掌握的使用ADO对数据库操作的一些常用方法，主要是提供给初学者作为参考，有不对的地方请指正。
-
#42adodb.recordset.open(rs.open)方法参数详解 - 脚本之家
这篇文章主要介绍了adodb.recordset.open(rs.open)方法参数详解,需要的朋友可以参考下.
-
#43Recordset 对象
recordset.Open Source, ActiveConnection, CursorType, LockType, Options ... 刷新Recordset 对象中的所有记录，包括由于当前Filter 属性设置而隐藏的记录。
-
#44RecordSet.Open - CodeProject
Hi all, i'm using code to convert dataset to recordset and i want to know what is the error at this line, after i running it the recordset still ...
-
#45ADO recordset open SQL statement. Error when table name ...
The recordset.open method returns an error. The object MyTable_New is not recognized. There is no error when the tablename is MyTableNew.
-
#46Thread: Excel 2007 crash on ADODB Recordset open
The crash happens when I try to open the recordset (bolded in the code below) The Excel file has two sheets, Report & DB with the macro in ...
-
#47Testing DAO Recordset Open - UtterAccess.com
Testing DAO Recordset Open. 2010/06/07 06:37 am. Post # 1. jleach; UA Administrator; Posts: 11,099; Joined: 2009/12/07.
-
#48ADO编程RecordSet.OPEN参数解释 - 闻心阁
继续纠结ADO编程，基于OLE DB的ADO编程的确很方便，这几天一直在折腾这个ADO，所以见到不懂的就记录一下。在使用ADO的RecordSet中有个OPEN函数， ...
-
#49check if a recordset is open - Microsoft - Tek-Tips
Dim rst1 as new adodb.recordset, rst2 as . ... But rst1.open is not the valid procedure, anyone knows how to check for open recordsets?
-
#50ADODB Recordset.Open giving syntax error excel to SQL - py4u
Open strSQL, cnt, adOpenStatic, adLockReadOnly, adCmdText ... Recordset Set cnt = New ADODB. ... Recordset Dim strSQL As String 'Open connection cnt.
-
#51adodb.recordset.open(rs.open)方法参数详解 - html中文网
这篇文章主要介绍了adodb.recordset.open(rs.open)方法参数详解,需要的朋友可以参考下.
-
#52Classic ASP - Ado Recordset Open() - Genera Codice
Classic ASP - Ado Recordset Open() ... I am running into an error when I try to open a connection to the database. ... Open sql, connectstring, 3.
-
#536.7.1.1 ADO: rs.addNew, rs.delete, and rs.update - MySQL ...
Recordset Dim fld As ADODB. ... Open 'create table conn. ... Open "select * from my_ado", conn, adOpenDynamic, adLockOptimistic rs.AddNew rs!ID = 8 rs!
-
#54Solved: ADODB - Syntax error when trying to open a records...
Solved: Hi I am trying to update a record in a sql server database table and when i try and open up a recordset using adCmdTable parameter i get.
-
#55Open of ADO Recordset failing, no clue why - access ...
[SOLVED] Open of ADO Recordset failing, no clue why I have been having quite a fight this morning with accessing a table in my FE DB via an ...
-
#56recordset.open method not available | Toolbox Tech
I have in one project: dim rst as Recordset set rst = new ADODC.recordset rst.Open , , ... I try to do the same in another ...
-
#57Recordset.Open参数说明_id_999 - 新浪博客
recordset.Open Source, ActiveConnection, CursorType, LockType, Options. 参数说明: Source 可选，变体型，计算Command 对象的变量名、SQL 语句、 ...
-
#58Introduction to ADO Recordsets - Office 2003 VBA - Visual ...
Let's return to the syntax of the recordset's Open method, which specifies the parameters. Needless to say, you need to know what each parameter ...
-
#59FiveTech Software tech support forums • View topic
oRs:Open() I get this error on the last line above: Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: OPEN.
-
#60ASP中RecordSet Open和Connection.Execute一些區別與細節 ...
ASP中RecordSet Open和Connection.Execute一些區別與細節分享. 阿新• 來源：網路 • 發佈：2020-08-26. rs.open sql,conn：如果sql是delete,update,insert則會返回一個 ...
-
#62Datatype mismatch when trying to execute Recordset.Open ...
Whenever my code gets to the Recordset.Open statment, it stops with the error message that I have a run time error that is described as a ...
-
#63Recordset Open method freezes - Database and File IO - LAVA
Dear LabVIEW enthusiasts, Our application uses .NET methods to access a SQL Server Express LocalDB database. It works, since we do manage to ...
-
#64ADODB.recordset open实参 - 张生荣
ADO Recordset 对象ADO Recordset 对象用于容纳一个来自数据库表的记录集.一个Recordset 对象由记录和列(字段)组成. 在ADO 中,此对象是最重要且最常用于对数据库的数据 ...
-
#65[ psqlodbc-Bugs-1000660 ] Problem with ADODB.Recordset ...
[ psqlodbc-Bugs-1000660 ] Problem with ADODB.Recordset.Open in a table with numeric and bytea or text fields. From: <noreply(at)pgfoundry(dot) ...
-
#66Microsoft Access VBA - Lesson 26: ADO and Record Sets
The primary way of creating a record set is to declare a variable of type Recordset. ... If you are calling the Open method of a Recordset object, ...
-
#67Vba adodb command parameters - Skrupa Law Office
7 - ADO Commands and Stored An ADO Recordset is then obtained for the new table and data is added by using the AddNew/Update methods. Open Set cmd = New …
-
#68VB中recordset的用法 - 51CTO博客
Set Rs = Server.CreateObject("ADODB.Recordset") Rs.Open Source, ActiveConnection, CursorType, LockType, Options 参数. Source 选择性参数：
-
#69ADODB recordset.open is duplication records - Super User
Since by mistake duplicate records has been entered ( as you have written in Comments above ) therefore, instead of deleting records you may ...
-
#70Excel VBA tip 7: Create a recordset based on 2 different ...
In this post, you'll learn how to create a recordset based on data from 2 ... Copy cells with VBA; Add data to a table; Open a file and ...
-
#71Best Ms Access Open Recordset - Registerfinder
Database.OpenRecordset method (DAO) | Microsoft Docs. best docs.microsoft.com. You should also use the dbSeeChanges constant if you open a Recordset in a ...
-
#72How to use a Stored Procedure to return a recordset in a ... - IBM
Connection Set resADO = New ADODB.Recordset conADO.Open strConnection resADO.Open "Execute function customer_name()", conADO, , , adCmdTxt
-
#73Type mismatch in ADO Recordset Open | PC Review
expression" error when I try to open the recordset with the query below: Dim cnn As ADODB.Connection Dim rstview As ADODB.Recordset
-
#74將sql command傳入Recordset.Open之後，出現型態不合訊息 ...
當我將一個sql command傳入一個Recordset.open之後，發生型態不合的錯誤訊息，好像是Recordset物件無法辨別這個字串；之前在英文NT Station4.0發生， ...
-
#75SQL statements and recordset.Open | Microsoft Office Forums
I am trying to use the recordset.Open command to run an SQL statement. The book a I am reading has this for an example: Dim rst As ADODB.Recordset Set rst.
-
#76Connections and Recordsets The ASP Versions
open uses the open connection for its credentials (DSN, useid, and password). The recordset still has to be created with a Server.CreateObject.
-
#77ASP errors when accessing a database - ICT Seneca
Use this to open an updatable record set: rs.Open sql,conn,3,2. Error Type: (0x80020009) Exception occurred. You are trying to access a RecordSet column but ...
-
#78Read Text Files Into a Recordset - FreeVBCode code snippet
This code shows you how to use ADO and the ODBC text driver to open a text file an read it into a recordset. There are two connection strings.
-
#79adodb.recordset.open(rs.open)方法参数详解 - 华域联盟
adodb.recordset.open(rs.open)方法参数详解 · set objRecordset=Server.CreateObject("ADODB.recordset") · 想了解更多ADO Recordset 对象的朋友可以到这里 ...
-
#80Microsoft Access: ADO Programming Code Examples - Allen ...
Index of Functions, Description. ShowSchema(), List the tables. AdoRecordsetExample(), Open a recordset. CreateViewAdo(), Create a new query.
-
#81ADODB.Recordset.Open 中参数的用法_ivbapplication的专栏
Recordset 对象的Open方法原型：Open（[Source],[ActiveConnection],[CursorType],[LockType],[Options]）CursorType游标类型：Const adOpenForwardOnly = 0 前向游标， ...
-
#82Method 'Open' of object '_Recordset' failed - P2P Wrox
Default Method 'Open' of object '_Recordset' failed ... Function MySQL_Query(SQL As String, DataBase As String) As ADODB.recordset
-
#83'Open record set' button now missing for activities...
Then in the UI this was replaced with the 'Open record set' button in the top left of the activity form, as demonstrated on Accounts here:.
-
#84Recordsets - Macoratti.net
O objeto Recordset esta presente tanto na DAO como na ADO. ... Se você precisar criar recordsets atualizáveis deve usar o método OPEN do objeto Recordset da ...
-
#85What are Recordsets | Access All In One
When we open a recordset, the recordset itself is stored in memory and we are able to loop through the records one at a time, manipulating the data as we go ...
-
#86ADODB Connection in .NET Application Using C#
IN THIS PROGRAM SHOW HOW TO RETRIEVE RECORD USING ADODB RECORDSET ... Recordset rs = new ADODB.Recordset(); ... Open(sql, conn, ADODB.
-
#87ADODB Recordset.Open給語法錯誤擅長於SQL - 優文庫
Open STRSQL 我已經試過了線得到一個語法錯誤與rst.Open strSQL，cnt ... Recordset Set cnt = New ADODB. ... Recordset Dim strSQL As String 'Open connection cnt.
-
#8810+ mistakes to avoid when using VBA Recordset objects
The Recordset object is an essential component in Access ... An open Recordset, especially in older versions of Access, can hang things up.
-
#89Recordset.OpenRecordSet - Access - SS64
Open a new Recordset. This allows you to navigate a set of records (or rows) in a table.
-
#90Keeping RecordSet Open - Microsoft VBA
In my program, I am setting a RecordSet(RS) Source. Then I open the RS, and load the frist 25 records into my form. All that works okay.
-
#91How to Use Recordset in MS Access - iAccessWorld.com
A Dynaset may be a query. Like a table, a Dynaset is updatable if file is not locked or open for read only. Data in Dynaset is live that is ...
-
#92ADO recordset does not open after executing stored procedure
In my Access front end VBA code opens ADO recordset from stored procedure on remote SQL Server 2008. It worked OK for 2 years and SUDDENLY ...
-
#93Excel vba recordset to array - Glotech Academy
Then open a recordset using the SQL from your query, and then use a DoLoop to load the recordset values into an array. dbf database which is located in the ...
-
#94Simple Recordset Query Search , Access VBA - Software ...
Recordset object you may need to add reference to ADODB object library. ... The above method will open a recordset with the fields specified ...
-
#95recordset.Open strSql, Conn, 3,3 - 阿里云开发者社区
原型：. recordset.Open Source, ActiveConnection, CursorType, LockType, Options. 参数详解：. 第一个参数：sql 即SQL语句. 第二个数：conn 即数据库的连接.
-
#96Ms access vba delete record - Hermann Wilhelm Schäfer
htmlThis tutorial teaches you how to Add, Edit, Access VBA Recordsets – Open, Count, Loop and More In this tutorial, we will learn how to open a Recordset, ...
-
#97Access 2007 Programming by Example with VBA, XML, and ASP
You can open an ADO Recordset by using the Recordset object's Open method. The information needed to open a recordset can be provided by first setting ...
-
#98VB6 RecordSet.Open + TimeOut - Google Groups
calling recorset.open, - with adOpenForwardOnly if the recordset is just used to be read only - with adOpenKeyset and adLockOptimistic if ...
recordset 在 吳老師教學部落格 Youtube 的精選貼文
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統
recordset 在 吳老師教學部落格 Youtube 的最讚貼文
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統
recordset 在 吳老師教學部落格 Youtube 的最佳貼文
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統