<bl*****@gmail.com> wrote
HELP!
What I've got going here is:
a)Access database (mdb)
b)VBScript from ArcGIS (modelbuilder) that
processes said Access database to custom
Personal GeoDatabase (PGD)
I want that Access should be able to run the
VBScript internally, and I've added the code
into a module. Am I taking the wrong path?
Am I skipping a step? How do I make it work?
First, I want to make it clear that I am not familiar with the software
product, ArcGIS, which you mention, so some of my questions will deal with
what kind of code you have.
As Ross-for-Boss said, "The devil's in the details." And, you didn't provide
much detail. You also did not explain what the code is supposed to do, why
you want or need to execute it from inside Access, nor where that code would
normally be run.
If you are accurate in describing what you have, "vbscript" (usually all in
lowercase) is a scripting language not processed by Access, which uses
Visual Basic for Applications (VBA), a similar but not identical language.
We talk about Declarations, Functions, and Sub Procedures in VBA, but we
don't call pieces of code "VB Scripts".
You can't just "add code to a module" and expect it to run. You have to
determine the conditions under which you want it to run, and make provision
to run it... if you were not aware of that fact, then I wonder if you might
not want to learn something more about VBA code in Access, and whether that
is what you have, or if you do, indeed, have vbscript code (to use that with
Access, you'll have to set a reference to the Scripting Host library and
call that to execute it.
I don't use vbscript with Access because many system administrators very
thoroughly disable and protect against vbscript or javascript being run on
their systems, as a security measure. Many other Access developers also do
not use it, either, so if that is what you have, you may or may not find
help here.
Larry Linson
Microsoft Access MVP