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
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
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?
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
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.
Thanks
I realize the long way to be good ACCESS programmer.
Would you recommend a good book for that ?
Elico
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.
Yes
Many thanks
Elico
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!
Yes it is
Elico
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.
Orange
many many thanks
I will do that .
Elico