ADODB Connection String
I am trying to build an ADODB Connection, and I have a few questions about the connection string.
1. Since I am developing this in Access 2000, and the code is in the Access 2000 project I am working on, why do I have to provide a hardcoded path to my database in the connection string?
2. If I really to have to hardcode the database path, is there a way to make Access get the path? I am developing on a different machine that it will be running on and I would hate to have to hardcode the path. Even if I did, there is no way to ensure that my customer won't reorganize her directories, and break it. There has to be a better way.
Thanks for your insight,