Access Database Open - VBA

[jakobt]

The access database is not opened. How can I change this VBA code to open the access database.
The code doesnt crash so I think the access database is opened in memory!

Sub copydatabase()
Dim jobconn As ADODB.Connection
Set jobconn = New ADODB.Connection
jobconn.connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\user\Documents\job.accdb;Persist Security Info=False"
jobconn.Open

End Sub

 

[ranman256]

sometimes, Access leaves behind the lock file, .lccdb.
even tho nobody is in the db. If it is there, delete it.
if it wont delete,then someone is in it.