Change database location

Hi

in VB6, i try

VB Code:

for each table in crRep.tables
   table.location = DATABASE_PATH
next

but the location isn't changed, actually it contains the table name :S

What can i do to change the database location then?