Solved

need help about winform App with MS access

Posted on 2006-07-03
9
240 Views
Last Modified: 2010-04-16
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.
0
Comment
Question by:k6t
9 Comments
 
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 17035175
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
 

Author Comment

by:k6t
ID: 17035213
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
 
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 17035379
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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 

Author Comment

by:k6t
ID: 17035641
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
 
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 17035772
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
 

Author Comment

by:k6t
ID: 17035820
i tried and no thing changed, error still raise : (
0
 
LVL 2

Expert Comment

by:shy_talk
ID: 17036219
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
 
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 17036296
Hi k6t,

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

regards

I
0
 
LVL 14

Accepted Solution

by:
jjardine earned 500 total points
ID: 17036661
.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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query Producing decimal places when it shouldn;t be 8 43
Device Location 4 29
Video Player 11 23
Jquery/JSON passing value from one function to another 12 36
In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question