473,320 Members | 1,766 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.

problems with connecting to Access dB

I seem to be having a lot of problems with running/developing web site on my
XP Professional OS.

I have a simple web site (using ASP/VB), which retrieves information from an
Access 2000 database. I have MS Access XP installed on my machine.

When I open the database in Access and try to open up a page, I get this
error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.

After this error, I have to restart my machine, and as long as I don't open
the database again (in Access) it works fine.

If I take the same web site on a NT machine, running IIS4, it works like a
charm, even if I open the database in Access.

I found these articles on support.Microsoft.com and tried to apply the
solution, mentioned in it; but, no success:
http://support.microsoft.com/default.aspx?kbid=315456
http://support.microsoft.com/default...b;en-us;295297

the second article talks about giving permissions to a user. I gave
permissions to IUSER_MACHINE, and no luck.

I am using a DSNless connection and the database is local to the machine

Here's what I sue in ASP to connect to the database

set conn = Server.CreateObject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
mapPath="DBQ=" & server.mappath (db_path+db_name)
dbconnstr="Driver={Microsoft Access Driver (*.mdb)};" & mapPath
conn.open dbconnstr

Please help, I have to deliver this site for a demo, by tomorrow, for a
client.

--
Asim Chowdhry
Recursive Consulting
http://www.e-recursive.com
Nov 12 '05 #1
0 1680

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

Similar topics

1
by: Brad Pears | last post by:
Our graphic designer is developing our new company website. We have switched providers and currently she is working on the new website which currently ressides on the new providers server as they...
0
by: maddunr | last post by:
Hi, I just installed PHP 4.3.9, MySQL 4.0.2 and PHPMyAdmin 2.6.0-pl3 on our intranet server (Win2k3 running IIS). I also have a similar setup on my local machine (http://localhost/phpmyadmin). ...
1
by: Adi Sapir | last post by:
Hi, We're currently planning to migrate from SQL Auth to Windows Auth. Personally, I do not have too much experience with Windows authentication but have heard that there are some problems when...
3
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the...
9
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to...
4
by: CodeImp | last post by:
A simple app I quickly wrote to try getting info from a database. Here is the first part of its code. The rest of the code is irellevant. using System; using System.Data; using...
13
by: Joner | last post by:
Hello, I'm having trouble with a little programme of mine where I connect to an access database. It seems to connect fine, and disconnect fine, but then after it won't reconnect, I get the error...
3
by: Mike | last post by:
I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm trying to get the Access database, or a new access...
5
by: bodhiSoma | last post by:
Hi all. Can't seem to get PHP to play nice with MySQL. First I logged into MySQL, created the db, switched to it and then granted (what I thought were) correct privileges: -------- ...
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
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.