The mystery persists - if I replace the RAISERROR statement with a Print statement, no message is displayed. If I reduce the severity level of the RAISERROR statement to...

I use this same scenario with a number of different clients, some using Access 2003, some using 2007 and some using 2010, so I don't think it is an Access...

Did you create a System DSN or a User DSN on her PC? I've seen this happen occasionally when a System DSN was used. If that is your...

Unfortunately, the RAISERROR was added just to verify that the trigger was actually executing. The 16 does prevent the delete from actually happening, but when I take that statement...

Can you embed the query that selects the 25,000 values into SQL Server as a view? (I presume it isn't really an In() statement with 25000 values - that...

I've used nested IIf() statments in Access since version 2, and it always seemed to give me an error without a false part. However I constructed a statement which...

Note that you can also use SQL Server Native Client 10 (the current version) with SQL 2000 and 2005 as well as 2008 - it seems to be the most...

chriej1 (4/20/2011)

---

... I am trying to parse a dynamic text field that looks like this "HR=62 bpm, NIBP=109/60 mmhg, SpO2=96.0 %, Resp=45 B/min". The part i want is the '109'...

If you make the Invoice Number field (column in SQL Server) the primary key for the table, or at least add a unique index using that field, you will prevent...

Well, it turns out to have been a small configuration issue with the Alias configuration. If you are using an alias to connect to a 32-bit SQL Server installation,...

I believe by default Access ADPs use the OLE DB provider, but you can change the connection string. How you do it depends on the version of Access you...

Are you using hierarchical recordsets in SQL Server? If you are not, then there is no need for the Provider keyword of the connect string. You might find...

If you have the latest version of the Upsizing Wizard for Access, it should have renamed your Access tables with a "_local" suffix, and created and ODBC link to the...

If you are trying to limit what forms and reports some users can see, you will also need to implement some sort of security scheme on the Access front-end. ...

If you mean that the server doesn't need an external IP address, that is correct. However the router for your network must direct SQL Server traffic on port 1433...