Am I on the right track with taking data from one db and putting it into another
- From: "Dave" <davekstl@xxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 08:32:30 -0500
Here is my synatx with the error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINNT\system32\NTS.mdb'.
/FPSite/service/LMS/NTS/TestUPload.asp, line 18
<%
set ConnStr1 = Server.CreateObject("ADODB.Connection")
RelativePath = "../fpdb/NTS.mdb"
AbsolutePath = Server.Mappath(RelativePath)
ConnStr1.Provider = "Microsoft.Jet.OLEDB.4.0"
connStr1.Open = "Data Source="&AbsolutePath&""
set rs = Server.CreateObject("ADODB.Recordset")
RelativePath = "../fpdb/LMS.mdb"
AbsolutePath = Server.Mappath(RelativePath)
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&AbsolutePath&""
mysql = "SELECT * INTO TBackup IN 'NTS.mdb' FROM ResultsCrit" ---- Line
18
rs.open mysql, ConnStr
%>
.
- Prev by Date: RE: Query that doesn't show all records from multiple tables/queri
- Next by Date: Re: can the new record icon be changed from the asterisk to something else?
- Previous by thread: Filtering basic database
- Next by thread: Update Query for invoice/purchase order
- Index(es):
Relevant Pages
|
Loading
