VB can open the Access database that has spaces in the name..... at least in 2000. I am pretty sure it works that way with 97 as well..... The trick is to use brackets around the name of the table....ie;
Dim oCn As New ADODB.Connection
Dim oRs As ADODB.Recordset
oCn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDir\MyMdb.mdb;Persist Security Info=False"
Set oRs = New ADODB.Recordset
oRs.Open "Select * From [Ver 2 Jobs]", oCn
