A different way of launching an Access database

[dg043]

Does anybody know of a way to launch an Access database without having Access installed? Due to the licensing issues in my company, this would be useful to have as an alternative.

 

[kabnl]

I have had joy with loading information form Access tables, with out loading Access.... but I am having a heck of a time tring to load forms with out actually opening Access IF ANY ONE CAN HELP.........
Hopefully the following code will point you in the right direction .... GOOD LUCK

strConnString As String = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=FileRegistration.mdb;" & _
"DefaultDir=C:\blablabla\;" & _
"Uid=Admin; PWD=password;"
If boolRecordSetOpen = True Then
rs.Close
Else
Set conn = CreateObject("ADODB.Connection&quot
conn.Open strConnString
Set rs = CreateObject("ADODB.Recordset&quot
End If
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
If boolIncoming = True Then
rs.Open "select * from FileIn order by [File name];", conn, adOpenDynamic
Else
rs.Open "select * from FileOut order by [File name];", conn, adOpenDynamic
End If
boolRecordSetOpen = True

 

[nberryman]

Access run time comes with the Developer editions and can be installed onto any number of machines.

Check Microsoft.Com for details

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com