Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mdb too slow for vb. cannot refresh screen.

 
   Database Help (Home) -> Visual Basic -> ADO RSS
Next:  How to insert a 100000 records in access table wi..  
Author Message
user3479

External


Since: Jan 27, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 14, 2005 3:40 am
Post subject: mdb too slow for vb. cannot refresh screen.
Archived from groups: microsoft>public>vb>database>ado (more info?)

I fill the Janus Gridex Component with a table. (don't worry problem is not
related with component. I tried listbox also). Then I add a record with
rst.addnew/rst.update methods.

When I call .rebind method to refresh grid, nothing happens. if I refresh it
after 2 seconds, it works. if I put a messagebox that says "new record
added" and gain time, it also works.

But if I refresh grid immediatelly after rst.addnew/rst.update methods, old
recordset comes to screen. same problem also exists in rst.update and
rst.delete methods.

Strange thing is this problem doesn't exists in SQL server. in all form, I
use one adodb.connection and also I tried cn.begintrans / cn.committrans and
wait until cn.state <> adexecuting. it didn't work.

and help please ? thanks.

 >> Stay informed about: mdb too slow for vb. cannot refresh screen. 
Back to top
Login to vote
Wart

External


Since: Jul 28, 2004
Posts: 7



(Msg. 2) Posted: Mon Feb 14, 2005 12:40 pm
Post subject: Re: mdb too slow for vb. cannot refresh screen. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Aykut,
It is a kludge, but a delay tactic like the one you are using is the only
way to get around the slowness of the MDB platform that I know of. As the
MDB gets bigger, the delay will become longer, so I have resorted to closing
and requerying after adding a record(s) when using MDB database
applications.
CF

"Aykut Canturk" wrote in message

 >I fill the Janus Gridex Component with a table. (don't worry problem is not
 >related with component. I tried listbox also). Then I add a record with
 >rst.addnew/rst.update methods.
 >
 > When I call .rebind method to refresh grid, nothing happens. if I refresh
 > it after 2 seconds, it works. if I put a messagebox that says "new record
 > added" and gain time, it also works.
 >
 > But if I refresh grid immediatelly after rst.addnew/rst.update methods,
 > old recordset comes to screen. same problem also exists in rst.update and
 > rst.delete methods.
 >
 > Strange thing is this problem doesn't exists in SQL server. in all form, I
 > use one adodb.connection and also I tried cn.begintrans / cn.committrans
 > and wait until cn.state <> adexecuting. it didn't work.
 >
 > and help please ? thanks.
 >

 >> Stay informed about: mdb too slow for vb. cannot refresh screen. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
runtime error 3021 and user permissions - I have a VB6 application that uses ADO 2.7 to access an Access2000 database. I have found on Windows XP and 2000, that if the user is not part of the administrators group, they receive: "runtime error 3021. Either BOF or EOF is true, or the current ...

updatable ado-recordset - Hi, In the code below i have an updatable ado-recordset. However it is not working how i thought it would be. Maybe someone can help me out here? The global connection (Thanks to Brendan): Option Compare Database Option Explicit Public mconn As..

ADO Connection Access Database VB - I have been accessing a database on a local drive thru an ADO connection. The following is the code that I have been using. cnCejco.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Y:\Cejco.mdb;Persist Security Info=False" The problem is n...

DataReport PageBreak - Hi everyone, I would like to know how to force pagebreak in a datareport for example after 5 records printed. Thank you all

Recordset-adding to a Listview - I've got a weird problem - - - it must be something simple, but for the life of me, I must be missing it... I've got a recordset - and I'm trying to add the results into a listview, but, instead of adding each successive record after the first line of....
   Database Help (Home) -> Visual Basic -> ADO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]