Thanks. THe article ref'd didn't really get into the use of Stream except for the usual getting data into and out of a BLOB. But you're saying ADO will copy...

paste the following two functions into a module, then in the Immediate window enter "? AttachDSNLessTable()" and press Enter. It may run for a while so be patient.

Function AttachDSNLessTable(stLocalTableName As...

Actually Newbie's ref to MS pointed to some code that could be used to convert a DSN based Linked Table to a DSN-less Linked Table. I copied the code to...

Perfect! Thanks!

Back to the specification of Shared Connections. Here's my Module:

           1   Attribute VB_Name = "Module1"

           2   Option Compare Database

           3

          ...

Ummm... OK, any thoughts on how to do that in Access VBA?

Perfect! Thanks!

How unique is the Enttime field? If it is a true datetime (down to ms) then they should be unique in which case you could use that as your primary...

Is this in code or is it a data-bound form? If it's in code (either module or code behind controls) try opening the form in design mode, go to the...

... Unless you have no suitable field or fields for a primary key. In that case you will have to re-establish the local table (if you haven't deleted it yet...

Did you upsize the Access DB to SQL? Does the table you're updating have a Primary Key? If not then the upsizing wizard will make it read-only...

That did the trick. I knew there was something missing...

Now I have a problem with Access complaining that there are concurrent updates to one of the tables, and I'm the...

Is it safe to assume each user can have multiple roles, hence the UsersRoles table? If not then your table structure is too complex. If each user only has one...

Depending on the size of the tables and/or the number of rows being updated you might get better performance with Table Variables (Declare Tablea TABLE (idkey int, fname varchar(100)...)). Select...

Do you store content other than WAV files in this field? If not, isn't the field NULL if there's no WAV file? If so then

Select * from tablename where...