Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running Access Queries with ASP
Sorry, I meant to say i got the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Thanks if you can help me!- bitseek
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
-
Running Access Queries with ASP
This is the ASP version that works: <% Dim Conn, RS Set Conn = Server.CreateObject("ADODB.Connection") conn.open "pp2" Dim strSQL strSQL = "DELETE * FROM Invoices;" Set RS = Conn.Execute(strSQL) strSQL = "INSERT INTO Invoices SELECT [XLink].* " strSQL =...- bitseek
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Running Access Queries with ASP
Can I trigger an Access Query with ASP? Instead of writing out the query in ASP, could asp run a query which is in Access already? Could someone help with some code showing how... Any help will be much appreciated... Thanks- bitseek
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
