Terence-
Did you try my little test? It still won't be sub-second, but it should be a ton better.
Yes, your idea will fly as long as you remember to open and leave open a link to SQL Server AND your Access BE.
If you need the large storage and/or security, then SQL Server is the only way to go. Using little tricks like the one I gave you will make performance "acceptable." Until you get into something requiring complex (and slow) calculations in the front end that you can push to a Function or SP in SQL Server, Access will always be faster for smaller databases.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On May 18, 2015, at 9:27 AM, buffalome000@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John, Oh My God, this is like drilling teeth without Novocaine!
John, you and many others have assisted me many times over the years, but this dilemma is a very hard pill to swallow.
I asked the following in a previous response to you, but I really want to understand the philosophy of this a bit better.
"But it begs the question.
Why the heck would I move to a SQL server if the response time would degrade this far from a plain old access BE on a shared drive ?"
I've been paging through your book Inside/Out looking for comfort and solace and come up empty!
My only recourse for this poor application is as follows:
The application FE sits on the customers desktop.
I link to a ms access BE on a shared drive for tables which require fast access (transnational), an assume they are small in size.
In one instance I have a large table which requires very secure access, (Patient Data) so I put this out on the SQL server.
What I end up with is an Access FE on desktops which is ODBC linked to an MS ACCESS BE on a shared drive, in addition to an ODBC linked to a SQL SERVER for my 5 gigabyte secure warehouse.
Will this fly ?
terence
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (21) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar