How do I update an MSAccess table without opening MSAccess?

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

Guest

I need to occassionally update a record in a table but I don't want to open
MSAccess to do this. I want it to be automatic from a program execution.
 
Gimpie said:
I need to occassionally update a record in a table but I don't want to open
MSAccess to do this. I want it to be automatic from a program execution.
Click to expand...


I can not help you with any code that isn't VBA, but you can
probably use the DAO library to Execute an Update query that
uses an IN phrase in the FROM clause to specify the
path/file of the database.
 
Look up ODBC, ADO, DAO and Jet. You can connect to an
Access mdb table(s) using one (or more) of those methods.
It's a big subject though and also depends upon what
software you're calling from.

--
Nick Coe (UK)
Available - Will work for money :-)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Gimpie typed:
 
What are the circumstances that you are encountering where the record
needs to be updated and Access *isn't* already opened? Furthermore, what
do you mean by saying that you don't want to open Access? Do you mean
that you don't want the application window displayed? Do you mean that
you don't want to use Access at all to update the record? Basically,
you're going to use code from within VBA to instantiate an object that's
going to do the work. What you want to do (see the questions) will
determine how you do that - probably either using ADO (eek!) or Access
itself.
 
I keep the Version Number in a table on the DataMDB file at each site.
Whenever I update the ApplicationMDB, I create an install disk to upload the
new file to the Client's PC and clean up their folder at the same time. One
step I want to do is to 'update this version number' on their DataMDB file.
Would like to do it from the install disk (batch file executables) and not
open the DataMDB file. I guess it could be done with many programs, so I'll
just pick one and scope out the commands. Was looking for suggestions on
what would be cleanest and easy.
Thanks, Jim
 
I would put a table in the Front End that contains the value (or maybe a
snipit of code) that automatically updates the value the first time that
the FE is opened.
 
Back
Top