Link to home
Start Free TrialLog in
Avatar of felicia
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
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

App.path returns the path the application is started from. However, you may enter for the shortcut (windows explorer/shortcut properties/shortcut tab) the "start in" properties which may do want you want.
This may not be the solution as you can be limited for some other functionality
ASKER CERTIFIED SOLUTION
Avatar of AshokKumar
AshokKumar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wsh2
wsh2

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.