Well, I have a number of thoughts.  First of all, my guess as to why the upsizing wizard is incredibly slow is that you are running Access on your local...

It might be helpful if you posted the VBScript and/or the SQL so we could see what it's doing.

Perhaps another approach to using a join would be something like:

Select Info.Name from Info WHERE (Name.SSN IN (SELECT Customer.SSN from Customer)) OR (Name.SSN IN (SELECT OtherTable.SSN from OtherTable))

I just googled "ASP select sql" and lots of sites came up that seemed like they would help you.  There are lots of forums that are more oriented towards ASP...

what I would do is some time when no one is using the database, go to one of the other workstations that can access the db and create a new...

I was going to suggest that if your stored procedure populates a table, use DoCmd.RunSQL to execute the stored procedure then you could export to Excel from the table.

Dick

I have basically done what you are talking about on the switchboard, as follows.  The switchboard is set up normally with multiple switchboards (eg. Main, DeptA, DeptB, DeptC).  When the...

Here is just a wild guess (probably wrong), but I was wondering if it could be security related.  Perhaps when you run the SP the linked server knows it is...

Seems like you were asking for the last working day, not the last day.  How about scheduling the job to run every day, and then run a proc that has...

I'm assuming that your back-end data is in SQL Server.  If Discharged is a Yes/No field in Access you would just want to either have "AND Discharged" or "AND NOT Discharged"...

thanks

do you know where I could find a sample of doing that?

Oops - forgot you were in Access.  More like

Nz(Field1) Like forms!searchform!Box1 & "*"

Dick

I use something like

COALESCE(Field1,'') LIKE COALESCE(Param1,'')+'%'

Dick

perhaps posting the SQL statement you are using would help someone find what's wrong.  it also would be helpful to know the data types of the fields involved in the...