Viewing 15 posts - 166 through 180 (of 273 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...
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...
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....
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
February 7, 2013 at 3:22 pm
RonKyle (12/26/2012)
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....
December 21, 2012 at 4:45 pm
Viewing 15 posts - 166 through 180 (of 273 total)