Slow connection Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have encountered a very strange problem
On a PC there is a VB.NET application that connects with an Access database on a Windows Server 2003
The connection to the server was very slow, because the DNS-address and the workgroup was different. So, now it should be faster than it was
However my application is still very slow (it's even "not responding" a lot of times)
Now the weird part: When I open Access on the PC where my application runs and I open the database that I also use in my application, my application runs as it should be ans responds okay

I have absolutely no idea what the problem is. The only thing I know is that when I open my database with Access, my application does everything fine

Hopefully someone has an answer
Thanks in advance

Best regards

Michiel Doeven
 
Access isn't a real client server db so this isn't surprising. I'd expect
that the Query would takemore time than opening the connection. Remember
that whatever you grab out of your select statement is going to be
transferred to your local machine if you are using a DataSet/Datatable. The
network could easily be a bottleneck too.

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/
Michiel Doeven said:
Hello,

I have encountered a very strange problem.
On a PC there is a VB.NET application that connects with an Access
Click to expand...
database on a Windows Server 2003.
The connection to the server was very slow, because the DNS-address and
Click to expand...
the workgroup was different. So, now it should be faster than it was.
However my application is still very slow (it's even "not responding" a lot of times).
Now the weird part: When I open Access on the PC where my application runs
Click to expand...
and I open the database that I also use in my application, my application
runs as it should be ans responds okay.
I have absolutely no idea what the problem is. The only thing I know is
Click to expand...
that when I open my database with Access, my application does everything
fine.
 
Thanks for responding William

While Access isn't really a client server db, it's able to act as one
You're answer does not explain why my application is so slow. I'm not querying huge amount of data to my application, however my application stops responding and you can not work with it. Sometimes it reacts, so I'm guessing my query is done at that point (but that takes approx. 20/40 seconds or longer)
Then, when I open Access and open the database I use, the Client wakes up and works fine, no problem at all

I think the solution must be found somewhere in settings of the Windows Server 2003 (?). I already made sure that the workgroups are identical and I filled out the primairy DNS. According to the network-administrator this should solve the speeding problem. To a certain point it does, because the database is a lot quicker accessible with Access. However, my application seems to slow down even more

Thanks in advance

Best regards

Michiel Doeve

----- William Ryan eMVP wrote: ----

Access isn't a real client server db so this isn't surprising. I'd expec
that the Query would takemore time than opening the connection. Remembe
that whatever you grab out of your select statement is going to b
transferred to your local machine if you are using a DataSet/Datatable. Th
network could easily be a bottleneck too

--
W.G. Ryan MVP Windows - Embedde

http://forums.devbuzz.co
http://www.knowdotnet.com/dataaccess.htm
http://www.msmvps.com/williamryan
 
Hi Michiel,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when opening an Access file in code
from a shared folder on a remote machine, there is a slow performance issue
while opening directly using Access don't. If there is any
misunderstanding, please feel free to let me know.

Generally, I think you have to check if the client machine has applied the
latest service pack for Jet 4.0. If not, please download and install it
from the following link. Please choose which to install according the
client machine's OS.

http://www.microsoft.com/downloads/results.aspx?productID=&freetext=jet+4.0+
sp8&DisplayLang=en

After applying that, if the problem still persists, here are some KB
article for troubleshooting this kind of problems.

http://support.microsoft.com/?id=150384
http://support.microsoft.com/?id=240434
http://support.microsoft.com/?id=264239

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
¤ Hello,
¤
¤ I have encountered a very strange problem.
¤ On a PC there is a VB.NET application that connects with an Access database on a Windows Server 2003.
¤ The connection to the server was very slow, because the DNS-address and the workgroup was different. So, now it should be faster than it was.
¤ However my application is still very slow (it's even "not responding" a lot of times).
¤ Now the weird part: When I open Access on the PC where my application runs and I open the database that I also use in my application, my application runs as it should be ans responds okay.
¤
¤ I have absolutely no idea what the problem is. The only thing I know is that when I open my database with Access, my application does everything fine.
¤
¤ Hopefully someone has an answer,

Sounds like you need to get the networking folks involved in finding the bottleneck. I highly doubt
that it is a database problem.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hello,

Sorry for my late respons.
The problem has not been solved yet. When opening the database with Access it takes forever (well ten seconds or so), but after that everything's fine. My applications takes even longer, but it remains a long time everytime I have to access the database.
If my applications is running (slowly) and I then open the database with Access, my application gets a boost and start running normally.

I still do not hav a clue what's going on here..

Thanks in advance,

Best regards,

Michiel Doeven
 
Back
Top