Dear reader,
By using the CompactDatabase command I discovered the following unpleasant
situation:
DBEngin.CompactDatabase "DB_a", "DB_b"
The above sentence works perfect, but if I will use the command with
variables from a table it fails, for instance:
DBEnging.ComandDatabase Rst1!DB_old , Rst1!DB_new
The same negative result is by using this commend with string variables as:
Dim DB_a as String
Dim DB_b as String
Dim Rst1 as DAO.Recordset
Set Rst1 = db.OpenRecordset("Tbl_Databases")
DB_a = Rst1!DB_old (fieldname from the table)
DB_b = Rst1!DB_new
DBEnging.ComandDatabase DB_a , DB_b
This instruction set is also not working.
Tanks for any help to solve this situation
Kind regards,
Simon van Beek