There are two main means of achieving the design goals of a multitenant database system – in Part one, we outlined the issues when using a physical database separation design. Here we will look at logical separation design and the suggested implementation techniques. Logical Separation: Less secure, [...]
Microsoft Access 2013 Upgrade is out and both Ben and have been experimenting with it for sometime now. Here are 10 things we love about the new Access web services: 1. It's SQL Server-based. (Ben) It used to be that Access had its own database engine, known originally as JET and now called ACE. We [...]
I've been traveling the USA for the better part of two years talking about how to rev up Access with SQL Server, after hundreds of attendees, many miles traveled and more road meals than I care to remember, I finally got around to recording it. Here it is and PLEASE leave a comment below! https://yo [...]
Had a great chat with Robert Crane and the Computer Information Agency about starting an Access practice, when Access is a great tool for business and how to obtain new clients. You can hear the podcast here: Let me know your thoughts in the comment section below! [...]
If you did not make it to our live session you can do the next best thing, see the recording below: [vimeo]https://vimeo.com/45720384[/vimeo] If you attended the session please leave a comment below. [...]
Come join us tomorrow morning at 8 AM Central Daylight Savings Time, (GMT-5), for a great session on high level Access topics! To join, just go to www.join.me/accessexperts. You will need to either use the computer speakers and type your question or click on the phone icon at the top of the toolbar. [...]
My Access Kung-Fu is strong, join me on July 13th as I demo advanced topics I previously held this session at night, but that made it almost impossible for Europe or Asia to participate. Now you can join me this Friday at 8 AM for a two hour world wide session. Here is what you will learn: Master th [...]
Microsoft last Monday held a press conference to demo a new tablet called Surface, you can catch the 90 second summary here. One Killer Feature missing on Tablets: Corporate Databases There is no way to enter, store and upload data to corporate databases using existing tablet technologies without us [...]
A while ago, I wrote about securing the ODBC connections which was published on Access team's blog. Also, Juan recently wrote about the alternate method of deleting/recreating linked tables in a four part article. But what about ADO connections? A typical approach for creating an ADO connection may [...]
Access can do great things, on a short time frame and with a smaller budget than other technologies. If your client can't see the benefits of your work it's your responsibility to step up and show them how your work output should be considered as part of a profit center. Here's how: -- Perform a pay [...]
Today's guest post come's from Mark Davis, a Access MVP. You can learn more about him at http://www.linkedin.com/in/markgerarddavis The concept of a subquery itself is fairly straightforward: have a query within a query. However, there are various applications of the subquery. Most frequently, a sub [...]
