will access support 550,000 lines of data?

D

DLG

According to the Database Specifications section of the Access 2003 Help
file you can have a
Table size of 2 gigabyte minus the space needed for the system
objects.

The number of rows in a table is not what is important, it depends on the
size of the fields in the rows and how much data each field contains.
So depending on what is in each line of data you may be able to have well
over this many lines.
 
M

Matt

Access restriction is based mainly on size and not # of records. It can hold
about 2 GB of data. With that said - 550,000 should not be a problem at all
– I have database that have millions of records.
 
D

dbahooker

screw MDB for that many records; use SQL Server or MSDE with Access
Data Projects
 
L

Larry Linson

screw MDB for that many records; use
SQL Server or MSDE with Access
Data Projects
Click to expand...

CAVEAT: The separate SQL Server product costs a great deal more than Access
and has a per-user charge, but Access can successfully be used as a front
end to SQL Server. MSDE is a size- and user-limited free version of SQL
Server, but has the same size limitations as Access MDB. There will be a
learning curve associated with converting to ADP, and the users will have to
be given full permissions on the SQL server or MSDE tables. Knowledgeable
Microsoft insiders no longer recommend ADP as the preferred Access client
for MS SQL Server.

A post of the type to which this is a response is unhelpful, misleading if
you accept it without further investigation, and, if not just "trolling", is
certainly little better than that.

Larry Linson
Microsoft Access MVP
 
T

Thomas Kroljic

<<Knowledgeable
Microsoft insiders no longer recommend ADP as the preferred Access client
for MS SQL Server.>>

Larry,
If I decided to move up to a stronger database then the mdb database
from Access, what would you recommend if I still wanted to use Access as the
frontend product? Or should I move to another product such as VB if I
decided to move to either MSDE or MS SQL?

Thank you,
Thomas J. Kroljic
 
T

Thomas Kroljic

Doug,
(getting completely off topic from the original poster/posting...)
One of the reasons I was looking VB as a possible frontend, even to a
JET database, was because I would like to incorporate features such as "drag
& drop" or better "grid" functionality into my application. I would like a
more "commercial" look and feel to the applications I develop. Any thoughts
on this? Are there good 3rd party software products that will enhance my
Access application?

Thank you,
Thomas J. Kroljic
 
D

dbahooker

knowledgeable microsoft insiders?

you tell those wimps to make a public friggin announcement then and
take your gossip and shove it.

ADP is the best development platform in the world. ASP is a rockstar,
but ADP kicks' Crystals' ass.

You tell that little msWimp to come and tell me that to my fucking
face.. it's real easy to make rumors like that.

Well I am here to fucking tell you that MDB is DEAD and it isn't a
reliable way to develop software. ADP runs circles around MDB. ADP is
stable, reliable-- I love ADP more than anything.

you know the difference?

One uses SQL Server and ADO; and the other is a piece of shit language
that is ten years out of date.

MDB isn't RELIABLE enough to do a damn thing right

ADP is a way of life.
 
D

dbahooker

Larry

and again-- I am sorry that you are too much of a wimp to know anything
about SQL Server.

your defamy of my favorite product is not acceptable. I ask you,
Larry-- to go and suck an egg and rain on someone else's parade.

ADP is the best solution ANYWHERE for ANYTHING.

ADP has a lot of bugs. But MDB has about 10 times as many bugs.

ADP queries don't just 'crap out' when they get confused.

That is why I use them; I am sick and tired of MDB queries just
crapping out and saying 'oh, oops.. that is too complex'

it happens to me once a week; and I fucking hate MDB more than I hate
country music.

Microsoft salvaged you all from being a $15/hour developer-- he gave
you the option to build REAL SOLUTIONS THAT ROCK.

i just am sick and friggin tired of copying queries between databases;
it just makes things a lot simpler to build them in one place and
everyone works from one backend. And it is a backend that allows you
to update millions of records by dozens or hundreds of users.

MDB doesn't do that consistently.

I ask you Larry-- spend a week with ADP; and email me if you have any
questionsp.. friggin newbie

[email protected]
 
D

Douglas J. Steele

Depending what you're doing, you can simulate drag-and-drop in Access. I
wrote about this in the January and Febuary issues of Pinnacle Publication's
"Smart Access". You can download the columns (and sample databases) for free
at http://www.accessmvp.com/DJSteele/SmartAccess.html

There are 3rd party controls that you can use with Access. I'm familiar with
TList, from Bennet-Tec http://www.bennet-tec.com/products.htm but Tony Toews
lists others at http://www.granite.ab.ca/access/thirdparty.htm

You have to be careful using 3rd party controls. First of all, not all of
the them will work with Access: you need to check with the vendor. (The
details are explained in http://support.microsoft.com/?kbid=202104. Don't
worry that the article only mentions Access 2000: it applies to all
versions). Secondly, any time you add additional references to your
application, you run the risk of the References collection breaking. Check
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html for more
details.
 
T

Thomas Kroljic

Doug,
Thanks for the information. I'll review each of the links you included
in your post.
I do appreciate the advice.

Thank you,
Thomas J. Kroljic
 
Top