more than 65536 rows

[Guest]

Hi,

I have a database which contains morethan 65536 rows. Pls tell me how to
open the database and pls tell me which application helps me to open more
than 65536 rows.

-Christ.

 

[Earl Kiosterud]

Christopher,

Excel 2007 has a million rows.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Dave Peterson]

Or a different application--like Access????

Hi,

I have a database which contains morethan 65536 rows. Pls tell me how to
open the database and pls tell me which application helps me to open more
than 65536 rows.

-Christ.

 

[Zone]

Just out of curoisity, how many rows are available in Access?

 

[Dave Peterson]

I'm not an Access user, but from what I've read, it's unlimited (well, limited
by physical space on the drive that holds the database).

 

[Bob I]

See Help, Specifications, in 2003, 2 GB for the table so it will depend

Just out of curoisity, how many rows are available in Access?

 

[Pete Stavrakoglou]

Is it 2GB for a table or for the enitre MDB file? I've noticed that Access
2000 can be unstable with MDB files that are over 2GB.

See Help, Specifications, in 2003, 2 GB for the table so it will depend on
the record contents.

 

[Bob I]

2003 states 2GB for both. So you could be limited to a single table if
it is big enough.

 

[Dave Peterson]

MS documents Access 2007's specifications and limits here:
http://office.microsoft.com/en-us/access/HA100307391033.aspx?pid=CH100621861033

 

[Pete Stavrakoglou]

Thanks, that what i thought and have always used the 2GB limit for my Access
files. If able to, I could go much larger than 2GB but I resort instead to
linking tables between MDB files.

 

[Pete_UK]

Hi Dave,

Thanks for this link. Do you know what it means - "Number of Actions
in a Macro - 999"?

Pete

 

[Dave Peterson]

No idea at all.

Hi Dave,

Thanks for this link. Do you know what it means - "Number of Actions
in a Macro - 999"?

Pete

 

[Earl Kiosterud]

Pete,

Access has macros, and it has VBA; they're not the same. The macros are old-style lists of
canned actions (open a query, form, etc.), and that's where the 999 limit is.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

 

[Pete_UK]

Thanks Earl.

Pete

Pete,

Access has macros, and it has VBA; they're not the same. The macros are old-style lists of
canned actions (open a query, form, etc.), and that's where the 999 limit is.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...






- Show quoted text -