Results 1 to 11 of 11
  1. #1
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29

    ACCESS and SQL SERVER the reason

    Hi all

    Is the only reason for using SQL SERVER by ACCESS to enable multi user to the tables stored in the server ?

    Thanks
    Elico

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    No, multiple users can access data tables in Access, especially if the database is properly split into a Front and Back end.
    Memory/processing power is another big reason. Access databases can only be 2 GB of data. Even if it is less than that, but large, performance can be very poor. SQL has a lot for processing power and can hold a lot more data.

    You seem to be asking a lot of questions regarding Access and SQL. Are you doing some sort of assignment?

  3. #3
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29
    No I am trying to learn the subject of SQL and ACCESS .

    The questions I ask are derived from videos I see on YOUTUBE , related to this very interesting subject.

    I will pause the SQL subject until i will finish the ACCESS programming subject.

    I am new to access and doing my first steps on the subject.

    Many thanks any way

    Elico

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    OK. That is good that you are trying to learn about before getting too heavily involved. There is a lot to learn with Access (I certainly don't want to discourage you from asking questions and learning!).

    Regarding your question, there are probably other reasons too, but that is the most obvious/common one I see.

  5. #5
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29
    Thanks
    I realize the long way to be good ACCESS programmer.
    Would you recommend a good book for that ?

    Elico

  6. #6
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you are interested in database design, I think the most helpful things to me where first learning about things like Relational Database theory and Rules of Normalization. The following two links have a lot of good information on those topics:
    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
    https://support.office.com/en-us/art...rs=en-US&ad=US

    Then, for the Access side of things, a good introductory book was helpful to me. I used the Microsoft's "Step-by-Step" series for Access (some 15 years ago). After that, I used Wrox Press "Beginning Access 2000 VBA". That are lots of similar books out there (more recent versions, and probably some better than what I used 15 years ago).

    Of course, if you do indeed set-up the data tables in SQL, then you may need to learn a bit of SQL also. Behind the scenes, Access and SQL are very similar (I say Access is really just a simplified GUI version of SQL). So you can definitely start with Access and build your way up to SQL.

    There is a lot there (and it is a steep learning curve), so give yourself lots of time, if you are going to dive into database development with Access and/or SQL.

  7. #7
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29
    Yes

    Many thanks
    Elico

  8. #8
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome! Though there is a lot to learn, it is some pretty powerful stuff and pretty cool once you get a handle on it!

  9. #9
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29
    Yes it is
    Elico

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Elico,

    These are 2 youtube series that I strongly recommend.
    Soper DATABASE 8 part series
    I suggest you watch 1, 2 and 4 before getting into nitty gritty Access programming.

    Programming Access vba by Steve Bishop
    This is a series of over 70 videos. I gave you the link to the first, but you can do some searching to find specific subjects.

    Good luck.

  11. #11
    elico is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    29
    Orange

    many many thanks
    I will do that .

    Elico

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-10-2015, 10:34 AM
  2. Replies: 3
    Last Post: 06-17-2015, 05:18 PM
  3. Replies: 1
    Last Post: 02-23-2015, 07:06 AM
  4. Replies: 4
    Last Post: 04-22-2014, 12:36 PM
  5. Replies: 2
    Last Post: 11-21-2012, 09:57 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
  •  
Other Forums: Microsoft Office Forums