I'm honored that the Great Shawn is taking time for a humble junior member like me ;->
I'll describe the case as clear as I can.

The database is an Access97 database, there is one table named 'APP' with the following
record specifications

AppName Text 50 (unique)
LastUse Date/Time
Commandline Text 255
LocalSize Number Long Integer
Snapname Text 50
VINVersion Number Long Integer

What i'd like to do is:

Read a record by unique identifier (Appname), examine the variable 'Commandline' and
'Snapname' for a substring, change it, and write it back to the table.

The variable looks like '\\SERVERNR01\Application$' and I would like to change
the servername.

There are no SQL statements defined in the database.

The catch is, (aha, there's always a catch ;-) the workstations (all NT4.0) don't have
Access97 installed, but I don't know if this is important.

I hope I'm being clear enough for you. I'm anxiously waiting to see your magic.

Greetings,

Rogier de Jong
Roger the Young (roughly translated)