oh out of interest, ive simulated a good 500+ people hitting sql server from access at the same time and things kept going and going

its extremly ugly

Public Sub getQuerysSQL(QueryName As String)

    Dim qd As QueryDef

    Dim result As String

    On Error Resume Next

    Set qd = CurrentDb.QueryDefs(QueryName)

   ...

I had my access putting stuff into excell once using automation - I found it to be incredibly slow!!! Anyone else find that?...

We use a couple of hundred access clients all hitting a server at the same time in an intensive call center environment every year and its always coped fine (though...

oops appologies for the double reply, i guess this forum can accidentally allow your browser to double post the same message entered once

martin!

Some other tricks ive had success with in the past where importing forms and databases doesnt work....

- Go into your code modules and simple Ctrl-A (select all) and cut/paste the...

Some other tricks ive had success with in the past where importing forms and databases doesnt work....

- Go into your code modules and simple Ctrl-A (select all) and cut/paste the...

Heres a stab in the dark

My system here - we connect access<->sql server using IP addresses, on 100's of machines. Fine.

Except for mine ...

Ill tell you this for free - im not moving my combo boxes from bound to unbound

good luck with the threads, id be...

long shot - any account impersonation going on somewhere in your system? ive no idea if its possible with your setup but I know that can be an issue e.g...

"As you can see there are no service packs installed for SQL Server. If I add a service pack the CPU usage goes up to 100% and stays there for...

can you define `data is too much`?

im sure i remember trying/reading a long time ago that you cant access linked tables in the way your trying, though someone please prove...

what kind of connection and authentication is set up in the odbc on their machine if you go and have a look at it by hand for the machines odbc...

why cant you use a crosstab?

Do you have a small example set of data + the results you want from it?

How about processing your field with your values in it...