(0x80040E14) Syntax error in INSERT ; (0x80004005) file already in use

?
pls explain.
i do not use VBA, i do not even have any VBA code.
and
pls if possible to address both Q's above.

thanks

VBA isn't necessary to ger references, when you did experiment e.g. with a form and an ActiveX control Access will add a reference for you, even after deleting the form entirely.
Thus I would start with removing any references (when present) till the last two that are mandatory.

Normally a database working on one PC and failing on another has to do with these references so that's why I posted this to start with.

Nic;o)

Nic,
thanks but,
excuse my ignorance here,
pls explain some more how do i remove those refernces,
is it through D.Weaver or what? how?

No, you'll need to open the database with MSAccess.

Nic;o)

ok,
i will try it after work,
could u pls address my 1st Q:(
1.
I have simple ASP program done using  D.Weaver MX2004, to do simple insert,
but i keep getting this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

this is using  XP,
i have very similar prog at work using win2000, working ok!)


Regards

by the way,
i tried this at work pc,
did not find any libraryname starting with "MISSING">

Nic,

i have set the authorization for that DBase as allow all.
but, i do not think i did it for the folder containing it!
i will have to check.
pls note that it is two diff environment, window 2000 at work,  
 XP with SP2 at homw where I'm having the problem.
also, record set connection is being updated to suit the XP/home pc env.


thanks

Keep me posted :-)

Nic;o)

did not find any libraryname starting with "MISSING".
but i did set the authorization the  folder containing the DBASE!
though i have the *.LDB, when opening the asp file in D.Weaver MX 2004, but does not seem to complain
about the DB being open,...

now,
still getting this error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Entry.asp, line 78

when trying to insert RS.

some of the code:

    var MM_editCmd = Server.CreateObject('ADODB.Command');
    MM_editCmd.ActiveConnection = MM_editConnection;
    MM_editCmd.CommandText = MM_editQuery;
this is line 78:    MM_editCmd.Execute();
    MM_editCmd.ActiveConnection.Close();

    if (MM_editRedirectUrl) {
      Response.Redirect(MM_editRedirectUrl);



thanks

I got it !

:)

Glad you solved it, and the answer is: <sound of drums> <sound of drums> <sound of drums> <sound of drums>

Nic;o)

:)
at work i have the server model : ASP VBSCRIPT,

while at home, it is ASP Javascript,

so i set it to ASP VBSCRIPT,
and defined new site, connections, odbc.

u been very keen to help.
thanks a lot, u deserve .. :)