Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

when upgrading from -97mdb to 2000mdb

Posted on 2001-07-18
7
Medium Priority
?
176 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 40 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 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