I want to copy tables from current database like test1.mbd to another database like test.mbd in same directory. Can anyone help me how destination database point to my current database path? If i write the filename like test.mdb then by default it is taken....C:/my document/test.mdb as path. But i want it to be like CurrentDbPath/test.mdb. I can't give the fixed path as my database is used at multiple computers.


Thanks in advance...
Kamal