Try these steps:
(Both uses ADO Connection)
- For Microsoft SQL Database
- With DB
- .ConnectionTimeout = 60
- .Open "Driver={SQL Server};Server=srv_za_database...
- End With
- For Microsoft Access Database
- Private DB as New Connection
- With DB
- .Provider="Microsoft.jet.oledb... (Access 2000)
- .ConnectionString = "c:\Test.mdb"
- .Open
- End with