Kopier View fra en Access database til en anden.

Hi theiss

DAO you can see the SQL by usin a queryDef

im db As DAO.Database
Dim qdf As DAO.QueryDef


Set db = .....Open dB

Set qdf = db.QueryDefs("YourQuery")

debug.print qdf.SQL

and to create a query you use CreatQueryDef

Set qdf = db.CreateQueryDef("YourQuery")

qdf.SQL = "SELECT ......"
qdf.close

you will need a reference to DAO in your project

im = Dim

Tak for det.

selv tak, hope you could use the answer?

Ja, det virker!