Access & VPN

[Ady]

Hi All

Access
=====
I had a problem with Access 2000. As I was loading a picture (al OLE
object - I think!) I accidentally hit OK twice, and had an error or message.
I can not remember the exact message, but it was something along the lines
of "Restart your OLE server, or Restart your OLE service". Every time I
pressed OK the message it was re-appearing (looping). I had to control Alt
Delete to end Access

VPN
====
After this I tried to use my VPN connection to my computer at work. As soon
as it excepted my username and password it made the connection and then the
computer restarted!!! This now happens every time I try to connect!

The Microsoft error message makes reference to a looping:

STOP: 0x100000EA THREAD_STUCK_IN_DEVICE_DRIVER_M
CAUSE
This issue may occur if the display driver is caught in an infinite loop
while it waits for the video hardware to become idle.

========================

I think this problem is related to Access but am now not sure how to
proceed. If anyone can offer any help or advice it would be most welcome. Or
if they can tell me where I should be posting this report.

Many thanks.

Ady

 

[Arvin Meyer [MVP]]

On the server, if you find an LDB file with the same name as your database,
delete it. With a VPN connection, the problem can also exist on the server
or VPN client. You may have to reboot the server. You should also compact
and repair the database. If your database isn't split, do so immediately
after doing the repair.

In general, is unwise to use Access over a VPN connection unless you are
also using terminal services. The performance is poor and you take a big
chance on corrupting your data. With terminal services or Citrix,
performance is excellent, and properly set up there is almost no chance of
corruption.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Ady]

Hi There

Thank you for you answer, however I do not think I explained myself very
well. The Access DB was on my own PC. After I had finished and closed it
down, I then attempted to VPN to my works PC. However when I do this my own
PC restarts!

Help!

Regards

Ady

 

[Arvin Meyer [MVP]]

If Access won't shut down completely, it is usually due to a persistent
recordset variable that stays in scope, or a boolean variable that does the
same. Make sure that you close all recordset variables and set them to
Nothing when you are done with them.

Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("Whatever")
' ... do something
rst.Close
Set rst = Nothing

Make sure you explicitly use your boolean control variables:

Not: If chkWhatever Then
But: If chkWhatever = True Then

Then VPN problem is probably unrelated to Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access