How to use Access Database as a complex database

Asked By nakoba 0 points N/A Posted on - 10/01/2011

Could someone please explain to me how I can use Access as a complex database and can it support complex datatypes? What are the other databases that can be used to complement Access and get a high quality complex database that can deliver on a large scale organization and yet complex data type?

• Status: Open
• Question Views: 853
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Alber grower 0 points N/A #84763

How to use Access Database as a complex database

I think what you need is a much larger scale database and not the Microsoft Access programs because it is more easy to use but don't have those complexity that you need so I suggest that you move from Microsoft Access to SQL Server or Oracle. These are the programs that will provide you with the complexity that you need and also it has more data types than the Access and there is what you cal T-SQL that only this programs can support.

If you have so much data in your company, it will be hard to sort and store in groups. So its much better to create a system which is more understandable to use.

About Alber grower

Questions
0

Answers
370

Best Answers
106

• Vote Up 0 Vote Down

• Posted on - 10/03/2011
• Question Category: MS Access