Results 1 to 3 of 3
  1. 12-10-2008, 03:55 PM #1
    hornsby
    hornsby is offline Novice
    Join Date
    Dec 2008
    Posts
    2

    Access over network

    If my connection string to a mdb is on a network drive using a remote server, is it true that the entire database is transfered to me over the network before I can apply any SELECTs etc I want to perform ?
    Reply With Quote Reply With Quote
  2. 01-06-2009, 08:59 AM #2
    Othello911
    Othello911 is offline Novice
    Join Date
    May 2008
    Posts
    5
    That is correct. However if you have SQL express (free) and use that as your backend, then you could host the frontend on your machine and do the queries (SP) and processing on the server side which will greatly increase the speed of the things.
    Reply With Quote Reply With Quote
  3. 01-06-2009, 02:38 PM #3
    hornsby
    hornsby is offline Novice
    Join Date
    Dec 2008
    Posts
    2
    Thanks for that confirmation. I have been given this project from a previous developer, and am trying to understand why it is sometime so slow to startup.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Sharing mdb file across network with another computer
    By jimdukecenter in forum Access
    Replies: 0
    Last Post: 08-20-2008, 10:14 PM
  2. multiple user database on a network
    By felo in forum Access
    Replies: 1
    Last Post: 05-27-2006, 06:17 AM
  3. "Error Accessing file.Network connection may have been
    By admaldo in forum Forms
    Replies: 0
    Last Post: 05-24-2006, 09:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums