I am attempting to access a database that is located in a shared server/ directory "K:\". Assuming I don't know where the database is located, how can I programatically tell vb to locate this database by searching all the network server directory?
My database name is called:
Currently I copied the database into my local drive
"C:\PTS.mdb" => for testing purposes.
This is how I'm accessing the database now:
Dbpath = "C:\" DbName = "PTS" Set Db = OpenDatabase(Dbpath & DbName)
Any input will be greatly appreciated.