Data Collection E-mail Query

[Philip]

When I try to run data collection using a query, I receive a message
indicating that the query is Read Only and cannot be used.

I am running Access 2007 as a split database.

 

[Michel Walsh]

I am not familiar with 'data collection' in the context.

A query can be read only if it uses an aggregate (or GROUP, or Crosstab, or
DISTINCT), a join which is a non equi join, is an UNION query, uses a
sub-query not updateable itself, as well as and other cases too. If the
query is not updateable, you cannot delete neither modify existing data
through the query (but can by accessing the tables themselves). It may also
be that your database support is read only (DVD, file with the operating
system attribute of read only set, or you don't have necessary user access
to the 'file' supporting the data, or the table is a linked one, and does
not allow update). You may also ends up with a Access being open with a Read
Only access (because the same file is exclusively open by someone else, or
because you specifically asked to open it in Read Only mode).



Vanderghast, Access MVP

 

[Philip]

Thank you.
The Data Collection by E-mail is a new feature of Access 2007.

Since I am running a Split database, all tables are linked. I can, however,
update individual tables using the E-mail data collection.

I am trying to collect employee hours into a table that contains empid,
date, start-time, etc. However, in order to do this, I need to get the e-mail
address from the employee table.