.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

how can i connect to Access DB in another PC in network

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :.NET Framework
Hello all ,  i want to make 2 separated programs that share database in network the Access DB is on PC and the program is on another one how can i make the connection between them ?Kareem Naguib

View Complete Post

More Related Resource Links

Connect to MS Access via OLEDB provider


I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)

Here is the connection info in my Application Definition XML:

    <LobSystemInstance Name="LessonsLearnedDevOLEDB_Instance">
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
        <Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
        <Property Name="rdbconnectionProvider" Type="System.String&qu

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied error for a sched

Hi Guys, The subject of this question is the error which I am receiving when running a scheduled job also this is an error which we get at a random intervals and the frequency would be once or twice in a month. I have been through several posts and didn't concluded anything out of it. At the time when we receive this error the memory usage of the database was normal with free resources available and also the network was stable without issues. Our Sql database is in cluster mode with named instance. Can anyone share some information on this, I know this is not the right forum with the error message I have posted but am sure some one might have face the same problem when running some ETL jobs. Source and target both are sql server and the error message is generated in the validation phase of the connection manager connecting to target database. SSIS 2005 SP2 64 bit environmentRaju

Outlook Unable to connect to MySite's "Social Network"

Running into a really odd issue. I have to farms configred pretty much identically, a production farm and a dev farm. For some reason I'm able to set up a social network connection from outlook to my dev farm without any problems but I get "invalid user name or password" when I try and connect tot he production farm. There's no errors showing in the SPLogs or the event viewer. I've checked everything I can think of but knowing me I'm missing something really small.

Connect SQL Server 2005 to Ms Access on another computer

I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

local pipes vs. network pipes (to connect to SQL Server)

Choosing a Network Protocol (SQL Server 2008 R2) tells: "It is also important to clarify if you are talking about local pipes or network pipes. If the server application is running locally on the computer that is running an instance of SQL Server, the local Named Pipes protocol is an option. Local named pipes runs in kernel mode and is very fast" Well, it is not me who is talking in cited article, I believe so. Should it be understood that "If the server application is running locally on the computer that is running an instance of SQL Server" and configuring/choosing Named Pipes mean running "local Named Pipes"?

Unable to access VM network drive in SQL during backup generated by stored procedure

I get the following error in a log file created in the osql command: Msg 3201, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150Cannot open backup device 'x:\Servername_master_sqlbu_200703101930.bkf'.Device error or device off-line. See the SQL Server error log for moredetails.Msg 3013, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150BACKUP DATABASE is terminating abnormally. The device is established in a CMD file right before the osql command is started that starts my stored procedure.  The CMD in this file is: for /f "tokens=15 delims=." %%i in ('ipconfig^|find "IP Address"^|find "192.168"') do set SUBNET=%%i :loopif exist x:\ net use x: /delnet use x: \\192.168.%SUBNET%.1\backup if not ERRORLEVEL 1 ( goto continue) else ( echo FAILED TO CONNECT TO BACKUP SERVER >> "%SystemDrive%\LogFiles\%Computername%.log" sleep 60 goto loop) :continue echo IP ADDRESS OBTAINED Echo delete old log file if it exists if exist %3\%computername%_kaman_full_sqldb_backup_old.log del /Q %3\%computername%_kaman_full_sqldb_backup_old.log Echo Rename log file to old.log rename %3\%computername%_kaman_full_sqldb_backup.log %computername%_kaman_full_sqldb_backup_old.log echo backup SQL Databases on server will start now osql -E -n -d %1 -i %2\kaman_full_sqldb_backup.sql -h-1 -o %3\%Co

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

Connect MS Access to a SQL DB

Hello All,    I have an SQL DB that I commission someone to build for me. However that person is nowhere to be found. I was told that I would be able to use MS Access to connect to the DB and I would be able to see, Add, edit and run reports.  Can someone pls point me to the right direction. I can give you access to my SQL server if need be.  Thank You 

Cannot Access Reports from Computers Within Network




I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is

"The permissions granted to user 'MyComputerName\Guest' are insufficient for performing this operation. (rsAccessDenied)"

Can someone please help?

I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?

Here are some details from my Report Services Configuration Manager

Service Account is set up to Use built-in account : Network Service

Current Report Server Database

SQL Server Name : MyComputerName\ServerName

Database Name : ReportServer$ServerName

Report Server Mode : Native

Current Report Server Database Credential

Credential : SQL Account

Login : sa

Password : **********



Access 2007 upsizing wizard can't connect to SQL Server 2005 Express


When trying to use the Access 2007 upsizing wizard to move a database to SQL Server 2005 Express, I get the following error message:

Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQ Server Driver][Share
Connection failed:
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server
does not exist or access denied.

I get the same message regardless of whether I configure SQL Server to run as a local system or service.

I am the only user on my Vista 32 PC and am therefore the administrator. As far as I can tell I have sufficient authority since I can start and stop SQL Server.

As a newbie to all this, I can't find any step by step instructions as to how a local copy of SQL Server should be configured to work with the upsizing wizard. In fact I can't even find any Access 2007 help walk-throughs on this upsizing wizard, let alone troubleshooting its error messages.

Any help would be appreciated, as well as links to step by step instructions (which I can't find in the MSDN Library materials).

PS Does MS understand how inadequate and inefficient its built-in documentation really is? Maybe that's what keeps MS Press in business!

Connect Analysis Server across network using ADOMD connection



I'm new to Analysis Server. How will i connect the Remote Analysis Server across Network using ADOMD Connection.


Please Help me!


Claims Based Authentication - Access Denied for NTLM - Network Related



We have setup a test SharePoint environment on a single box. If we create a new classic authentication web application using NTLM the site works fine, and recognizes AD users correctly. Users can then login successfully. If we create a new claims based authentication web application using NTLM all users receive an Access Denied error when trying to view the site. The application will recognize AD users when applying permissions in Central Admin's User Policy section, but none of those users are able to access the site.

If I turn on Fiddler Capture, the sites will work fine. Once I turn it off the sites no longer work and we are again presented with an Access Denied exception (or sometimes 403 Forbidden in Firefox and Chrome). I know that Fiddler create a local proxy so I'm curious what that proxy is doing that allows claims based to work correctly.

Has anyone seen this before? Does this sound Firewall/Antivirus related? Client or server?

Thank you,



Not able to Connect Access 2010 or Sharepoint Designer 2010 to the Local SP 2010 Development Environ


I was able to install and configure SP 2010 Foundation on a Windows 7 Home Premium Edition as a Development Environment.  But I am facing  following issues:

a)cannot export lists from Access DB (Reason not able to connect to the local site on my machine) 

b) for a list on SP site can't "Open with Access" - Access application is triggered, but the list doesn't show-up.

c) open a Page or List for edit with Sharepoint Designer ( SharePoint Designer application gets triggered  but it get message "Unable to open Web site, Possible Causes: ..."

d) Also "Open Site" for local site on my machine gives the same error as in point c) above. 

These 4  unsuccessful operations happen only for the local development site (created on my laptop), all the above operations are successful though when I do them on a web hosted SP 2010 site. I have given "Full Control" permission for my login on the Central Administration. So what is wrong with the local site which prevents SharePoint Designer and Access DB connectivity? 


Link/Connect SQL CE Table to Access MDB for VBA Code Processing

I'm hoping to connect an SQL CE file (main.dat) to an Access DB so I can run some vba code which:

1. Uses DAO to open a recordset (a table in the SQL CE DB)
2. Uses a field containing paths to mp3 files to extract the id3 tag data
3. Update an existing field from the same table/Same SQL CE DB

I've looked around and can't seem to find any ODBC driver(s) for SQL CE.  Got some info from Erik who suggested I post here.

Thanks in advance!

EDIT:  I just now was able to get Erik's code to work in Excel from my DB.  But I'm not sure how to send it back to the SQL CE DB from VBA... Is it possible?

allowing remote users access to a specific site but not to any other network servers



I've been checking previous postings.  We are opening up a sharepoint site for partner companies. Once they get to their site we don't want them on any other servers on the network. 

I followed the info in previous postings and created a group called Computer_Deny, created a user and added them to that group.  I created a GPO and linked it to the default domain with the user right deny access to this computer from the network enabled and the Computer_Deny group added.  Removed authenticated users from the filtering and added the Computer_Deny group.

did gpupdate /force

restarted an internal machine for testing.  Logged on as the user I created, the user can't get to any server except the domain controller.  What I'm not sure about....they need to authenticate with the DC, I believe, once they finish their HTTPS entry and then need to get to the sharepoint server.  If that is true, the authentication process has to happen on the DC.  I would think the authentication process is different that a user trying to access a computer from the network.  Am I correct?  Am I least moving in the right direction?

The user can still access the DC various ways i.e. run command, entire network but NOT via RDP since that right has not been granted.  Some further research indicates that if

File access across the network, credentials, logonuser, impersonation



I have an application that has both a server and client... the client can exist on any computer.

I have a need to allow a client to export a set of files.  The server process that will be exporting the job runs as the Local System account.

When I want to export resources to a remote UNC such as \\servername\share that I don't have permission on I would like to prompt my user for credentials.

How do I then use these new credentials to authenticate and then System.IO.File.Copy(src,dst)?

I've found several articles on impersonation and I can impersonate a local user, but not a remote user it seems... 

I'm programming in C#.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend