How to open a file in memory

[test]

the access file, such as mdb or mde, have been load into memory.
how to open the file in memory by ADO.

 

[Larry Linson]

the access file, such as mdb or mde, have been load into memory.
how to open the file in memory by ADO.

I specifically do not understand what you mean by "file, such as mdb or
mde,have been load into memory". I do not know of any database state/status
that would fit that description.

ADO makes possible "disconnected recordsets"... that is, create a recordset
from a table or query, "disconnect" it from the underlying table/query, work
on it, then "reconnect" to "batch" update. I'd suggest Googling in
appropriate newsgroups on the combination of "ADO" and "disconnected
recordset".

Larry Linson
Microsoft Access MVP