Is this possible

[Daniel]

We have a MS Access Db that is on certain pc's within our locations..

so that comes out to be around 40+ databases.. ( old software )

each of those pc's dont have MS Access loaded on them( this is a good
thing ) the software uses it..

For any new stores we open we have to go into the database to hardcode the
location number, once that is in place, then the rest of the configuration
is handled by the software.

Is there any way to create a page or some sort of script to run locally on
the machine that merely updates 1 field in the table without needing access?

Currently if there are any issues that require us to replace this database
we have to pull the databse back to our pc over the network which can take a
little over an hour.. make the change and push it back over..

So just wondering, without opening up IIS on the machine locally, can a page
be created to update that field like any other form?

Or can someone point me to the right place to ask/....

 

[Ken Foskey]

For any new stores we open we have to go into the database to hardcode
the location number, once that is in place, then the rest of the
configuration is handled by the software.

Part of your installation procedure can run a program that connects to a
web interface that gets the store ID and then it sends back the store
number. This would then handle reinstalls as well.

Is there any way to create a page or some sort of script to run locally
on the machine that merely updates 1 field in the table without needing
access?

Same concept as above, problem is how many tables and how much work do
you want to do.

Currently if there are any issues that require us to replace this
database we have to pull the databse back to our pc over the network
which can take a little over an hour.. make the change and push it back
over..

Look up rsync to transfer data compressed and encrypted between
machines. Might help you a lot.

So just wondering, without opening up IIS on the machine locally, can a
page be created to update that field like any other form?

Yep... how much time do you want to invest. remote desktop might be an
easier solution with something that will access most data easily.
Install access, then remove it. Wonder how long it would take?

 

[Daniel]

well the thing is that we arent planning on touching existing locations..

this would be part of our new store installation..

dont want to spend to much time, just a simple program to update a field in
the DB that can be done locally on that machine by our IT dept.

Nothing fancy..

Just connect to MDB, prompt for 2 digit store number, click OK and updates
the field..

 

[Pavel Minaev]

We have a MS Access Db that is on certain pc's within our locations..

so that comes out to be around 40+ databases.. ( old software )

each of those pc's dont have MS Access loaded on them( this is a good
thing ) the software uses it..

For any new stores we open we have to go into the database to hardcode the
location number, once that is in place, then the rest of the configuration
is handled by the software.

Is there any way to create a page or some sort of script to run locally on
the machine that merely updates 1 field in the table without needing access?

Yes. All you need to read/write data in tables inside an .mdb file are
Microsoft Jet components, which are installed as part of MDAC 2.6
(http://www.microsoft.com/downloads/details.aspx?familyid=6A7D785F-
C2E0-471D-A33B-82AD1D514737&displaylang=en). Once those are installed,
you can access .mdb files from Windows Scripting Host scripts via ADO
API, using either VBScript or JScript as a language. The script can
use InputBox function to request user to enter the ID.