Shape Command in Access

S

SangGyun Kim

I want to use "Shape Command" in Access

----------------------------------------------------------
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection

conn.Provider = "MSDataShape"

conn.Open "Data Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & CurrentProject.FullName & ";"

----------------------------------------------------------

but this code raise error!!
lock error because mdb file is already opened

how can I overcome this error?

thank you..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top