Omgili - forum search, search forums  
  

Discussions about access fe, sql

Displaying 1 - 10 out of 326 discussions.  
Time Frame: (Any time)   Minimum number of replies: (2)   Minimum number of discussing users: (0)
  |  

Page: 1   2   3   4   5   6   7   8   9   10  
Keep this page open to be updated with the newest discussions automatically.
On Sun, 14 Jun 2009 10:30:01 -0700, ryguy7272 <ryguy7272@discussions.microsoft.com I've been programming in Access for a little over a year now; used the app for several years prior to doing development work. I am just getting into SQL Server...
Started by on , 13 posts by 5 people.  
Answer Snippets (Read the full thread at omgili):
In my worked with Access as a front end on and off for ten years), my own personal preference is for ASP.NET., in Access ....
Cannot comment on .NET, but I've used Access FE with SQL Server BE on numerous occassions.
Has anyone tried this? Are there any good document references on this?
Started by on , 8 posts by 4 people.  
Originally Posted by patt When you say Client/Server, do you mean linking Access to SQL Server say present some latency when....
Client/Server, do you mean linking Access to SQL Server say? Unfortunately i don't have that book.
On Fri, 28 Aug 2009 21:29:52 -0700 (PDT), Tom <rtmnews@swbell.net All: I’ve been tasked with upsizing an Access database to SQL Server and am having some problems wrapping my mind around how to efficiently fetch data from the server. Pointers ...
Started by on , 11 posts by 6 people.  
Answer Snippets (Read the full thread at omgili):
* In reading "MS Access Developer's Guide to SQL Server" (Chipman and Baron) I had understood that one PlantID....
PDT), Tom <rtmnews@swbell.net In the meanwhile, a single Access FE can use 20 SQL Server databases not.
Ask your Facebook Friends
I've been away from Access programming for a while now, but I have a client who wants a little bespoke contact management system set up. I propose to use SQL Express as a back-end, and MS Access as a front end. What is the current state of thinking ...
Started by on , 8 posts by 7 people.  
Answer Snippets (Read the full thread at omgili):
It's called "Best of Both Worlds except "contact mgmt system" we... .
Access reports are superior to RS, even with a SQL backend Access as a client-server front-end to SQL Server databases.
You have a really good reason not to.
On Mon, 10 Aug 2009 10:52:22 -0700 (PDT), Edward <teddysnips@hotmail.com ACCESS 2003 Front End - SQL Server 2000 database Last week my clients reported problems with their application which has been running fine. They said that it had been very...
Started by on , 6 posts by 5 people.  
Answer Snippets (Read the full thread at omgili):
RAS, SQL Server 2008, you name it! It completely screwed up access to the database, unless you ran of packets at the Access Performance FAQ page at http://www.granite.ab.ca/access/performancefaq.htm Tony -- Tony Toews,....
On Fri, 24 Jul 2009 19:25:01 -0700, AccessNut <AccessNut@discussions.microsoft.com I split the db today into a fe/be because of the size. It did accomplish my goal of reducing the size of the be on the network, however, the front-end is still the...
Started by on , 11 posts by 4 people.  
Answer Snippets (Read the full thread at omgili):
-- Duane Hookom Microsoft Access exactly how to do....
Compact your database? Are there any images in the MDB? -- Duane Hookom Microsoft Access MVP > of the better pages at http://www.granite.ab.ca/access/performancefaq.htm.
I just started with this company on not sure how it's setup yet. I have a test environment which has everything that the real environment has. I was looking to change the SQL DB name (long story on why). I changed it in the SQL server management. Now ...
Started by on , 6 posts by 2 people.  
This access....
I looked at that (still in the beginning stage of access), but didn't think the house.
Way too to relink the tables.
The tables to SQL server though and that will allow you to secure the data without rewriting the FE.
On Tue, 11 Nov 2008 23:08:24 -0700, "Tony Toews [MVP]" <ttoews@telusplanet.net "a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.comwrote: ADPs were introduced in A2000 but haven't had any significant improvements since. Wrong...
Started by on , 10 posts by 3 people.  
Answer Snippets (Read the full thread at omgili):
13) Free Access 2007 in the _FREE_ ....
Again-- SSRS is included in the _FREE_ SQL Server Express products.
Support for UDFs in the GUI Access 2000 = months after release, there were patches for SQL 2000 support for Jet.
On Sat, 25 Jul 2009 05:52:01 -0700, AccessNut <AccessNut@discussions.microsoft.com Thank you Duane, compact & repair did the trick and reduced the size from 1.6 gig to 39,208 KB. So simple, I don't know why I didn't think of that. In answer to...
Started by on , 9 posts by 4 people.  
Answer Snippets (Read the full thread at omgili):
-- Duane Hookom Microsoft Access MVP > > Donna On Mon, 27 from the article: "Delete the SQL from the RecordSource and RowSource properties of the form load the appropriate....
Www.granite.ab.ca/access/performancefaq.htm.
One of the best practices as specified by Microsoft for Access Development is splitting Access application into 2 parts; Front End that hold all the object except tables and the Back End that holds the tables. The msdn page links there to the article ...
Started by on , 4 posts by 4 people.  
This is prone to corruptions on the....
But you shouldn't share a FE between multiple users.
It won't make a difference as far as data corruption .
To leaving the individual user specific copies of the FE on the server is netwrk performance.
Page: 1   2   3   4   5   6   7   8   9   10  

Related Message Boards & Forums

  • Stack Overflow
  • Office Applications | Windows Secrets Lounge
  • Forms - Access World
More Information


Forum Search About Omgili Help Plugins Forum/Board Owners Privacy

i
In Title
In Topic
In Reply
Exclude
Boost