Previous Thread

8/14/2006 8:07:01 AM    Having troubles with error 7866 .opencurrentdatabase
here is the code it opens dab and then give the error 7866 when opoencurrent 
 
dbContab.Close 
 
Set dbContab = OpenDatabase(dirbase & archbase, False, False, ";pwd=" & 
 
clavebd) 
 
On Error GoTo 0 
 
'error 7866 exclusive mode which is not true when opendatabase why 
 
Set appAccess = CreateObject("Access.Application") 
 
appAccess.OpenCurrentDatabase dirbase & archbase, , clavebd 
 
For Each tdf In dbContab.TableDefs 
 
If Not (tdf.Attributes And dbSystemObject) <> 0 Then 
 
If tdf.Name = "prefinancieros" Then 
 
On Error GoTo 0 
 
SqlVerSQL = dirbase & "logtrans." & archbase 
 
On Error Resume Next 
 
appAccess.DoCmd.TransferDatabase acExport, "Microsoft Access", SqlVerSQL, 
 
acTable, tdf.Name, tdf.Name, False   ' true solo definiciones" 
 
End If 
 
End If



8/14/2006 11:29:47 AM    Re: Having troubles with error 7866 .opencurrentdatabase
This probably isn't it, but just to cover the obvious possible problem, have 
 
you tried rebooting, just to be sure there isn't some hidden instance of 
 
Access that has your application open? 
 
Rob 
 
"ramon soler" <ramonsoler.com> wrote in message 
 
news:AD77390A-196F-41B6-8F49-8E123E92BDBB@microsoft.com...