Welcome Guest.   Make a donation to an author on the site July 22, 2014, 04:20:42 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2010! Download 24 custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: EXCEL - ACCESS hybrid without limitations  (Read 1595 times)
kalos
Member
**
Posts: 995

View Profile Give some DonationCredits to this forum member
« on: May 22, 2012, 04:24:07 AM »

hello!

EXCEL has many limitations (eg 64,000 of rows max), ACCESS has other limitations, is there a hybrid, supporting VBA or other scripting/macro languages, without limitations?

thanks!
Logged
x16wda
Supporting Member
**
Posts: 426


what am I doing in this handbasket?

see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #1 on: May 22, 2012, 04:50:46 AM »

As info, Excel 2007 allows a million rows and 16k columns.  But everything is going to have some limits.
Logged

vi vi vi - editor of the beast
Ath
Supporting Member
**
Posts: 2,179



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #2 on: May 22, 2012, 05:21:08 AM »

What do you need this application to do?
Logged

kalos
Member
**
Posts: 995

View Profile Give some DonationCredits to this forum member
« Reply #3 on: May 22, 2012, 05:30:28 AM »

What do you need this application to do?

I dont have something specific in mind, I just saw a video and got amazed of the EXCEL abilities, but unfortunately it has some bad limitations
Logged
Ath
Supporting Member
**
Posts: 2,179



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #4 on: May 22, 2012, 05:52:44 AM »

but unfortunately it has some bad limitations
Hm, I've seen this video, but unfortunately my car also has some limitations. Maybe that'll be fixed if I'd buy a newer model?
Logged

kalos
Member
**
Posts: 995

View Profile Give some DonationCredits to this forum member
« Reply #5 on: May 22, 2012, 07:20:15 AM »

but unfortunately it has some bad limitations
Hm, I've seen this video, but unfortunately my car also has some limitations. Maybe that'll be fixed if I'd buy a newer model?

if you gonna create a database, imo you should go with one that you wont stuck you in the middle, and realise the hard way that its limitations prevent you from implementing your goals!
Logged
Shades
Member
**
Posts: 1,606


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #6 on: May 22, 2012, 07:44:28 AM »

@kalos:
Believe me, people/organizations that really require a database, do not consider Access. Too slow and bloated. Microsoft also offers (an Express version of) MS-SQL Server. the free version has a limit between 4 to 8 Gbyte if memory serves me right. Oracle also offers a free versions of their Database software (based either on their 10g or 11g version). Their limit is 4Gbyte.

Both databases are the real deal and waaaaaaay more interesting to play with then Access. Excel can work with both of these databases. Initially a bit more work to get your system running, but it scales a (whole) lot better.

Use PostgreSQL as open source alternative, which has a feature-set similar to Oracle database. As I am not that familiar with MS-SQL I cannot say if the PostgreSQL feature-set is also similar with that product.
Logged
x16wda
Supporting Member
**
Posts: 426


what am I doing in this handbasket?

see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #7 on: May 22, 2012, 12:47:16 PM »

The current MS SQL Server Express has a 10gb per database limit.

As Shades suggests, free and open source alternatives abound.  PostgreSQL, Firebird, SQLite, MySQL are just a few.  They have different strengths and weaknesses but are very capable.
Logged

vi vi vi - editor of the beast
Target
Honorary Member
**
Posts: 1,382



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #8 on: May 22, 2012, 06:25:47 PM »

Rather than asking for a generic solution to an as yet unknown problem, you'd be better served defining the problem before looking for an answer

Are these 'limitations' actually impacting what you want to do? and how - there might be a solution or work around)

It's worth remembering that while they might be 'similar', spreadsheets and databases are actually very different animals, and you wouldn't necessarily want to try and do things in one that you can do in the other.

That said, Excel and Access can and do work well together and share functionality (using VBA)

« Last Edit: May 22, 2012, 08:14:22 PM by Target » Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.031s | Server load: 0.16 ]