Search results

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.

Dynamic dns or dyndns is a subscription for an year for 11$ (i think)dyndns.com should give you the prices. Once you have a host name after you've subscribed then configure that name into the front end while linking the tables. Like \\testdb.com\inventory\inventory_be.accdb I haven't tried...

Well if i were you and to have access the backend from internet i'd be setting up dynamic dns. Have it all set in the back end and do the required to forward a port to the db.

So you wish to have the front end have access to the backend via the internet is that what your looking for here?

Not exactly the front end will have a link to the backend. I understand that you don't have any access background. If so then I recommend you go to the link to have a better understanding how the whole access thing works. The SQL idea, maybe you have heard it somewhere that the backend needs an...

The sql part comes into use only in queries. Those are used in the front end and not so much in the backend.