Editing an Access table from VBscript?

I'm looking for a way to read from and write to a table within an MS-Access
database.
I'll explain why I need this.
In my company, I want to keep a logfile of the computers that have logged
into the network. If the computername is not in a list, I want the user to
enter some information on a popup screen, about the location of the computer
(room-number).
Once the computername is in the list, the script should continue without the
user noticing. It should then only write the current date and time.

Would this be possible with Vbscript?

Wouter.

joker
Wed Sep 08 12:22:54 CDT 2004

It is possible.

I strongly recommend using ADO for the database connection though since
it is faster then ODBC aka DSN.

Wouter wrote:

> I'm looking for a way to read from and write to a table within an MS-Access
> database.
> I'll explain why I need this.
> In my company, I want to keep a logfile of the computers that have logged
> into the network. If the computername is not in a list, I want the user to
> enter some information on a popup screen, about the location of the computer
> (room-number).
> Once the computername is in the list, the script should continue without the
> user noticing. It should then only write the current date and time.
>
> Would this be possible with Vbscript?
>
> Wouter.
>
>

joker
Wed Sep 08 13:03:13 CDT 2004

I wasn't able to be any more specific because I only use vbscript for my
ASP pages. I haven't written any .vbs files ever.

joker wrote:

> It is possible.
>
> I strongly recommend using ADO for the database connection though since
> it is faster then ODBC aka DSN.
>
> Wouter wrote:
>
>> I'm looking for a way to read from and write to a table within an
>> MS-Access
>> database.
>> I'll explain why I need this.
>> In my company, I want to keep a logfile of the computers that have logged
>> into the network. If the computername is not in a list, I want the
>> user to
>> enter some information on a popup screen, about the location of the
>> computer
>> (room-number).
>> Once the computername is in the list, the script should continue
>> without the
>> user noticing. It should then only write the current date and time.
>>
>> Would this be possible with Vbscript?
>>
>> Wouter.
>>
>>
>