Yes, I am using a Windows 2000 Access database. I don't want to pay for a whole new package just to be able to continue developing.
Cheers -
george
User Profile
Collapse
-
I went to http://www.microsoft.com/downloads/e...&stype=s_basic but the only link that included Jet was for XP. I tried installing it but it would not allow it on my Windows 7 platform.
Cheers -
georgeLeave a comment:
-
Thanks for the response. I installed it but without any change.
Here is the code I have put together:
...Code:<% Option Explicit Dim Driver, fso Dim objCommand Driver = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\Inetpub\wwwroot\database\OMHT.mdb;" ' Local Set objCommand = Server.CreateObject("ADODB.Command") objCommand.ActiveConnection = Driver %> <!DOCTYPELeave a comment:
-
Provider cannot be found. It may not be properly installed.
I got a new Windows 7 box and am having troubles getting ASP to connect to the database. I have read about this error and it sounds like I need to download and install something but just do not understand what or where. My code is simple:
<% Option Explicit %>
<%
Dim Driver, fso
Driver = "PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA SOURCE=c:\Inetp ub\wwwroot\data base\OMHT.mdb;" ' Local
Set... -
IsNull is the key I was missing. Thank you very much for the comments.
Cheers -
georgeLeave a comment:
-
"Except" in Select Statement
I need to select cells from one table that do not appear in a second table. I know that this can be done in some flavors of SQL by using Except:
Select Unit_PK From Table1
Except
Select Unit_PK From Table2
This would give me the Unit_PK cells in Table1 that do not exist in Table2.
Microsoft Access apparently does not allow Except or Minus in the SQL statement, so I am wondering if this is...
No activity results to display
Show More
Leave a comment: