Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Run time error 3086


Message #1 by paulhesse@h... on Fri, 26 Apr 2002 11:39:57
While trying to open an Access 2000 database I am getting a Run Time error 
3086. The debug program takes me to the following bit of code

Exit_Get_ODBC_Datasource:
    Exit Sub
Err_append_tabledef:
    dbs.Execute "Delete from RS_DataSources"
    GoTo Load_DataSources
End Sub

Any suggestions would be appreciated.

Thanks,

Paul.
Message #2 by "Phillip Johnson" <phillip.johnson@e...> on Fri, 26 Apr 2002 13:56:40
Try "Delete * from RS_DataSources"

Regards, Phillip

> While trying to open an Access 2000 database I am getting a Run Time 
error 
3> 086. The debug program takes me to the following bit of code

> Exit_Get_ODBC_Datasource:
 >    Exit Sub
E> rr_append_tabledef:
 >    dbs.Execute "Delete from RS_DataSources"
 >    GoTo Load_DataSources
E> nd Sub

> Any suggestions would be appreciated.

> Thanks,

> Paul.
Message #3 by "Phillip Johnson" <phillip.johnson@e...> on Fri, 26 Apr 2002 14:06:03
Forget the last message.

Check out the properties of the dbs object when it crashes.



> Try "Delete * from RS_DataSources"

> Regards, Phillip

> > While trying to open an Access 2000 database I am getting a Run Time 
e> rror 
3> > 086. The debug program takes me to the following bit of code

> > Exit_Get_ODBC_Datasource:
 > >    Exit Sub
E> > rr_append_tabledef:
 > >    dbs.Execute "Delete from RS_DataSources"
 > >    GoTo Load_DataSources
E> > nd Sub

> > Any suggestions would be appreciated.

> > Thanks,

> > Paul.

  Return to Index