Viewing 15 posts - 166 through 180 (of 274 total)
We take a somewhat different approach to the issue of recording who created a record in a table. We define a column in each table called "WhoCreated" or something...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 16, 2013 at 6:57 am
We've done a number of demos of that type using either remote desktop or LogMeIn using Access and actually let them play with the prototype and make suggestions, and it...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 11, 2013 at 10:53 am
It is possible to view what is called a "hybrid" web database using SQL Azure using an Access front-end, so you could try using the 2013 runtime in that mode....
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 11, 2013 at 10:19 am
Taking a look at what you saw on MSDN I can see how you found it wanting. I looked and saw nothing in the Operators, but if you click...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 5, 2013 at 4:33 pm
We've been doing that very thing for about 20 years, starting with Access 2.0 Beta in 1994, and SQL Server 4.21. Although we do use other strategies from time...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 22, 2013 at 3:11 pm
FWIW, if you are a relative novice at creating SQL statements in Access, the query designer will do a very nice job for you and make troubleshooting such statements much...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 4, 2013 at 3:52 pm
You are joining on an expression on the right side, while the left side appears to be the two name fields separately. Create the same expression on the left...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
June 4, 2013 at 9:37 am
To my knowledge Microsoft has not divulged the internal structure of indexes in any version of Access. And there are at least 4 distinct versions of the JET engine...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 24, 2013 at 7:22 am
Since you are using Integrated Security, as long as you have permissions set both on the linked view in your local database, and on the view in the remote database,...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 11, 2013 at 2:55 pm
Can you clarify what you mean by a linked server? Is that being done at the SQL Server level so that the view shows up in the SQL database...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
May 9, 2013 at 4:59 pm
Well, it seems it has to be a connectivity issue. I disabled all the firewalls (the machine attempting to connect has two - Windows and Kaspersky), and still cannot...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 23, 2013 at 4:34 pm
In order to solve this sort of problem using Group By queries, you need to use multiple queries. The Max function is simply taking the Max function of the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
April 23, 2013 at 4:29 pm
If the first user opens any form, report, macro or code, the database is locked exclusively to that user - from Access 2000 forward. Also in Access 2007 forward...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 7, 2013 at 3:22 pm
RonKyle (12/26/2012)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 26, 2012 at 8:36 pm
And there is. Open your database so the Navigation Pane is visible, and then choose File on the ribbons. In the center you should see three large buttons....
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 21, 2012 at 4:45 pm
Viewing 15 posts - 166 through 180 (of 274 total)