By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,040 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,040 IT Pros & Developers. It's quick & easy.

Access 97 working slowly...???

P: n/a
Access 97 working little slowly. I have windows 2000. The computer is
old..processor is about 300 MHz and RAM- memory capasity is ~164 Mb.
Hard disk is 3.0GB.

I have only three tables which are similar. In a table is two fields
"date" and "barcode".

I am use MSComm - object, I receive the barcodes from virtual com -
ports. When the data incoming to COM port I calling "AddScanRecords".
The code is same in everyform.

Access 97 working little slowly. I have windows 2000. The computer is
old..processor is about 300 MHz and RAM- memory capasity is ~164 Mb.
Hard disk is 3.0GB.

I have only three tables which are similar. In a table is two fields
"date" and "barcode".

I am use MSComm - object, I receive the barcodes from virtual com -
ports. When the data incoming to COM port the code on below
opening...The code is same in every form.

Private Sub MSComm1_OnComm()

Dim buffer As String
Dim T1 As Single

buffer = MSComm1.CommEvent
T1 = timer

Do Until buffer = 2
If timer - T1 2 Then Exit Sub
Loop
Call AddScanRecords

End Sub
Sub AddScanRecords()

Dim db As Database, rs As DAO.Recordset
Dim StartTime As Date

StartTime = Now()

Set db = CurrentDb
Set rs = db.OpenRecordset("Table1")

rs.AddNew
rs![BarCode] = MSComm1.Input
rs![ScanDate] = Now()
rs.Update

rs.Close
db.Close
End Sub

Is the database slow because I don't use asynchronous method to open
the database?

How can I open the database using asynchronous method?

Please help me!

Aug 14 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.