Thanks both for responding.
1) GetPath returns the path to the DB (here: E:\MyDir\MyDB.mdb)
2) I've got about 50 CD's , I want to copy tables from.
So easiest just to put in CD, run my program, then swap out CD.
MOST IMPORTANTLY, why is it failing?
I'm trying to get an Access Table stored in an Access Database on a CD Drive with
the intent of copying that Table to an Access Database on my Hard Drive.
I've tried both of the following, both Fail to return a dbName (error 3051)
'orig Set dbName =...