Thanks,
    Justin

as far as I know you have to open Access. A form or module
linked to by the autoexec module can open your form or
module and then create the links.
Best is using  the Docmd.TransferDatabase
Command.
Its syntax is:
DoCmd.TransferDatabase [Transfertype], Databaseformat,
DataBaseName[, Objekttype], Name in Source Database, Name
in destination database[, structureOnly][, password]

E.g.:
DoCmd.TransferDatabase acImport, "Microsoft
ACCESS", "c:\me.mdb", acTable, "Table1", "NewTab"

imports the Table "Table1" from "c:\me.mdb" into the
table "NewTab" in your database.

Hope that helps,

Christoph

  set db = dbengine.workspaces(0).opendatabase(strDataBaseFileName)
  set rs = db.openrecordset( _
    "select * from mytable where myrecord=2;", _
    dbopensnapshot, dbforwardonly)
  debug.print "Gotcha: "; rs!mysurprisingfield

  rs.close
  db.close

Or
  select * from mytable
  into myothertable in "c:\myotherdatabase.mdb"
  where myrecordid = 2;

etc. etc. etc...

Does that help?

Tim F

why did you choose this line:
  set db = dbengine.workspaces(0).opendatabase(strDataBaseFileName)

over

set db = currentdb()

thanks
JamesSF

If he needed to manipulate the current db, then that would work fine.

If he needed to open with different username, password etc. then he'd have
to create a new workspace as well.

Diff'rnt strokes for diff'rnt needs... or sumthing!

Tim F