topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 4:37 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: EXCEL - ACCESS hybrid without limitations  (Read 4793 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,820
    • View Profile
    • Donate to Member
EXCEL - ACCESS hybrid without limitations
« on: May 22, 2012, 04:24 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!

x16wda

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 888
  • what am I doing in this handbasket?
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #1 on: May 22, 2012, 04:50 AM »
As info, Excel 2007 allows a million rows and 16k columns.  But everything is going to have some limits.
vi vi vi - editor of the beast

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,610
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #2 on: May 22, 2012, 05:21 AM »
What do you need this application to do?

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,820
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #3 on: May 22, 2012, 05:30 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

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,610
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #4 on: May 22, 2012, 05:52 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?

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,820
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #5 on: May 22, 2012, 07:20 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!

Shades

  • Member
  • Joined in 2006
  • **
  • Posts: 2,922
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #6 on: May 22, 2012, 07:44 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.

x16wda

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 888
  • what am I doing in this handbasket?
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #7 on: May 22, 2012, 12:47 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.
vi vi vi - editor of the beast

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
Re: EXCEL - ACCESS hybrid without limitations
« Reply #8 on: May 22, 2012, 06:25 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 PM by Target »