I already split a db into, obviously, a front and back-end. I was wondering if there is a way that I can drop the back-end on a network share drive but NOT have the user see a 'network drive' in "my computer". Like make the connection each time they access the db but make the connection invisible to the user?
If you link using a UNC path (\\ServerName\ShareName\FileName.mdb) the user won't see a network drive in My Computer. Further, if you hide that share when you create it (using $), they shouldn't be able to see it if they poke around through Network Places.
I'm saying that when you link the tables in the front end, use that path rather than a mapped drive. You would need no code or anything on the command line. You don't need to reconnect unless the back end moves.