Solved

when upgrading from -97mdb to 2000mdb

Posted on 2001-07-18
7
172 Views
Last Modified: 2012-06-27
Hi !

I tried to upgrade a MDB from a 97 vesjon to a
2000 versjon, by converting it from the tools
in access 2000, but when I try to execute the asp Page
I get this error !!

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x70c Thread 0x748 DBC 0xf3be004 Jet'.

....and since the asp worked fine before, then I wonder
 if what to do !!!
0
Comment
Question by:MRSONNY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 8

Expert Comment

by:Dave_Greene
ID: 6295970
Try Rebuilding your DSN
0
 
LVL 33

Expert Comment

by:hongjun
ID: 6296531
1. Try rebuilding your DSN.
2. Try opening your that converted access file using Access 2000 and see if there is a prompt prompting you to convert database or open database. If there is, then your conversion is successful and correct.

hongjun
0
 
LVL 33

Accepted Solution

by:
hongjun earned 10 total points
ID: 6296535
My second point is incorrect. Read below instead.

2. Try opening your that converted access file using Access 2000 and see if there is a prompt prompting
you to convert database or open database. If there is, then your conversion is UNSUCCESSFUL.

hongjun
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:Ktoshni
ID: 6298582
Why not try using a DNSless connection like this

Set DBCon = Server.CreateObject("ADODB.Connection")
  With DBcon
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .open server.mappath("db.mdb")
  end with

This works fine for me
0
 

Expert Comment

by:davemaxwell
ID: 6298762
The MDAC may also need to be updated on the server, but the problem is probably with the connection string.  Make sure you are using the JET connection for Access 2000.
0
 

Author Comment

by:MRSONNY
ID: 6299881
... OK,

Here's the code where my error is showing !!


<%
if Request.Form("email") <> "" then
          email = Request.Form("email")
     If Valider(email) Then
          set conn = Server.CreateObject("ADODB.Connection")
          conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb"), adLockOptimistic

          If Request.Form("RADIO") = "false" Then
          conn.Execute("DELETE * FROM maillingliste WHERE email='" & email & "'")
          V_Status     = "E-mail adressen er n? slettet fra databasen"
          else
          on Error Resume Next
          conn.Execute("insert into maillingliste (email) values ('" & email & "')")
          On Error GoTo 0
          V_Status     = "E-mail adressen er n? registrert i databasen"
          end if
          conn.Close
          set conn = nothing
     end if
end if
%>
0
 

Author Comment

by:MRSONNY
ID: 6383681
PING 255.255.255.255 :-)
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to show result of a NULL value at random? 33 59
Index on a Table 6 31
Multiflying 2 Input Text On a Table 7 32
Syntax for query to update table 2 41
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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