How do I call a function from one access DB to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two Access databases. One with local data and the other with shared
data. I want to be able to call a public function from the local database to
update records in the shared database.

I am not moving data between the two, at least not in this instance. I want
to update a time stamp. When the user of the local DB completes a task, I
want to update a field in the shared database with a flag noting completion.

Thanks in advance.
 
Why wont you create a link to the table in the Shared DB to the Local DB, and
just run an update query on the link table?
 
You'll want to investiate the concept of creating a DB as a library
database. I've only used it once (and then only during Clinton's 1st
term) so I myself would have to look the concept up in help or on the
web. (Which answers the question in the SUBJECT line.)

As to the apparent question in the BODY, if you link the local database
with the shared. The local can update the tables in the shared.
 
Back
Top