Dear Justin:

1.

There are no "local tables" with an ADP.

You can get the same effect by using the Computer Network Name as part of a
key in a table on the server.  This is an exact equivalent.  A table like
this is said to be "partitioned" among the computers accessing it.  You need
only filter by the Computer Network Name (I choose that because it is
unique) to see only those rows pertaining to each computer.

Even better is to add another key column to identify the "instance" of the
application running.  If a user opens two copies of the Access front end and
both use a local MDB table, they would confilct.  Keying the rows by this
key ensures they are partitioned on this basis also.  If you have an MDB
that doesn't preclude multiple instances, you could really get caught by
this!

For an "instance key" I save the hWnd of the initial form.  This could be a
login form or the main "switchboard" or menu of the application.  Don't
close this form, just make it Visible = False when you don't want to see it.
That way, it is guaranteed that this hWnd cannot be duplicated.  It
therefore becomes an "identity" for each instance of the application.  Save
it in a global variable for further use.

2.

A common term for this is "import."  It sounds like you want to append rows
from a text file into a table.

So, a user will navigate to a folder somewhere and see a set of file names.
He will select one or more.  Sounds like a multi-select list box.

Is it possible that the user will navigate to another folder and pick some
more files?  Or are all the desired files in just one folder?

If they're all in one folder, you wouldn't need to save them in a table.
You could just iterate through the selections in the multi-select list box.
But putting them into a table sounds like a very good general solution.

Is there an easier way?  You didn't tell that much about the way you're
doing it now.  That makes it difficult to say whether there's an easier way.
Just working off a multi-select check box would be pretty easy if the folder
doesn't change.

Tom Ellison