Depends on what Access version you are using since the more recent ones work with MSDE (slimmed down sql server). In this case they have the same query syntax.

1) The...

the auto close option of the database is on?

IIS en SQL SERVER on the same machine?

Is is possible to put IIS on one machine and SQL Server on another?

How is the authentication to sql server set up?

Windows authentication or sql authentication.

do you log in using Windows authentication or sql authentication?

Be sure your idenitity fields are still identity fields, also your timestamp fields.

Any recent changes (new programs,...) that could coincide with the start of the occurances?

Could be a permission problem. You have no problem running it under the sql server agent account?

You can script out the jobs, by rightclicking the job and chose All Task -> generate script.

Hello Lynn,

The option NT-fibers is generally not needed and should be turned off.

Microsoft has a document on

How to determine proper SQL Server configuration settings

http://support.microsoft.com/default.aspx?scid=kb;en-us;319942

a longer version can be found...

SQL Server always expects . as decimal seperator.

Language settings affects system messages & datetime formatting.

See "languages, supported" in the books online

RayM,

Some countries, like Belgium, use 1,5 instead of 1.5 for one...

2)The sql server administrator will be able to reveal it all.

Perhaps using encryption on sensitive data will hold them off changing it.

The setup is like Karl Klingler said.

Every weekday I plan a full backup of each database at 5.00 am (normal batch end time), should have finished around 8.00 am.

Saterday: full batch...

I removed the truncate log step and the no_truncate clause.

So far so good. Thanks for the advice.

 I'll repost in a few days.

It might be not needed if it isn't visible to the outside world, but every service pack fixes some bugs.