Strange problem with Dlookup on Network share Windows 7


N

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
 
Ad

Advertisements

S

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 <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top