Recent content by anishkgt

So i just copied the same access file on my work desktop and there it seems to work without a problem.....No syntax error.

MIRSeq is a number and TicketNumber is a short text

Sorry ! i thought it would be obvious as it was mentioned in the previous posts. the line If DCount("FileID", "qryMIR", "[MIRSeq]=" & MIRSeq & " and [TicketNumber]=""" & tkt & """") Then 'validate MIR Sequence number and Ticketnumber to avoid Duplicationthrows an error. A sample file to read...

Attached here is the complete code to uploading data from a text file into a database

I get the same error over and over again " Syntax Error"

Here is the complete macro

The open field is number so that i could write it 0 or 1. If its Yes or NO it would be a check box so let it as number.

the error just says "Syntax Error"

I get a syntax error for this DLookUp("[LockNum]","tblImportLock","[Open]=1") LockNum is of DataType Number I used macro to code the form. It just checks a filed value for 1 or 0. It had been working but just today an error poped-up.

Yea if its hosted by a service provide then it should probably be a SQL. MySQL can also be dine but i guess the "outside contractor" has done it on SQL. But the statements used are pretty much the same. So i guess you need to get the username and password to the server.

yea i guess if you hover your mouse on one of the tables you can see the type of connection and send a screenshot of it.

Yea. Forgot that😁. So if your writing into the db on the server then you'll need to connect via odbc connector with a username that has read/write access.

I'd suggest dick convert the linked tables to local and play around with. Yea SQL or MySQL. Dick which one of these are used in you company?

If you can't edit the table from the front end are you able to edit from the backend? Seems like a read/write issue. Got to have that fixed before going forward.

Your welcome. Glad i could help.