Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I update an access database from a macro:
sub AccessArtikkel
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\program\Strekkode\Data\OprBok.mdb;Persist Security Info=true" Set Conn = CreateObject("ADODB.Connection") Conn.Open ConnectionString
It workes well on my workstation, but The OleBD drivers are not installed on the terminal servers and the macro fails.
1. Is it possible to ODBC driveres as an alternative? (driverers are installed)
2. what is the minimum required installation if OleDB should be used?
Regards
Einar
Einar,
I'm assuming that your terminal server in this case is also your QVS.
Regards,
Einar,
I'm assuming that your terminal server in this case is also your QVS.
Regards,
Thanks a lot. This was an exellent answer to my question
Einar