Limitation of Access

Is there anybody could tell me: What is the limitation of MS Access?

Best Regard,
Neon520

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

There are different limits depending on what you are referring to. Can
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10293-limitation-of-access.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
you be more specific? For example, Access is limited to 255 columns in
a table or query (At least until the next version is released). Try
going to help and entering Access specifications. That should let you
find the limits for your version.

It depends on what you are trying to do. Is your question related to a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
particular issue or set of issues?

"Neon520" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
news:C1A7F88E-E789-44E9-B51E-630B0C3606B2@microsoft.com...
> Is there anybody could tell me: What is the limitation of MS Access?
>
> Best Regard,
> Neon520

What I am trying to refer to is that Access is a database program, which also
contain some programming language inside. My question was what is the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
limitation of MS Access, regarding as far as its programming limitation?
Cause I wonder if Access could also do the same job that some program sold in
the market, why not just use Access to set up what you need, instead of
spending extra money on some of the programs sold in the market today (which
sometime is really not as effective as what we really need/want)
Thank you,
Neon520


"kerry_ja@yahoo.com" wrote:

> There are different limits depending on what you are referring to. Can
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
> you be more specific? For example, Access is limited to 255 columns in
> a table or query (At least until the next version is released). Try
> going to help and entering Access specifications. That should let you
> find the limits for your version.
>
>

Hi Bruce,
What I am trying to refer to is that Access is a database program, which also
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
contain some programming language inside. My question was what is the
limitation of MS Access, regarding as far as its programming limitation?
Cause I wonder if Access could also do the same job that some program sold in
the market, why not just use Access to set up what you need, instead of
spending extra money on some of the programs sold in the market today (which
sometime is really not as effective as what we really need/want)
Thank you,
Neon520


"BruceM" wrote:

> It depends on what you are trying to do. Is your question related to a
> particular issue or set of issues?
>
> "Neon520" wrote in message
> news:C1A7F88E-E789-44E9-B51E-630B0C3606B2@microsoft.com...
> > Is there anybody could tell me: What is the limitation of MS Access?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
> >
> > Best Regard,
> > Neon520
>
>
>

I'll keep the conversation to this thread. There are off-the-shelf programs
to take care of many situations such as financial management. It is often a
better investment to spend the money rather than take the time to develop
your own application. However, it's not all-or nothing. There are Access
databases that can be used as templates to produce your own database. I
believe some are available on the Microsoft web site. Unlike purchased
programs, these template databases can be customized.

A big consideration with Access is the learning curve. You need to learn
the basics of relational database design, then learn how to implement a
design for your specific situation. You can open Word for the first time
and produce a passable document by the end of the day, but with Access you
may be looking at months before you have something you can use. It depends
on the project.

One important distinction between Access and other applications such as Word
and Excel is that Access is a program development tool, while Word and Excel
are programs in their own right. You can open Word and start typing, but in
Access you need to build a table (or an unbound form, etc.) at the very
least before you can do anything at all. Access is a versatile and powerful
tool, and as such takes some time to learn.

"Neon520" wrote in message
news:ABB5DC30-893B-402E-999E-FDC7471834A2@microsoft.com...
> What I am trying to refer to is that Access is a database program, which
> also
> contain some programming language inside. My question was what is the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
> limitation of MS Access, regarding as far as its programming limitation?
> Cause I wonder if Access could also do the same job that some program sold
> in
> the market, why not just use Access to set up what you need, instead of
> spending extra money on some of the programs sold in the market today
> (which
> sometime is really not as effective as what we really need/want)
> Thank you,
> Neon520
>
>
> "kerry_ja@yahoo.com" wrote:
>
>> There are different limits depending on what you are referring to. Can
>> you be more specific? For example, Access is limited to 255 columns in
>> a table or query (At least until the next version is released). Try
>> going to help and entering Access specifications. That should let you
>> find the limits for your version.
>>
>>

"....some programs sold in the market...." ....??? That's pretty wide open..

Neon520 wrote:
>What I am trying to refer to is that Access is a database program, which also
>contain some programming language inside. My question was what is the
>limitation of MS Access, regarding as far as its programming limitation?
>Cause I wonder if Access could also do the same job that some program sold in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
>the market, why not just use Access to set up what you need, instead of
>spending extra money on some of the programs sold in the market today (which
>sometime is really not as effective as what we really need/want)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
>Thank you,
>Neon520
>
>> There are different limits depending on what you are referring to. Can
>> you be more specific? For example, Access is limited to 255 columns in
>> a table or query (At least until the next version is released). Try
>> going to help and entering Access specifications. That should let you
>> find the limits for your version.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1

>why not just use Access to set up what you need, instead of
> spending extra money on some of the programs sold in the market today


Well, that question is no different then why not build your own furniture.
Why purchase furniture when you can get some wood, and build your own?

The problem is that to get really good a carpentry takes a long time, and a
lot of effort before you reach that tipping point in which it is easier to
purchase something then build it your self.

It likely cost in the millions to create QuickBooks accounting, and you can
get a version for 99 bucks. There is just no way that you can even being to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293
build a product for the same cost and time in ms-access. If you are asking
can you build an accounting system in ms-access...does it have the *ability*
to make such a system? Why yes, you can.

However, the skill level to create such a accounting appcation is quite
large.

You could also think of this whole issue much like music. Do you want to go
down to the music shop, and purchase a record, or do you want to purchase
some musical instruments and MAKE YOUR own music? To make good music takes
years of practice, and writing good software is really the same.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10293

Any good and enjoyable software you now use on your computer was likely
written by someone who had YEARS of experience doing this. I can't come up
with a better example comparison then that of making enjoyable music. It
takes years to be able to make enjoyable music, yet I can start whacking on
a drum..and make some music...but, it will be more like noise!!! (and, I can
assure you that your first software you create will also likely be much like
noise also!!).

So, you can create some really nice applications in ms-access, but you going
to have to spend effort and time to acheive this.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal