LotusScript Open an MS Access database and replace a string in a table

HCL Domino Domino Forum
1

Hello

Does anbody know some code to get a handle of an access database, select a table in the DB , get a column and replace every value in the column it finds.

So far i have this code ( which has been developed by a third party ) . I was under the impression you can run a query on an access table at any time, but as this is the first time i have done this, i am having trouble. I already have access to the access DB, and here is the rest of the code…

'Open Access file

Set oAccess = CreateObject(“Access.Application”)

oAccess.OpenCurrentDatabase ddDoc.NotesDirectory(0) & ddDoc.NotesFilename(0)



On Error Goto ErrorHandler



'Run query to replace = with - " PROD is the table column name

STR1 = "Replace(PROD, “=”,”-“)"

    oAccess.DoCmd.RunSQL(STR1)

Cleanup:

On Error Resume Next

Set dbs = Nothing	

oAccess.CloseCurrentDatabase
2

Subject: LotusScript Open an MS Access database and replace a string in a table

Any body have any clue on this ? Thanks

3

Subject: RE: LotusScript Open an MS Access database and replace a string in a table

Might it be better to use ODBC and the Lotus ODBC classes?

4

Subject: RE: LotusScript Open an MS Access database and replace a string in a table

No, it has to be done this way… All i need to know is how to change some data in an access database in lotus script …