UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> error 3044    
 
   
rgoyal
post Dec 2 2004, 05:55 PM
Post#1



Posts: 4
Joined: 10-June 02



Hey guys
oes anybody know anything about the following error:
Run-time error '3044'
F:\........\TrainingData.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
To me it should be connecting to .mdw file not .mdb.
Go to the top of the page
 
JayNoelOlimpo
post Dec 2 2004, 11:53 PM
Post#2


UtterAccess VIP
Posts: 7,990
Joined: 5-October 03
From: Philippines


mdw file Workgroup File ...
oes F:\.....\TrainingData.mdb exists or connected ...
It is not customary to link tables via mapped drive user UNC instead(best approved) ...
Go to the top of the page
 
rgoyal
post Dec 3 2004, 01:04 PM
Post#3



Posts: 4
Joined: 10-June 02



is there a way to change the path to the .mdb file
Thanks in advance
Go to the top of the page
 
JayNoelOlimpo
post Dec 4 2004, 03:12 AM
Post#4


UtterAccess VIP
Posts: 7,990
Joined: 5-October 03
From: Philippines


Yes there is a way to change the path of the link mdb ....
If fIsFileDIR("\\ServerName\SharedFolder\BE.mdb") = 0 then
docmd.TransferDatabase acLink ... '*** link to local mdb
else
docmd.TransferDatabase acLink ... '*** link to server
endif
Function fIsFileDIR(stPath As String, _
Optional lngType As Long) _
As Integer
On Error Resume Next
fIsFileDIR = Len(Dir(stPath, lngType)) > 0
End Function
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    28th May 2015 - 10:59 AM