Well in that case... The safest way to handle this is too create a table with a single line with a flag.

When the trigger is called, update the flag...

I'm assuming that this is the id of the table.

I would split the id in 2 columns like :

order id = 123456

item number = 1

Am I understanding your situation...

You don't have access to the application and need to have it modified outside of your office?

As I said, I kow it's possible, but not without extensive permissions (which could be used by hacker) and having to do some gymnastics to call the process from outside...

This is a task that should be handled with the client application. while the server can certainly do this. It cannot do it safely, easily. I would...

the dash cannot be converted to an int...

are you trying to increment like this 123457-00 or like this 123456-01?

And what's in that file?

How does it relate to the insert?

As I said before, it's not a good idea to start a process in a trigger.

What does the batch file do?

I just found the reference I was searching about the rogue crlf (Aaron Templeton's answer) :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=139302

Hmm.. Seems like a linked server would be great in this situation.

Is there a reason why you can't move the whole access db in one shot (like the app needs...

1 - Simply put : NO (what happens when you need 20 items)

2 - Too much overhead on the server/network

3 - Yes, have a look how to accomplish this task...

What code are you using now?

What error(s) are you getting?

Why can't you run that query from the application itself?

Have you checked with the task manager?

Sorry for being persistant, but sometimes the application is not visible... and I don't know any other way of getting that message

Thaught of something else... Even when all the users are out, sometimes the .lock files is not deleted. Make sure it's gone and try again.