Export a table from accde to accde file (1 Viewer)

[gblack]

Essentially I am trying to find a way that I can have users send me a table without them being able to fiddle with it. I figure an accde file would work for this endeavor.

What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.

Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.

I have digressed to a replication table that needs to be uploaded, once data is entered by the users...

Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.

So does anyone know of any way to create a new lock file from within the current Db?

Respectfully,
Gary

 

[JHB]

Try the below, (remember to change the path and table name to fit yours:

  Dim accessApp As Access.Application
  Set accessApp = New Access.Application
  accessApp.DBEngine.CreateDatabase "c:\tblImport.accde", DB_LANG_GENERAL
  DoCmd.CopyObject "c:\tblImport.accde", "ATable", acTable, "ATable"
  accessApp.Quit
  Set accessApp = Nothing