Open a recordset from vba

I have opened a connetion to a databse in the shared folder but I can't be able to open a recordset of a table of this connection it says that there is a syntax failure can anyone please help me in opening a recordset of an ADODB connection.

my connection is the following please help me.
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\D-server\Persönlicher Ordner\CABANNA_be.mdb" & ";"
cnn.Open , "Admin", ""

MsgBox "cnn state: " & GetState(cnn.State)

' Open User table
Set rst = New ADODB.Recordset
strSQLUser = "User"
rst.Open strSQLUser, cnn, adOpenKeyset, adLockOptimistic, adCmdTable


This is showing a message that the connection state is opend but it can'T be able to open the record set what should Ihave to do.

Thanks a lot in advance.
have fun.
Kiran.

try

strSQLUser = "[User]"

now my reocrd set is opening but can you please give me an example to how can I INSERT a record selected from my remote database and into Local databse.

I found how to update an existing record but not how to insert a new record which is selected from remote databse and insert into the local databse.

I feel lucky if I can get this answer.
Thanks in advance.

For starters,

http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthaddnew.asp

search the forum for a sample DB called

VBAUnbound.zip

It is a sample DB using DAO and ADO recordsets

S-