Click here to Skip to main content
12,510,403 members (49,857 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# C#4.0
hi,

i am Srinivas,

in my Windows-Forms Application i am using MS-Access database, here i want to connect database which is located in another system shared folder.

The following is the connection string:


string strconn = "Provider=MS Remote; Remote Server=192.168.200.168; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:/LAN_Testing_Windows/LAN_Test.mdb;";

the above code is works perfectly, i am able to connect to the database with above connection string, but when i perform any operation like Insert, update, delete etc. it returns an error

Error is :

Business Object Cannot be Created.

Please help me.

Thanks
D. Srinivasa Rao,
Posted 20-Nov-12 0:18am
Updated 20-Nov-12 0:30am
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Chances are you don't have permissions for the file / folder that you are connecting to. Check on the machine the shares them, to ensure that you have write permission.

BTW: You do realize that using Access files directly in multiuser is a process full of pain? Unless you are the only user updating this database I would strongly suggest you attach it to an SQL server instance instead...
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160929.1 | Last Updated 20 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100