but... given SQL
[vba]
cSQL = "SELECT * INTO [dbo].[Table] FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=" & cMDB & "')...[Table]"
oConn.Execute(cSQL,,adExecuteNoRecords)
[/vba]
when run from a remote machine to a box with an SQL Server gives the infamous "DataBase is used exclusively by another user"
but if excuted remotely with the mdb on the same box as SQL Server works fine. Lots of reports of this error with the standard blame the victim crap... but NO
1. the mdb is not in use by another
2. no phantom .ldb files present
3. UNC shares set properly
4. ADHOC queries enabled in SQL Server
..if it is a bug in Jet 4.0 maybe I haven't googled deep enough.