answersLogoWhite

0


Best Answer

Hi, This depends on the number of users who are going to use the database simulteneously. If the total number of users lest 25 and from only one location MS Access should be enough. If there are going to more than 25 user & accross different location, You require MS SQL . Hope this helps

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Should you use SQL or Microsoft Access to run enterprise databases?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What should I get sql training for?

SQL training is needed if you are going to be working with Microsoft SQL Databases


Should Microsoft consider Linux a threat?

Microsoft should and does consider Linux a threat in the enterprise desktop and server market. They are also in danger of losing market share in netbooks and ultralight laptops.


Which section of a security policy is used to specify that only authorized individuals should have access to enterprise data?

The access control section of a security policy is typically used to specify that only authorized individuals should have access to enterprise data. This section outlines the mechanisms and rules for granting and revoking access rights to data, ensuring that sensitive information is only accessed by approved personnel.


How should an e-business enterprise store access and distribute data and information about their internal operations and external environment?

hooyadiin usheeega eeyahay


Should individuals and organizations with access to the databases be identified to the patient?

Yes. All individuals and organizations with some form of access to the computerized data bases, and the level of access permitted, should be specifically identified in advance. Full disclosure of this information to the patients is necessary in obtaining informed consent to treatment. Patient data should be assigned a security level appropriate for the data's degree of sensitivity, which should be used to control who has access to the information.


How can you access the databases of nso which contains the names of persons?

Accessing the databases of the National Statistical Office (NSO) should be done through official channels and in compliance with relevant laws and regulations. Generally, authorized individuals, such as government officials and researchers, can gain access to NSO databases by submitting formal requests, following proper procedures, and demonstrating a legitimate need with appropriate justifications. The specific process and requirements may vary depending on the country and the purpose of accessing the data.


Do i need a Microsoft Access license if i want to access a Access-DB through a own written C plus plus -Programm?

No. You need an ODBC, OLE, or DAO driver that understand MS Access. That should come with the C++ run-time, or with the most recent version of DAO for Windows.


What should you learn to query a data base?

To query databases, one should learn the Structured Query Language (SQL). While most versions of databases havedifferentsyntaxes (usually by way of adding "extensions" to the SQL standard), learning SQL will provide most of what one would need to know to learn how to use a specific database product, such as MySQL, Access (T-SQL), and Oracle (PL/SQL).


What is a good sentence with enterprise in it?

enterprise = imagination/resourcefulness; The school showed enterprise in its attempt to attract pupils. enterprise = business/company/firm: A fan club should be a service rather than a profit making enterprise. enterprise = undertaking/endeavor: Opening a new cafe in town is a risky enterprise.


If a security warning appears when you open a database which button should you click to display the Microsoft Office Security options dialog box in access?

Enable Content


What is Microsoft Windows 7?

Windows 7 is the latest Microsoft operating system (OS). Other examples of Microsoft OSs are Windows XP, Vista, and Server 2008. Windows 7 should not be confused with Microsoft Office 2007, which is no more than a group of programs such as Word, Excel, Power Point, and Access, among others. The operating system Windows 7 is often confused with the Microsoft Office 2007 suite.


Should you give my computer id out. A MICROSOFT engineer rang wanting to gain access to my pc. i did not request this.he said he was calling from marble arch tower- london.?

No, there's no reason a Microsoft employee would ever call you to get this information. If you were having a problem and called them, they might ask you to allow them to access your PC remotely, but they wouldn't call you out of the blue to do this.