need help about winform App with MS access

i have a problem when working with MS access database file, i coding a application using MS access database, MS access file in application root directory, i run it in my local drive it working but when copy to network map drive it can't run, i think i it not found my MS access database, how can i resolve this problem (i copy my application directory to another machines, it working) please help me.
k6tAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ivo StoykovCommented:
Hello k6t,

what kind is your application - web based; sand alone?
does your application has permits to read/write to that mapped drive?
how do you try to connect to access on the mapped drive?

HTH

I
0
k6tAuthor Commented:
my application is stand alone windows base application, i run my application under window account that have read/write on that map drive,please help me? does we need some special steps to make it work with network drive?
0
Ivo StoykovCommented:
Hi k6t,

i'm guessing... but there are few things you've to check.
1. permissions
2. path
3. connection string

what error you've get?

regards

I
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

k6tAuthor Commented:
here what i did to try to resolve my problem :

- i copy my MS access database to map drive and edit connection string to absolute path like \\myserver\myappfolder\myaccessfile.mdb

- compile my program

- when i run on my localdrive it work perfect.

- remove ms access file on map drive and run again on my local drive, it raise error (because it not found ms access file on map drive)

- add ms access file to map drive

- run my app on local drive, it work again ( we can see that no problem when connect to ms access file on map drive)

- but when i copy the hole application that run perfect on local drive to map drive, it raise error

- it drive me crazy, why when we run on map drive it can't see ms access file? there are some special steps when we want run our application on network drive? thanks
0
Ivo StoykovCommented:
Hi k6t,

> \\myserver
try to map the drive to a letter using Windows Explorer Map Drive menu so as your address to be
Z:\myappfolder\myaccessfile.mdb instead of \\myserver\myappfolder\myaccessfile.mdb


regards

I
0
k6tAuthor Commented:
i tried and no thing changed, error still raise : (
0
shy_talkCommented:
It looks like the path to the access database is saved in your application as a literal, e.g. "C:\Documents and Settings\...\My Documents\MyDatabase.mdb. When the application starts up on the network, it

To allow the application to work anywhere, you need to allow the application to search its default folders (in this case its installation folder) for the database, . To do this, find any properties, connection strings and code in your  in your application that give a folder for to the database and remove the folder information, leaving just the name of the database, e.g. "MyDatabase.mdb". That way, the application will first look for MyDatabase.mdb in its installation folder and other default folders before reporting that it cannot be found.

Hope this helps.
0
Ivo StoykovCommented:
Hi k6t,

what is actually the error you've get? I do not see any message...

regards

I
0
jjardineCommented:
.Net has security issues running from a network share.   try reading this blog http://blogs.msdn.com/shawnfa/archive/2003/06/20/57023.aspx  that might help shed some light on this.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.