HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL Statement Expect

Mar 27, 2007

My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:

We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.

I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.

When I try to upload a file to the script I get this error:

Line: 42
Char: 7
Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'.
Code: 0
Url: (URL address blocked: See forum rules)

Here is the part of Connect.asp that errors:

Code:<script LANGUAGE="javascript"><!--var DSNString, TheDF, TheRS;//DSNString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C: hedata estdisbo.mdb;User Id=admin;Password=;";//DSNString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C: hedata estdisbo.mdb;Uid=Admin;Pw d=;"DSNString = "DSN=testweb; UID=; PWD=";function public_ConToDB(){ TheDF = DP.CreateObject("RDSServer.DataFactory",this.text1.value);DC.DataSpace=DP;DC.Server = this.text1.value;DC.Connect = DSNString;//DC.Connect="d: hedatadisboweb.udl";}function public_GetRS(SQLCommand){ TheRS = TheDF.Query(DSNString,SQLCommand);DC.SourceRecordset=TheRS;return (TheRS);}function public_GetDC(){ return (DC);}//--></script>

Its included in a file called FileRead.htm here is the part that refers to the error lines:
Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");

I set an alert after this line but it doesn't pop up.

ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.

Sincerly,
Joseph Russell

View Replies


ADVERTISEMENT

ODBC MS Access Driver Error - Urgent

Nov 7, 2005

Please help...

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xcac Thread 0xcc0 DBC 0x1090064 Jet'.

The code: example.asp
Code:<%fp_sQry="SELECT count(*) FROM TEVPDATA where ((datediff('d', '" & date() & "', DT3PROF1) between 0 and 30)) and (COL2 = 'PROF1/SLM')"fp_sDefault=""fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records returned.</td></tr>"fp_sDataConn="Fabos"fp_iMaxRecords=0fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Truefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_iDisplayCols=1fp_fCustomQuery=TrueBOTID=1fp_iRegion=BOTID%>

Global.asa:
Code:'--Project Data ConnectionApplication("Fabos_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=data/Fabos.mdb"FrontPage_UrlVars(4) = "Fabos_ConnectionString"Application("Fabos_ConnectionTimeout") = 15Application("Fabos_CommandTimeout") = 30Application("Fabos_CursorLocation") = 3Application("Fabos_RuntimeUserName") = ""Application("Fabos_RuntimePassword") = ""

View 1 Replies View Related

General :: Cannot Use ODBC To Import From / Export To / Or Link To External Microsoft Access

Mar 16, 2014

I am trying to create an ODBC link to a copy of the Northwind data base.I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them.

When I attempted initially to create a new system DSN ODBC connection it only allowed me to use SQL drivers. (No plurry good) So after some searching I found out that I could use a file in C:WindowsSysWOW64 called "odbcad32.exe" which has allowed me to view /use the total list of drivers to import data.So I can set up a DNS ODBC named Northwind1 and I can access the database without problems using Excel.However if I try to use the same ODBC link in Access to connect to Northwind1 I get the following error message:"You cannot use ODBC to import from export to, or link an external ?Microsoft Access or ISAM database table to your database".

View 2 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 1 Replies View Related

Converting From Microsoft Access 2.0 To Microsoft Access 2003

Jul 10, 2006

Hello everyone,

I would like to convert a database, which was made for me, in order to enable it to be used on my current system.

I get the error message below when trying to open the database in Microsoft Access 2003.

The database was made using Microsoft Access 2.0.

Will I need Microsoft Access 2.0 to update/delete the database all the time?

Or can I convert this to be used with Microsoft Access 2003?

I have tried opening the file exclusively and I get the same error.

I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.

http://images6.theimagehosting.com/error.6de.PNG

Thank you very much for your help and all responses are appreciated,
Sam

View 13 Replies View Related

Microsoft Access '97 Error Message

Jan 15, 2007

Does anyone have any suggestions on how to address the following error occurring on my Microsoft Access ’97 database?

Error message: “Out of Memory”

Any thoughts on why this error occurs or what can be done to prevent it.


Many thanks

View 4 Replies View Related

Microsoft Access Database Error Message

Nov 28, 2005

please help I am working with access database I have limited experience with access. I am unable to figure this particular problem. Microsoft access can't append all the records in the append Query microsoft access set 0 field to null set to convertion failure and didn't add 2 to records to the table due key violation 0 record due to key lock violation

View 4 Replies View Related

Microsoft Access Database Error Message

Nov 28, 2005

please help I am working with access database I have limited experience with access. I am unable to figure this particular problem. Microsoft access can't append all the records in the append Query microsoft access set 0 field to null set to convertion failure and didn't add 2 to records to the table due key violation 0 record due to key lock violation

View 1 Replies View Related

Microsoft Access 2003 Error 3197

May 10, 2007

I need help with Microsoft Access 2003. I am receiving messages when I am saving in windows or closing in windows. the message is, "Microsoft Jet data base engine stopped the process because you and another user are attempting to change the same data at the same time.

email at:

(E-Mail address blocked: See forum rules)

View 1 Replies View Related

Microsoft OLE DB Provider For ODBC Drivers (0x80004005)

Feb 24, 2004

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 0x818 Thread 0xa74 DBC 0x5f5c1024 Jet'.

I get the above error when I run my login form can anyone help? it points to the code below

<% Response.Buffer = true %>
<%
Session("DatabasePath") = "MoneygallGAA.mdb"
If Request.Form("btnLogin") = "Login" AND Request.Form("txtName") <> "" _
AND Request.Form("txtPassword") <> "" Then

'-- Declare your variables
Dim DataConnection, cmdDC, RecordSet
Dim RecordToEdit, Updated, strUserName, strPassword

strUserName = Request.Form("txtName")
strPassword = Request.Form("txtPassword")

'-- Create object and open database
Set DataConnection = Server.CreateObject("ADODB.Connection")
DataConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Session("DatabasePath") & ";"

Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = DataConnection

'-- default SQL
SQL = "SELECT * FROM Login"

If Request.Form("txtName") <> "" Then
SQL = "SELECT Login.* FROM Login " & _
"WHERE Login.userID='" & strUserName& _
"' AND Login.password ='" & strPassword & "'"
End If

cmdDC.CommandText = SQL
Set RecordSet = Server.CreateObject("ADODB.Recordset")

'-- Cursor Type, Lock Type
'-- ForwardOnly 0 - ReadOnly 1
'-- KeySet 1 - Pessimistic 2
'-- Dynamic 2 - Optimistic 3
'-- Static 3 - BatchOptimistic 4
RecordSet.Open cmdDC, , 0, 2

If Not RecordSet.EOF Then
Dim struserLevel
struserLevel = RecordSet.Fields("userLevel")
Session("userLevel") = struserLevel
Else
'The user was not validated...
'Take them to a page which tells them they were not validated...
Response.Redirect "default.htm"
End If
End If
%>

View 2 Replies View Related

Modules & VBA :: Error - Microsoft Access Was Unable To Create MDE Database

Sep 19, 2013

I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.

how to fix this problem in MsAccess 2003?

View 6 Replies View Related

Microsoft Access & Microsoft SQL.

Aug 7, 2006

Questions / Help :

What I would like to know about Microsoft SQL Server & Access 2003 :
I am a novice at creating my own database.
I would like to use Microsoft SQL Server & Access 2003 .
I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 .
Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003.
I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness.
If you intend to reply, please be very specific & in plain English.

Can someone help me ?


1Can Microsoft SQL Server 2000 work with Microsoft access 2003.
a.Is this do-able .

2Can Mysql also work with Microsoft access 2003

3What is the difference between Microsoft SQL Server & Mysql.

4And any other information that may help me.


Thank You For Your Time.
John Calcitrai.

View 9 Replies View Related

Microsoft JET Database Engine Error '80004005' Unspecified Error

Jan 28, 2004

Hi,

Im new to asp and access and have been having this problem for serveral weeks.

Every couple of days, all the asp pages on my site that communicate with the database start having 500 internal errors. i turned off the "Show friendly error messages" and one page gave me this specific error:

Microsoft JET Database Engine error '80004005'

Unspecified error

/admin/submitlogin.asp, line 8

I have tried a million things and have no idea why this is happening. Im not sure what other information i should post in order to see the problem. Any help would be greatly appreciated. Thank you,

Patrick

View 3 Replies View Related

Microsoft Jet Database Error

Jul 27, 2005

I had a fully working database that I decided to clean up by standardising naming formats etc. I have changed the tables names and changed all VBA links etc to the new table names.

This all appears to work fine. The database is still doing exactly what it should be doing. The only problem is whenever a record is updated I get the following error,

"The Microsoft Jet Database Engine cannot find the input table or query, "***". Make sure it exists and that its names is spelled correctly".

Where the missing table is the previously renamed table. All the updates etc work correct to the renamed table but I get this error whenever it is updated. I tried renaming the tables to their original names but then I got the same error for the new names.

Anyone got any ideas or will I have to rebuild the database.

View 1 Replies View Related

Help? Microsoft Jet Engine Error

Jun 20, 2005

Okay - well, I have figured out how to edit the schema file but now I am getting a different error message when I try to do the export:

The Microsoft Jet Database engine could not find the object "Form888.txt". Make sure the object exists and that you spell its name and path name correctly.

I believe that it is spelled correctly and I have changed the path a few times to see if it was that and it's still not working. Can anyone help me with this please?

My 641 export works fine the other 2 do not. I get the above error messge.

Someone else set this up for me and I know very little about VB. I kinda just do like trial and error, you know?


Heres the code:

Private Sub cmdUpload_Click()

On Error GoTo Err_Upload_Click
DoCmd.TransferText acExportDelim, ExportSpec, EDMISfile, txtUpload
MsgBox txtUpload & " written."
DoCmd.Close (acForm), "frmedmisupload"
Exit Sub

Err_Upload_Click:
MsgBox Err.Description

End Sub

Private Sub comEDMIS_AfterUpdate()
On Error GoTo Err_EDMIS

EDMISfile = "qryForm641"
Select Case comEDMIS.Value
Case "Form 641"
ExportSpec = "Form641_Export_Specification"
EDMISfile = "qryForm641"
txtUpload = "\Server01dataEDMISForm641.txt"
txtBegClient.Enabled = True
txtEndClient.Enabled = True

EDMISfile = "qryForm641A"

Case "Form 641A"
DoCmd.SetWarnings (False)
DoCmd.OpenQuery "qryMakeTcounsel"
DoCmd.OpenQuery "qrycombine"
ExportSpec = "Form641A_Export_Specification"
EDMISfile = "qryForm641A"
txtUpload = "\Server01dataEDMISForm641A.txt"
txtBegClient.Enabled = True
txtEndClient.Enabled = True
DoCmd.SetWarnings (True)


EDMISfile = "qryForm888"

Case "Form 888"
txtUpload = "\Server01dataEDMISForm888.txt"
EDMISfile = "qryForm888"
ExportSpec = "Form888_Export_Specification"
txtBegClient.Enabled = True
txtEndClient.Enabled = True


End Select
txtUpload.Enabled = False

Exit Sub

Err_EDMIS:
MsgBox Err.Description


End Sub

Private Sub comEDMIS_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub comEDMIS_Undo(Cancel As Integer)

End Sub

Private Sub Command6_Click()

End Sub

Private Sub Command9_Click()
MsgBox "Help Messages go here..."
End Sub

Private Sub Detail_Click()

End Sub

Private Sub Form_Load()
On Error GoTo Err_formopen

Dim begclient, endclient
begclient = DMin("[client Id]", "tblclientcontactinfo")
endclient = DMax("[client Id]", "tblclientcontactinfo")
txtBegClient = begclient
txtEndClient = endclient
BegClientID = txtBegClient.Value
EndClientID = txtEndClient.Value

txtUpload.Enabled = False
txtBegClient.Enabled = False
txtEndClient.Enabled = False

Exit Sub

Err_formopen:
MsgBox Err.Description

End Sub

Private Sub txtBegClient_AfterUpdate()
BegClientID = txtBegClient.Value

End Sub

Private Sub txtEndClient_AfterUpdate()
EndClientID = txtEndClient.Value

End Sub

Private Sub txtUpload_BeforeUpdate(Cancel As Integer)

End Sub

View 14 Replies View Related

Tables :: Deleted Error In Microsoft Access Linked Tables

Jul 24, 2014

I have developed a Microsoft Access 2010 database for my client and the database is split with Front-end/Back-end, the Back-end and the database is shared on Network, The client operating system and applications for all users are hosted and consistent and the service is delivered over Citrix.

The database some times corrupt the tables record and give a permanent #Delete Error, I have attached one of the database table and the screenshot of the error,

View 3 Replies View Related

HELPPPP!! PLEASE (Microsoft Error Reports)

Feb 6, 2006

:mad:

I have created an Access 2000 database sometime ago now that is split and has mutiple users. Which has worked perfectly fine.

I have since made some design changes.

I now have *most* of my staff saying that (mainly on reports) when they try to perform an action the standard Microsoft warning box appears saying Microsoft has encountered a problem and needs to close do you wish to send a report to Microsoft.

I am at a loss to why this is happening.

My PC is OK, and one *faultly* PC I checked had the same driver and service pack of access??. We have just moved over to Access 2003. Is this the cause.

I might as well go home !!!!

Thanks for any input.

View 1 Replies View Related

Microsoft Jet Database Engine ERROR

Jul 7, 2006

Hi,

We have been having intermittent problems with an MS Access 2000 front-end application linked to a SQL Server 2000 database recently.

From the switchboard a user was sometimes getting "There was an error executing the previous command". When she shut the application and opened it again it works fine for a little while - then the error occurs again.

I removed the generic error handling code from the code for the Switchboard form and I got the error message: "The Microsoft Jet database engine cannot find the input table or query 'Switchboard items'. Make sure it exists and that its name is spelled correctly."

I have been searching this forum and the web to find out what the cause of this error message is but I cannot find anything to go on or to try that might help get rid of this problem.

Does anyone know why this error occurs? Any idea how to stop it of happening?

Any ideas or suggestions would be greatly appreciated.

View 1 Replies View Related

Keep Getting Microsoft JET Database Engine Error

Oct 13, 2004

i get this error the time i enter info into a registration page from where i am getting all the customers info

Microsoft JET Database Engine error '80004005'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
in line 74
and my corresponding query is

Set Commrs2 = Server.CreateObject("ADODB.Command")
Commrs2.ActiveConnection=strconnect
line 74: Commrs2.CommandText = "INSERT into registration(username,fname, mname, lname, sex, address, city, state, country, pincode, phone, mobile ,email)VALUES('"&logid&"','"&fname&"','"&mname&"','"&lname&"','"&sex&"','"&add&"','"&city&"','"&state&"','"&country&"','"&pin&"','"&phone&"','"&mobile&"','"&email&"' )"
Commrs2.Execute

Set Commrs3 = Server.CreateObject("ADODB.Command")
Commrs3.ActiveConnection=strconnect
line 79 : Commrs3.CommandText = "INSERT into userpass(username,password) VALUES('"&logid&"','"&pass&"'"
Commrs3.Execute

also sometimes i get this on line 79
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.


i did a google search and i found this article
http://www.kbalertz.com/kb_884185.aspx
but i was not able to find the security warning dialogue box anywhere

i am using an access 2000 format database

any more info req plz let me know
thanks

View 5 Replies View Related

Error Message: Microsoft Jet Database Engine

Oct 19, 2006

I am trying to make changes to a particular field in Access but whenever I try to do this, I get an error messsage saying that Microsoft Jet Database Engine Stopped the process because you and another user are attempting to change the same data at the same time.

There is no once accessing the database at this time and this error message appears only when I go to that specific field. I've also tried to delete the whole row but it wouldn't allow me to do that saying the program has been locked.

Any solutions? Thanks,

Rajiv

View 4 Replies View Related

Microsoft JET Database Engine Error '80004005'

Oct 7, 2004

I have a recursive script that seems to timeout after a few dozen requests, the database is returning the typical "Microsoft JET Database Engineerror '80004005' " error ("Unspecified error").

The code is pretty straight forward, it is a function that calls itself to generate a tree structure for a site map. It works great the first few dozen times but seems to 'time out' and return the above error after a few dozen records (building the tree).

The code looks like this :

Function BuildContent(id,depth)
' open the children
Set GetKids = Server.CreateObject("ADODB.Recordset")
GetKids.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:usersXXXXhtmldb1.mdb"
GetKids.Source = "SELECT ID,Name FROM category WHERE parent = " & id & ""
GetKids.CursorType = 0
GetKids.CursorLocation = 2
GetKids.LockType = 1
GetKids.Open()
GetKids_numRows = 0


if GetKids.EOF <> true then
MyLinks = countlinks(id)
MyCats = countkids(id)
response.write "Number of Listings (" & GetKids("Name") & "): " & Mylinks & "<br>"

maxdepth = 1
BuildContent = "<ol>"
while GetKids.EOF <> true

KidsCats = countkids(id)
KidsLinks = countlinks(GetKids("id"))

if MyCats > 0 then show = true
if KidsCats > 0 then show = true
if depth < maxdepth then show = false

if KidsLinks > 0 then show = true
if MyLinks > 0 then show = true

if show = true then
BuildContent = BuildContent & "<li><a href='" & GetKids("id") & "_e.asp'>" & GetKids("name") & "</a></li>"
else
BuildContent = BuildContent & "<li>" & GetKids("name") & "</li>"
end if
if depth < maxdepth then BuildContent = BuildContent & BuildContent(GetKids("id"),depth+1)
GetKids.MoveNext
wend
GetKids.Close()
Set GetKids = Nothing

BuildContent = BuildContent & "<br></ol>"
end if
End Function

there are a couple of support fuctions :

Function countkids(id)
Set GetListing = Server.CreateObject("ADODB.Recordset")
GetListing.ActiveConnection = MM_Connection_STRING
GetListing.Source = "select * FROM category WHERE parent = " & id & ""
GetListing.CursorType = 1
GetListing.CursorLocation = 2
GetListing.LockType = 1
GetListing.Open()
GetListing_numRows = 0
countkids = GetListing.RecordCount
GetListing.Close
Set GetListing = Nothing
End Function

Function countlinks(id)
Set GetListing = Server.CreateObject("ADODB.Recordset")
GetListing.ActiveConnection = MM_Connection_STRING
GetListing.Source = "select * FROM records WHERE parent = " & id & ""
GetListing.CursorType = 1
GetListing.CursorLocation = 2
GetListing.LockType = 1
GetListing.Open()
GetListing_numRows = 0
countlinks = GetListing.RecordCount
GetListing.Close
Set GetListing = Nothing
End Function



I think the DB is being called too often, too quickly but I have no way of slowing the script down. If that's the case, is there a way to slow the code execution to give the DB time to catch up?

Otherwise, is it a driver problem (Microsoft JET Database Engineerror '80004005' ) and would switching to a OBDC connection give me better results or should I be using a different db driver?

Any help would be greatly appreciated.

View 4 Replies View Related

Microsoft JET Database Engine Error '80040e14'

Mar 16, 2005

I'm getting this error
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query _expression '123 street'.


The field in DB is type text. But the data to be written in the field is; number followed by characters. In other words it is an address field on the form, trying to insert new record into DB.


here is 3 different data I entered into field:


1. 'just some text' - works fine
2. 'text and number 123 ' - works fine
3. '123 number and text' - does not work. and gives the above error.
Anybody has any idea?

View 2 Replies View Related

Microsoft JET Database Engine Error '80004005'

Oct 19, 2004

I have an annoying error that i cant get round... the error i receive is:

Insert into TSContacts (CompanyId,FirstName,LastName,ThereMessage,JobTitl e,UserName,[Password]) Values(0,'','','','','','')


Microsoft JET Database Engineerror '80004005'

Field 'TSContacts.FirstName' cannot be a zero-length string. /vip_admin/AddContact.asp, line 55

dont really know whats going on here....

this is the addcontact.asp code:

'execute insert command
Dim strUpdate
Dim strFirstName,StrLastName,strLoginName,strPassword, strMessage,strJobTitle
strFirstName ="'"&Request.Form("strFirstName")&"'"
strLastName ="'"&Request.Form("strLastName")&"'"
strLoginName ="'"&Request.Form("strUserName")&"'"
strPassword ="'"&Request.Form("strPassword")&"'"
strMessage ="'"&Request.Form("strMessage")&"'"
strJobTitle ="'"&Request.Form("strJobTitle")&"'"
nCompanyId =CDbl(Request.Form("strCompanyID"))

strUpdate="Insert into TSContacts (CompanyId,FirstName,LastName,ThereMessage,JobTitl e,UserName,[Password]) Values("
strUpdate=StrUpdate & nCompanyID
strUpdate=strUpdate & ","&strFirstName
strUpdate=strUpdate & ","&strLastName
strUpdate=strUpdate & ","& strMessage
strUpdate=strUpdate & ","& strJobTitle
strUpdate=strUpdate & ","& strLoginName
strUpdate=strUpdate & ","& strPassword &")"
Response.Write(strUpdate)
dbServer.Execute(strUpdate)
if err then
'if error stop
response.write err
else
Response.redirect "customercontacts.asp?CUSTID="&nCompanyID
end if




'dbServer.close
'dbserver=nothing
%>
<body>
<p>&nbsp;</p>
</body>
</html>

can anyone help - its been driving me up the wall!

thanks,

butain

View 5 Replies View Related

Microsoft Jet Database Engine Stopped The Process Error

May 21, 2007

Hi All

My department has customer database using microsoft access with the main table being a linked table to SQL-Server database down in IT department.

I've only been recently made aware that the staffs have been having problem when trying to change or delete old data. It keeps on bringing up the error message

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
which is hardly the case since each staff are assigned only one customer to work on.

While it is technically possible to have many people working on the same data, business wise, it is impossible to do that.

I still come up with the same error even when the IT department confirms that no one accessing the SQL-Server table and I was the only one logged in.

This leads me to believe that there is something in the code that somehow preventing the table being edited or deleted. The problem is the database is so huge and was designed by my predecessor so I do not have any knowledge of the complete working of the codes behind it.

If it's the problem with the code, can anyone tell me what sort of codes caused this? If not, can anyone tell me what happened?

Any help would be most appreciated.


Thank you

View 4 Replies View Related

Password Protecting A Form - Microsoft Tutorial Error

Jul 22, 2005

I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:

"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.

I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...

View 7 Replies View Related

Microsoft JET Database Engine (0x80004005) - Unspecified Error

Sep 28, 2004

Hi all,
I got Win2000 and I just developed an intranet solution installed on my web server (IIS). The application worked nicely and there were not any problems. Few days ago I re - installed my OS and I installed the IIS and my intranet solution but there is an error and the application doens't operate correctly with the Access database.
When it tries to retrieve data from the database the following error appears:

Microsoft JET Database Engine (0x80004005)
Unspecified error

The line of the code which is indicated by the error is the following:

objConn.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = "&loc&"; Jet OLEDBatabase Password="&passwd)

I updated Microsoft JET and MDAC. I really don't know how to resolve this problem.
Any help will be appreciated,

ddz

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved