Back up the transaction log.

[Pablo]

Hello, there,
I used MS Access ADP to make a database "theDB" in the backend SQL
2000 server. I insert around 200000 records into the database. Then I
got an error message "The log file for database 'theDB' is full. Back
up the transaction log for the database to free up some log space".
Can you tell me how to back up the transactionlog from the adp front
end since I do not have enterprise tools in my workstation? Besides
that, I don't want this error message to show up again because almost
every month I will use 'INSERT tblName SELECT * anotherTable" to
insert around 1000000 records into the database. Again, I would like
to do all this in the adp front end.
Thanks a lot in advance.
Pablo