How to connect a mdb file in memory.

T

test

A mdb file have been load into memory, and get the first address.
How to open the database file with ADO?
thanks.
 
6

'69 Camaro

How to connect a mdb file in memory.
A mdb file have been load into memory, and get the first address.
Click to expand...

This makes no sense in the realm of databases. It makes some sense when
discussing operating systems, RAM, and CPU registers, but not databases.

The last time you posted this question
(http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&th=493677833bdb
b5e4&rnum=1), Larry Linson's guess that you would like to create a
disconnected recordset with ADO and his subsequent suggestion was probably
the best help you can receive if you are having trouble with Access Help on
ADO. If you can't find the information that you need by Googling the News
Group archives, then perhaps you could explain in more detail what it is you
are trying to do, so that someone here can be of more assistance.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
A

Arvin Meyer

You can do something like this (aircode)

Private Sub Form_Load()

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset

With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "C:\Database Path"
.Open
End With

With rs
.CursorLocation = adUseClient
.LockType = adLockBatchOptimistic
.Open "TableName", cn, adOpenForwardOnly
End With

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top