Viewing 15 posts - 256 through 270 (of 274 total)
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 6, 2011 at 10:59 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 6, 2011 at 10:04 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 6, 2011 at 9:20 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 6, 2011 at 8:59 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 20, 2011 at 7:03 pm
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 6, 2011 at 11:05 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 29, 2011 at 2:43 pm
chriej1 (4/20/2011)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 20, 2011 at 4:53 pm
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 15, 2011 at 8:00 am
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,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 3, 2011 at 5:39 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 24, 2010 at 8:07 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 23, 2010 at 11:16 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 23, 2010 at 10:58 am
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. ...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 2, 2010 at 8:50 am
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...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 2, 2010 at 8:11 am
Viewing 15 posts - 256 through 270 (of 274 total)