Variables in a query
gocush wrote:
Assuming the user has permission access to the db, do you also have
or can
you explain how to add/edit/delete records stored in Access via
Excel?
Do you mean via MS Query. It can be done but not via the GUI query
builder tools. You will have to type the appropriate SQL DML (INSERT
INTO/UPDATE/DELETE respectively) yourself. Note that if you do this you
will lose support for parameters because the query cannot be displayed
'graphically'.
Jamie.
--
|