felicia
asked on
App.path setting...
Can an visual basic expert give me a guide of to do a App.path setting...
Instead of having my Microsoft Access database sitting on my local C: drive, I would like to set it at my server to allow global usage...
Many thanks for the help !!!
Best Regards
Felicia
Instead of having my Microsoft Access database sitting on my local C: drive, I would like to set it at my server to allow global usage...
Many thanks for the help !!!
Best Regards
Felicia
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use UNC notation.. ie. \\computername\driveletter instead of x: as we normally do. If this is being run on a Win9x machine.. Network Neighborhood must be visible on the Desktop for this to work.
\\computername\driveletter \pathname\ mydatabase .mdb
The current MS way to go on this, is to setup a Data Environment (VB Menu.. Project.. Add Data Environment).. and then use ADO. Sure its a pain in the @$$, but why shouldn't you suffer too?.. LOL.
Good Luck.. <smile>.
B.
\\computername\driveletter
The current MS way to go on this, is to setup a Data Environment (VB Menu.. Project.. Add Data Environment).. and then use ADO. Sure its a pain in the @$$, but why shouldn't you suffer too?.. LOL.
Good Luck.. <smile>.
B.
This may not be the solution as you can be limited for some other functionality