Main Area and Open Discussion > General Software Discussion

EXCEL - ACCESS hybrid without limitations

<< < (2/2)

kalos:
but unfortunately it has some bad limitations
-kalos (May 22, 2012, 05:30 AM)
--- End quote ---
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?
-Ath (May 22, 2012, 05:52 AM)
--- End quote ---

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:
@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:
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.

Target:
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)

Navigation

[0] Message Index

[*] Previous page