Clever Geek Handbook

Are there VB.NET database access databases?

A grab on straws here ... I'm working with a VB6 desktop system using multiple Access 2003 (.MDB) databases. I recently changed the first function from VB6 to VB.NET while still using an Access database. That's more than a conversion, but rewrite with additional functionality. This is still quite simple functionality with a low volume database. We have 1400 clients, small businesses with different machine qualities. Most customers are happy with the new screen and functionality. Very few of these clients have experienced the extra slow loading of the datagridview. Customer service informs us that 1) the machines have at least 1GB of RAM and 2) a reboot always solves the problem.

I wrote an application to slow down my machine a lot, and this STILL works better for me than for those few clients. Also, my Access database has never been destroyed by this application.

Any suggestions?

Thank!!

+1


source to share


4 answers


Reloading while updating the access database can destroy it.

You need more information so you can better understand what's going on. They need to gather some information for you on the workstation that is having the problem. Using the task manager, you can get the following information:

  • CPU usage
  • What task consumes most of the processors
  • Peak (dedicated) memory on XP - no Vista equivalent li>
  • Shared (allocated) memory on XP - no Vista equivalent li>
  • Available (physical) memory on XP - free on Vista (made useless by Superfetch)

It is also possible to use the "SYSTEMINFO" command line tool for XP and Vista to get Total and Available memory. If you have very few available and on XP, if your total is larger than your Total Physical, then you are most likely swapping and running out of memory (or memory leak) is slowing things down.



Bottom line - you need more information. It might be another application on the workstation that is causing the problem. We had a situation where Notes 5.0 had a problem, if most of the window is covered by another window, and you received a new mail message, then the cpu usage on Notes went 100%. This caused the apps to run slowly, and unless you are at the workstation staring at the task monitor, you never knew it was a recording problem. The problem was always caused in another program (the one in the foreground). Access can also use 100% CPU in different modes, even if it does nothing.

Gather as much information as possible. You might want to write a vbscript or program that will gather some information for you so that anyone with a problem can run it to gather information before rebooting.

A batch file that does the following will give you quite a bit of information:


@echo off
SystemInfo  >c:\systeminfo.log
tasklist /v >>c:\systeminfo.log
+2


source


We have similar experience, most cases are caused by antivirus. They check the file VERY often (some antiviruses every access to the file).



+2


source


No, VB.Net works great with Access. In SHARED environments, there will be file access.

Since rebooting solves the problem, I would check that you are closing your connections correctly.

0


source


Sounds like a big memory leak to me.

Some clients will leave your application longer than others and be heavier.

Using Access where there are multiple concurrent users is inevitably painful.

-1


source






More articles:


All Articles