473,320 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access a 'remote' Access DB through ADO

CJM
I have an intranet-based app that links to an Access DB. It works fine on my
developement machine, but if I place the DB on a different server, I have
problems - the JET Engine (ADO) complains that the DB is "...already opened
exclusively by another user, or you need permission to view its data."

Connection Strings:
Application("Connection") = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\mydb.mdb"
Application("Connection") = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\dir\mydb.mdb"

The first works, the second doesn't.

I'm not entirely surprised at this, but I'm wondering if there are any
tweaks or workarounds?
I'm assuming it is a permissions issue, but how can I give my IUSR (local)
account access rights to a domain??

Any suggestions?

TIA

Chris
Jul 19 '05 #1
2 1780
http://www.aspfaq.com/2168

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"CJM" <cj*****@yahoo.co.uk> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...
I have an intranet-based app that links to an Access DB. It works fine on my developement machine, but if I place the DB on a different server, I have
problems - the JET Engine (ADO) complains that the DB is "...already opened exclusively by another user, or you need permission to view its data."

Connection Strings:
Application("Connection") = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\mydb.mdb"
Application("Connection") = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\dir\mydb.mdb"

The first works, the second doesn't.

I'm not entirely surprised at this, but I'm wondering if there are any
tweaks or workarounds?
I'm assuming it is a permissions issue, but how can I give my IUSR (local)
account access rights to a domain??

Any suggestions?

TIA

Chris

Jul 19 '05 #2
CJM
Thanks Aaron.

"Aaron Bertrand [MVP]" <aa***@TRASHaspfaq.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
http://www.aspfaq.com/2168

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Rene' Nielsen | last post by:
Context: Running Windows 2003 Server on an intranet. A web is configured with an anonymous access account that is a domain account that has been granted the desired access to a file on another...
5
by: kackson | last post by:
Hi. I would like to access my database outside of my company. I read many documents but they are all pertaining to accessing the database via ASP or some form of web application. Is there no...
4
by: Peter Larsson | last post by:
Hello everybody, I'm developing a system for a company that has production at two different locations. The production is stored in an Access database at each location, and I need to find a way...
14
by: jj | last post by:
Is it possible to call a remote php script from within Access? I'm thinking something like: DoCMD... http://www.domain.com/scripts/dataquery.php DoCmd.OpenQuery "update_data", acNormal, acEdit...
6
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
3
by: Lyle Fairfield | last post by:
In a recent thread there has been discussion about Data Access Pages. It has been suggested that they are not permitted on many or most secure sites. Perhaps, that it is so, although I know of no...
0
by: bettervssremoting | last post by:
To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool including SourceOffSite, SourceAnyWhere and VSS Remoting This article makes a detailed...
13
by: Bob Palank | last post by:
Remote server hosts a .mdb file but the client cannot access the DB through VB.Net Express 2005. My Assumptions: 1. One can use VB.Net Express 2005 to write a client resident application to...
7
by: =?Utf-8?B?a21jY29za2V5?= | last post by:
I'm trying to access an access database on the file server from a web server using asp.net and IIS 6.0. I can do it when I have anonymous access enabled in IIS 6.0 as in the public internet web...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.