I once had a machine where the ODBC went wrong after some third party software was installed. I could not run the ODBC window by clicking start-run and typin odbcad32...

I think it is only available through MSDN now. I recently signed up to MSDN and found the Access dev extensions on disc 3089.1, dated March 2006.

Depending how you define a week number, the 'iso week' function here may help:

http://www.cpearson.com/excel/weeknum.htm

If the vba function does what you want, you could try putting it in an...

Sorry no, but you could try asking these guys:

http://www.access-programmers.co.uk/forums

I have found them very helpful in the past..

If the service logs in with a domain account, has anyone changed the password or modified the account at all?

Paul..

Do you use Access workgroup security at all? If so, I think there is a /wrkgrp parameter that you can put on the shortcut command line when you open...

Might be worth considering the value of the data being held on different platforms...

e.g. Business critical data to be in SQL Server, especialliy if it needs to integrate with different...

To get started, you might try:

Make a new project in Vis Studio, choose other project types, then database. (Note I am using VS 2005)

Create a database reference when prompted (or...

Would it be fair that when a qotd is published and then found to be faulty, to admit that there was a mistake with the question and then cancel it?...

I take your point about unpaid overtime.

For the first eight years of my working life I was salaried, and had a standard company contract which stated hourly rates of overtime...

Out of interest, if your employer 'expects' you to work more hours than they pay you for, what valid reasons do they give to justify their requirement of your personal...

I found a snippet of sample code in my Access folder. Here it is, with the proviso that it is old, it came from some free online resource that I...

Is there an old LDB file hanging around in the same folder as the mdb/mde? Normally if you get all users out of the app then the ldb file is...

That sounds right to me. I have only ever seen one sql statement inside an individual Access query. I have never seen three individual sql statements chained together, delimited by...

Good question - how are you executing the command? I don't think you can use Access DoCmd.RunSQL instruction with Alter Table.