Let us appeal to Microsoft to increase size limit of ms access db

we have this discussion on this forum maybe I could just link this for you.

http://www.access-programmers.co.uk/...d.php?t=173517

maybe I dont not know much of some informations but what I said here was also
just informations coming from forums that I have entered onto to talk about
access issues.

I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway Chris, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also relevant is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database file.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

Hi Rommel,

I've read all the posts in this thread and in the other forum you mentioned. Many people have
already raised some good issues so I won't repeat the same, however, it doesn't appear to me that
anyone has asked the most important question of you yet.

What would you like to see the capacity set to?

It seems like an easy question, but unless I've missed it, I don't see what new capacity limit you'd
like to have in any of the posts.

I'll take your feedback and pass it on to the team.

From my own experience before coming to Microsoft, as well as after, if a limit is set on something
(whatever the area) there will always be someone that comes along and says, "I'd like to have Limit
+ 1." If we set a new limit, for example, at 4GB, someone else will undoubtedly come along soon
thereafter and say, I need 5 or 6 or 7 or, etc. It's always a tradeoff.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Rommel" wrote in message:
...

1. MS Access has been increased from 1 to 2 gigabyte, so therefore Microsoft
can upgrade or improve its size limit.

2. Other say that Microsoft want us to purchase other programming software
that is why they did not increase much the size limit of the database. But it
is also true that we also paid for MS Access product.

3. Others say that 2 gigabyte is already huge enough and moreover when can
create many ms access database file as back-end and connect to its front-end.
That is why there is no need to ask for more improvement. So if that is true,
Microsoft should have not bothered increasing 1 gigabyte to 2 gigabyte size
limit since we just have to create back-end and front-end.

4. Others say, we should learn other programming languages like SQL so we
can make it as back-end. However, most especially to non-professional or
non-formal graduates of programming course, it is hard for us to do that.
That is why we stick to what we know.

5. Others say, it would be difficult for Microsoft to increase the size
limit because doing so would have Microsoft to restructure the engineering of
ms access. If that is true, how come from version 97, Microsoft had able to
increase it to 2 gigabyte in 2000 version. It is worth to mention that
Microsoft had made a huge change for MS Access 2007. Therefore, Microsoft has
the capability to improve the size limit.

6. SQL maintains one db file that has very huge size limit. Why can't MS
Access also have same capacity while programming does not pertain to DATA
STORAGE ALONE. Programming is more geared towards CODING. This is what I
believe because the data in the data store would be useless if it is not
coded to present what we want to achieve.

This would appear like an appeal to all but I also think that this would
appear as an eye opener information.

We hope that Microsoft will understand that there is no difference if MS
Access Database file will be as same storage capacity as SQL. What matters
most is the ability of the programmer to properly code its program for its
data to be useful.

Rommel wrote:

there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.

I don't have any degree or certificate in computers or anything else
either.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

I don't quite understand this paragraph.

You can download the free version of SQL Server that gives you 4 Gb of
data capacity. Access can use SQL Server, My SQL, Oracle or other
database systems too.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway Chris, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also relevant is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database file.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

Thanks Jeff.

Actually, I want to request to increase the capacity because of the
statement below. Kindly read regarding my problem with SQL Server and SQL
database file.

-----------------------

I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.
Therefore, our knowledge is limited to access programming.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also or MORE relevant is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database file.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

The main purpose that I want a big data storage such as SQL database is the
continuation of records from year to year or even from decade to decades.
Coz there is a probability that one access database file will come to its
limit and the records will no longer have a continuity.

That Sir is the main purpose.



"Rommel" wrote:

Thanks Jeff.

Actually, I want to request to increase the capacity because of the
statement below. Kindly read regarding my problem with SQL Server and SQL
database file.

-----------------------

I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.
Therefore, our knowledge is limited to access programming.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also or MORE relevant is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database file.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

Yes, you need to install a version of SQL server somewhere. The server is
running the database and accepts requests for information.

I have a copy of MS SQL 2000 running on my local computer. My office also has
dedicated computers running MS SQL 2005 and MS SQL 2000 as a service.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Rommel wrote:
I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway Chris, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also relevant is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database file.

If MS Access can connect to SQL database file without the sql server then, I
or we would definitely migrate to SQL database file as back-end.

Thanks for the additional information Rommel, however, you still haven't
answered my question.

You've told me *why* you want it increased, but you haven't told me what new
limit it should be. I need a number to take back to the team, not a
statement of "more."

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Rommel" wrote in message:
...

The main purpose that I want a big data storage such as SQL database is
the
continuation of records from year to year or even from decade to decades.
Coz there is a probability that one access database file will come to its
limit and the records will no longer have a continuity.

That Sir is the main purpose.



"Rommel" wrote:

Thanks Jeff.

Actually, I want to request to increase the capacity because of the
statement below. Kindly read regarding my problem with SQL Server and
SQL
database file.

-----------------------

I am thankful for all your replies. So I see that it was not the real
intention of Microsoft to increase the size of the database.

Anyway, this issue of size limit is not coming from me alone. there
are also other users that I have stated that are not graduates or on the
profession of programming but by self-study gained some knowledge of it.
Therefore, our knowledge is limited to access programming.

Actually I am on the process of learning SQL, and maybe it is not that
difficult to learn. But my other QUESTION that is also or MORE relevant
is:

Do I need to install the sql server in a computer so that MS ACCESS can
connect to the SQL database file?

I asked this question because to where I asked this question or to where
I
researched for answer on this question, I was told that it is needed to
install SQL server so that MS Access can connect to the SQL database
file.

If MS Access can connect to SQL database file without the sql server
then, I
or we would definitely migrate to SQL database file as back-end.