When you schedule it to run, it runs on the server.

When you run it manually, it runs on the client that you are running it from.

Probably find the dsn used...

If I remember rightly, when you start ms access it needs to find the workgroup file and authenticate the user.

In order to get this to work, I think you need...

If you use dts, you can provide a username and password in the connection that will validate the login and allow you to select from a table.

If you have never...

Just give her db_datareader at database level.

Double click on the users name in the users folder under the database and tick the box.

However, if you have set the database to...

I joined the customer table in the function to return a list of customer names rather than IDs and it works perfectly.

I am now able to display an asp page...

Alternatively.

Paste this into general dec section

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

RedFlag1.Visible = False ' set to false at beginning

If Now > ([1st Treatment Date] + 105)...

Your way looks pretty OK to me. Slight change for you.

RedFlag1.Visible = False ' set to false at beginning

If Now > ([1st Treatment Date] + 105) Then

...

Apologies for delay in getting back to you.

Unfortunately, I have never used surrogate keys before as I have never come across the need and think they add complexity to data...

I cannot see how it is possible unless the format is consistent.

The only thing you can do is to read each line out of the text file and insert into...

Certainly not an envious task.

Does the text file always appear in the same format. IE The same number of lines, the text a consistent type?

If so, you may have a...

If you are prepared to do this manually and there is not a lot of data, you can use excel.

Select a row, copy it into excel using paste special /...

Thanks Ryan.

I will give it a go with your scenario.

I decided to use a function.

I will pass in the ID and then cursor through appending to a variable that I will then return from the function.

There's never going to...

Genius. Thanks for the help. I just need to display a list of mail recipients on one row in an asp page, so this does the job exactly.

Why not use Enterprise manager?

I don't think any third party applications will work with it.