Strange problem with Dlookup on Network share Windows 7

[nutraf]

Hi all,
I have a problem running a simple dlookup in my first form on my
access97 application.

The app is a client app with linked table on H: which is a network
share map with "riconnect on logon".

The client is running XP Pro sp3.

The file server is running Windows 7 Professional (32bit or 64bit same
error).

When I switch on my client PC I can get H: unit in My Computer without
red cross on it.

If I enter in my Access97 application i get Error in Dlookup field and
VBA Error 3044 using my code.

If i get back to My Computer and double-click on H: unit I can access
all the files in it. Then if I go back to my app and run again now
everything is fine.

This is very annoying for my customers. The problem is not present
with XP client to XP server configuration.

Have you experienced the problem?

Thank You in advance.
Rob

 

[Stefan Hoffmann]

hi,

This is very annoying for my customers. The problem is not present
with XP client to XP server configuration.

Client operating systems are not server operation systems.

The app is a client app with linked table on H: which is a network
share map with "riconnect on logon".

What does "reconnect" mean?

Your problem indicates that the shared drive is not available directly
after the boot process. Which is in fact different under Windows 7 in
comparision to Vista or XP. The shell is started while the "boot
process" still is in progress.

While I never had such a problem I would try some things:

1. Use e Win32_MappedLogicalDisk to check if the drive is mapped.

http://msdn.microsoft.com/en-us/library/aa394592(VS.85).aspx

2. Instead of a mapped drive use the UNC path.

3. If this does not solve the problem use a simple alive test before
accessing any data:

On Local Error Resume Next

Dim Test As String

Test = Dir("H:\file.txt")
If Err.Number = ?? Then
' Drive not ready. Retry..
End If


mfG
--> stefan <--