free advertising, online marketing, web site promotion, website traffic    What is LinkReferral?  |  My Account  |  Contact Us  |  Marketing Tips  |  FAQs     


Forums > website development > databasespost a new reply

Linkreferral Forums - access or sql
Post By: member_274555Post Date:   2010-01-10 07:28:21
name: parviz
location: California, United States
member since: 2010-01-05
member profile

http://www.doniakala.com
shopping / electronics
(39 reviews)

add to favorites
review this site

topics started: 12
replies posted: 60

access or sql

"what is difference between sql and access"
Post By: member_328958Post Date:   2017-04-25 10:30:26
name: salman
member since: 2011-04-24
member profile

http://www.protoninternational.com/...
computing / software
(195 reviews)

add to favorites
review this site

topics started: 1
replies posted: 134
Great Difference and Basic and Advance

quote
Post By: member_431306Post Date:   2017-03-31 07:59:02
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Excel is a good analytical tool but it is not designed as a database platform. It has certain database functions but if we want to store data properly, we often look for other database platform. Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. First, Microsoft Access is part of Microsoft Office family; second, Excel and Access are very well integrated together; last, its cost is quite reasonable.

Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server applications. However, as desktop is getting more powerful and SQL Server has introduced many different editions, the line between Access and SQL Server has become blurred. I would like to use this opportunity to compare these two products and how they differ from each other.

quote

Post By: member_432295Post Date:   2017-03-16 08:05:36
name: suresh
member since: 2016-05-18
member profile

http://www.sironjobexperts.com
computing / advertising
(119 reviews)

add to favorites
review this site

topics started: 0
replies posted: 117
Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. ... Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server

quote
Post By: member_431306Post Date:   2017-03-07 06:46:40
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. ... Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server.

quote
Post By: member_432295Post Date:   2017-02-27 07:14:18
name: suresh
member since: 2016-05-18
member profile

http://www.sironjobexperts.com
computing / advertising
(119 reviews)

add to favorites
review this site

topics started: 0
replies posted: 117
Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. ... Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server.

quote
Post By: member_431306Post Date:   2017-02-17 08:06:01
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server applications

quote
Post By: member_431306Post Date:   2017-02-10 06:31:39
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server application

quote
Post By: member_432295Post Date:   2017-02-09 03:58:37
name: suresh
member since: 2016-05-18
member profile

http://www.sironjobexperts.com
computing / advertising
(119 reviews)

add to favorites
review this site

topics started: 0
replies posted: 117
Excel is a good analytical tool but it is not designed as a database platform. It has certain database functions but if we want to store data properly, we often look for other database platform. Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. First, Microsoft Access is part of Microsoft Office family; second, Excel and Access are very well integrated together; last, its cost is quite reasonable.

quote
Post By: member_431306Post Date:   2017-01-25 06:17:30
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Excel is a good analytical tool but it is not designed as a database platform. It has certain database functions but if we want to store data properly, we often look for other database platform. Microsoft Access is the number 1 choice when an Excel user look for a relational database management system. First, Microsoft Access is part of Microsoft Office family; second, Excel and Access are very well integrated together; last, its cost is quite reasonable.

quote
Post By: member_432295Post Date:   2017-01-25 04:50:21
name: suresh
member since: 2016-05-18
member profile

http://www.sironjobexperts.com
computing / advertising
(119 reviews)

add to favorites
review this site

topics started: 0
replies posted: 117
Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server applications

quote
Post By: member_431306Post Date:   2017-01-17 07:27:51
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
The AND operator displays a record if both the first condition AND the second condition are true.

The OR operator displays a record if either the first condition OR the second condition is true.

quote

Post By: member_431306Post Date:   2017-01-05 08:29:58
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server applications.

quote
Post By: member_431306Post Date:   2017-01-04 08:11:38
name: Mick
member since: 2016-02-24
member profile

http://www.petveda.com
homelife / pets
(146 reviews)

add to favorites
review this site

topics started: 0
replies posted: 171
Image result for access or sql

Apart from Access, Microsoft also has developed another relational database management system, Microsoft SQL Server. It used to be a clear cut that Microsoft Access is designed for desktop use and Microsoft SQL Server is target for server applications

quote

Post By: FortyPoundHeadPost Date:   2016-12-18 23:48:42
name: Derek
location: Washington, United States
member since: 2008-02-11
member profile

http://www.fortypoundhead.com
computing / general
(308 reviews)

add to favorites
review this site

topics started: 10
replies posted: 73
Quoted from: member_431581 on 2016-12-18 23:06:29

Both are relational databases.

Access is designed for use by a single user, or a small group of less then 10 people. When you approach 10 users, things slow to a crawl, and you'd be better off upsizing to MS SQL or MySQL.

True SQL type databases are purpose built to handle many connections and many transactions per second, and is a much better choice for large applications or websites.

That being said, if you are coder of any sort, you can get some extraordinary performance with Access behind your website. While my current website uses MySQL on the backend, it used Access in its early days, and it was not uncommon for several hundred users to be hitting the site at the same time. Thanks to some crafty coding, the site ran fine, with minimal slowdowns.

So if you can't afford SQL, learn to code in the language of your choice. Code your site to be easily up-sized from Access to SQL when the option becomes available to you.

how did my post get attributed to this guy?

quote

Post By: member_431581Post Date:   2016-12-18 23:06:29
name: btc
member since: 2016-03-15
member profile

http://www.bitcoineverything.net
computing / general
(163 reviews)

add to favorites
review this site

topics started: 0
replies posted: 191
Both are relational databases.

Access is designed for use by a single user, or a small group of less then 10 people. When you approach 10 users, things slow to a crawl, and you'd be better off upsizing to MS SQL or MySQL.

True SQL type databases are purpose built to handle many connections and many transactions per second, and is a much better choice for large applications or websites.

That being said, if you are coder of any sort, you can get some extraordinary performance with Access behind your website. While my current website uses MySQL on the backend, it used Access in its early days, and it was not uncommon for several hundred users to be hitting the site at the same time. Thanks to some crafty coding, the site ran fine, with minimal slowdowns.

So if you can't afford SQL, learn to code in the language of your choice. Code your site to be easily up-sized from Access to SQL when the option becomes available to you.

quote

Post By: member_322752Post Date:   2011-05-17 08:32:42
name: kenneth
member since: 2011-02-26
member profile

http://www.ipod-app.blogspot.com
computing / software
(19 reviews)

add to favorites
review this site

topics started: 1
replies posted: 17
any site suggestions about SQL tutorial? :)

quote
Post By: member_267165Post Date:   2010-11-08 17:07:52
name: ja linda
location: Washington, United States
member since: 2009-10-31
member profile

http://www.rocqueyashi.com/ince
entertainment / products
(109 reviews)

add to favorites
review this site

topics started: 7
replies posted: 67
Quoted from: on

thank you so much.... for the comment...

quote

Post By: member_262036Post Date:   2010-07-28 13:12:48
name: Ashutosh
location: Delhi, India
member since: 2009-09-23
member profile

http://www.tekblogger.info
computing / general
(139 reviews)

add to favorites
review this site

topics started: 0
replies posted: 53
MS-access is a very nice platform for learning database programming...and in knowing how to use queries for doing different functions in a particular database.

quote
Post By: member_174682Post Date:   2010-06-25 16:56:00
name: Sergio
location: New Jersey, United States
member since: 2008-06-13
member profile

http://www.replaysport.com
entertainment / sports
(444 reviews)

add to favorites
review this site

topics started: 74
replies posted: 168
The language sql is used in both access and mssql server, but the diff between the two servers is huge. Access is a toy compared to mssql. But to not pay the fees for licencing for mssql you can use mysql which is free and is very powerful liek mssql. I woudl stay away from using access as your DB.

replaysport.com

quote

Post By: member_294498Post Date:   2010-06-14 21:15:47
name: Leonard
location: Texas, United States
member since: 2010-06-12
member profile


http://npcompleteproof.wordpress.co...
computing / hosting
(8 reviews)

add to favorites
review this site

topics started: 1
replies posted: 3
The difference between Access and SQL is that

Access is an application program that uses SQL internally. SQL is also used in SQL Server and Oracle and MySQL, because it is generally a universal method of encoding the interface between a piece of software and the database server engine.

quote

Post By: member_232933Post Date:   2010-05-24 01:53:45
name: JA LINDA
location: Nevada, United States
member since: 2009-03-29
member profile

http://www.rocqueyashi.com/strat
money making opportunities / information
(244 reviews)

add to favorites
review this site

topics started: 35
replies posted: 212
Quoted from: FortyPoundHead on 2010-05-13 22:16:25

Both are relational databases.

Access is designed for use by a single user, or a small group of less then 10 people. When you approach 10 users, things slow to a crawl, and you'd be better off upsizing to MS SQL or MySQL.

True SQL type databases are purpose built to handle many connections and many transactions per second, and is a much better choice for large applications or websites.

That being said, if you are coder of any sort, you can get some extraordinary performance with Access behind your website. While my current website uses MySQL on the backend, it used Access in its early days, and it was not uncommon for several hundred users to be hitting the site at the same time. Thanks to some crafty coding, the site ran fine, with minimal slowdowns.

So if you can't afford SQL, learn to code in the language of your choice. Code your site to be easily up-sized from Access to SQL when the option becomes available to you.

thanks for the comment...

quote

Post By: Post Date:   2010-05-18 14:15:35
name:
member since:
member profile


(0 reviews)

add to favorites
review this site

topics started:
replies posted:
sql is a rdbms were access is not.
Post By: Post Date:   2010-05-15 14:25:32
name:
member since:
member profile


(0 reviews)

add to favorites
review this site

topics started:
replies posted:
access is basically just a database in name only... if you are serious about having a rdms for your website sql server or as many other have mentioned mysq; is the way to go
Post By: member_239926Post Date:   2010-05-14 09:20:44
name: Earl
member since: 2009-05-11
member profile

http://www.codeandwebdesigns.com
money making opportunities / services
(52 reviews)

add to favorites
review this site

topics started: 5
replies posted: 58
I prefer MySql it is easy to use once you learn how to do queries and you can control users. I was able to find a free version with a search on the internet.

quote
Post By: FortyPoundHeadPost Date:   2010-05-13 22:16:25
name: Derek
location: Washington, United States
member since: 2008-02-11
member profile

http://www.fortypoundhead.com
computing / general
(308 reviews)

add to favorites
review this site

topics started: 10
replies posted: 73
Both are relational databases.

Access is designed for use by a single user, or a small group of less then 10 people. When you approach 10 users, things slow to a crawl, and you'd be better off upsizing to MS SQL or MySQL.

True SQL type databases are purpose built to handle many connections and many transactions per second, and is a much better choice for large applications or websites.

That being said, if you are coder of any sort, you can get some extraordinary performance with Access behind your website. While my current website uses MySQL on the backend, it used Access in its early days, and it was not uncommon for several hundred users to be hitting the site at the same time. Thanks to some crafty coding, the site ran fine, with minimal slowdowns.

So if you can't afford SQL, learn to code in the language of your choice. Code your site to be easily up-sized from Access to SQL when the option becomes available to you.

quote

Post By: JonPost Date:   2010-05-10 22:16:27
name: Jonathan
member since: 2010-05-06
member profile

http://games.virtualtoybox.org
computing / software
(82 reviews)

add to favorites
review this site

topics started: 1
replies posted: 16
Quoted from: member_275557 on 2010-01-16 19:42:15

Many people disregard access as a database platform but it is a fairly decent database as long as the database will be used by a single user and access.

I worked for a company that exclusively used Access VBA applications for a while. They were fine until multiple users tried to connect, then performance went down the toilet. We migrated one system to an Access front end connected to an Oracle database.

quote

Post By: member_288302Post Date:   2010-05-01 06:55:09
name: siraj
member since: 2010-04-19
member profile

http://www.studioload.com
entertainment / music
(21 reviews)

add to favorites
review this site

topics started: 0
replies posted: 18
i don't no

quote
Post By: member_264076Post Date:   2010-02-07 08:07:38
name: farzad
location: Ontario, Canada
member since: 2009-10-07
member profile

http://www.donyakala.com
shopping / home
(39 reviews)

add to favorites
review this site

topics started: 5
replies posted: 62
what is difference between sql and access

quote
Post By: goodnreadytogoPost Date:   2010-02-06 23:41:51
name: Lenore goodnreadytogo
location: United States
member since: 2009-08-02
member profile

http://shop.goodnreadytogo.com
shopping / gifts
(276 reviews)

add to favorites
review this site

topics started: 1
replies posted: 278
Quoted from: Peter member_278694 on 2010-02-06 18:49:01

Huge difference. Abandon access and start learning SQL. Transact SQL I mean. Good luck.

Thanks for the info. Lenore, goodnreadytogo

quote

Post By: Peter member_278694Post Date:   2010-02-06 18:49:01
name: Piotr
member since: 2010-02-04
member profile

http://peterbestptc.blogspot.com
money making opportunities / information
(11 reviews)

add to favorites
review this site

topics started: 0
replies posted: 4
Huge difference. Abandon access and start learning SQL. Transact SQL I mean. Good luck.

quote
Post By: member_273993Post Date:   2010-01-18 22:13:27
name: Lenore
location: United States
member since: 2010-01-01
member profile

http://www.goodnreadytogo.01viral.c...
computing / advertising
(54 reviews)

add to favorites
review this site

topics started: 0
replies posted: 67
I'll be interested in the answer. Best of success. Lenore, goodnreadytogo

quote
Post By: member_254465Post Date:   2010-01-18 11:35:15
name: Richard
location: United States
member since: 2009-08-03
member profile

http://www.divorcelawyerinaugustage...
social / general
(518 reviews)

add to favorites
review this site

topics started: 1
replies posted: 280
Thanks for the info, Johny.

quote
Post By: member_275557Post Date:   2010-01-16 19:42:15
name: Johny
location: Florida, United States
member since: 2010-01-12
member profile

http://thethingswetalkabout.com
social / general
(49 reviews)

add to favorites
review this site

topics started: 0
replies posted: 9
Many people disregard access as a database platform but it is a fairly decent database as long as the database will be used by a single user and access.

quote
Post By: member_269797Post Date:   2010-01-13 17:08:42
name: Muhammad
member since: 2009-11-25
member profile

http://forex4pk4u.blogspot.com/
money making opportunities / general
(56 reviews)

add to favorites
review this site

topics started: 2
replies posted: 57
please advice me what i do for visiting my website

quote


post a new reply0 - 34 of 34 replies    << prev  |  next >>






Free website marketing, free traffic

Looking for free traffic for your website? Linkreferral provides free advertising for web sites, blogs, personal pages and affiliate links. Our services provide several different online marketing strategies including network, social and search traffic. It's no risk, take a minute to signup and start receiving web traffic immediately. Advertise for free now.

©2017 All Rights Reserved..   Terms Of Use