Permissions problem connecting to SQL Server with Excel and VBA

Connecting to SQL Server with Excel and VBA could be a permissions issue and the user should first ensure the login is mapped to a valid database.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

I am attempting to connect to SQL Server with Excel 2003 and Visual Basic for Applications (VBA). The connection works (using Data Access Objects) for reading data but not for adding tables and fields or writing data. Please advise me on how to proceed.

This sounds like a permissions issue. Make sure the SQL Server login is mapped to a valid database user with the necessary permissions. If the user should have access to all tables in the database, the easiest solution may be to give the user access to the db_datareader and db_datawriter fixed database roles. The datareader role allows the user to read from all tables in the database. The datawriter role allows the user to create new tables, and manipulate data in any existing table in the database.

This was last published in May 2006

Dig Deeper on SQL Server Interoperability

All
News
Get Started
Evaluate
Manage
Problem Solve

CORBA (Common Object Request Broker Architecture)

SQL Server 2014 features enable hybrid cloud scenarios

Related Q&A from Adam Machanic

Stored procedure concurrency problems in SQL Server 2005

Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ... Continue Reading

Upgrading SQL Servers

Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ... Continue Reading

SQL vs. T-SQL

SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

ThoughtSpot SearchIQ enables voice analytics

Part of the ThoughtSpot 5 update, which adds a number of upgrades to the BI platform, SearchIQ allows users to take advantage of ...

At Logi Analytics and Tableau, beta feedback drives creation

Constructive commentary from software beta testing can help work out bugs and bring about new ideas, which BI vendors Logi ...

6 big data visualization project ideas and tools

These data visualization project examples and tools illustrate how enterprises are expanding the use of "data viz" tools to get a...

SearchDataCenter

RHEL 8 beta looks to speed development of cloud-based apps

Red Hat Enterprise Linux 8.0 updates the software's DevOps capabilities with Application Streams, and boosts its appeal to both ...

Evaluate Linux server distros for your data center

Linux is known for its reliability and flexibility in the data center. To select the proper distribution for your servers, you'll...

In IBM deal's wake, Red Hat RHEL 7.6 targets hybrid cloud

After its acquisition by IBM, Red Hat wasted little time unveiling the next version of its flagship product, RHEL 7.6, which ...

SearchDataManagement

How data duplication in healthcare is diagnosed

Electronic health record systems have helped reduce duplicate patient data in hospitals -- but they haven't cured the problem. ...

IBM-Red Hat deal highlights changes due in data processing

The IBM acquisition of Red Hat marks a watershed in computer architecture. The duo says it can rebuild data applications in new ...

How to build a master data index: Static vs. dynamic indexing

Expert David Loshin explores the differences between static and dynamic indexing in master data management systems, and which ...

SearchAWS

EC2 Fleet Auto Scaling targets diverse workloads

Autoscaling is table stakes for public cloud providers. Now AWS customers can apply it to their EC2 Fleet instance groups for ...

How CloudFormation Macros stack up against other IaC tools

Developers can use an updated CloudFormation feature to manage and deploy IaC templates with Lambda. However, other native and ...

AWS, Oracle trash talk spotlights cloud database migration

Amazon says its consumer division has dumped Oracle's database platform, and the company will offload most workloads by year's ...

SearchOracle

DataScience.com set to drive Oracle cloud analytics efforts

Oracle's cloud strategy includes machine learning jobs that differ from the usual SQL analytics. The company is turning to its ...

Oracle Cloud IaaS security gets superhero status from Ellison

TechTarget editors discuss security updates to Oracle Cloud Infrastructure and company leader Larry Ellison's vivid depiction of ...

What the 3 versions of Oracle Cloud at Customer offer users

Oracle's Cloud at Customer service lets users run its cloud technologies in their data centers. Here's what users get in the ...

SearchContentManagement

At Acquia Engage, CTO talks of open source WCM, Red Hat buy

Drupal author and Acquia founder Dries Buytaert talks about how the web content management system written for fun is morphing ...

Five ways ECM software can benefit your organization

Think your business needs content management tools? Here are five use cases illustrating how ECM software addresses common ...

SharePoint Online web parts modernize corporate intranet

Microsoft unveils new features that will allow users to access Office 365, social media, news feeds and PowerApps all within one ...

SearchWindowsServer

Hyper-convergence forms core of Windows Server 2019 features

The latest server OS release from Microsoft upgrades many of its software-defined features to make it easier to use a hybrid ...

Understanding what Azure AD federation really means

A company that adopts SaaS apps to get work done can ease the transition by implementing a single sign-on method. Learn how to ...

Windows zero-day fix highlights November Patch Tuesday

In addition to the November Patch Tuesday updates, Microsoft offered assistance to combat a new side-channel attack and ...

SQL Server 2014 features enable hybrid cloud scenarios

Scale out with Windows Azure SQL Database

Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Utilize SSAS for data predictions and classification using Excel

Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Data integration woes here to stay

CORBA (Common Object Request Broker Architecture)

SQL Server 2014 features enable hybrid cloud scenarios

Tools and technique to move SQL Server data to Oracle

SQL Server 2014 features enable hybrid cloud scenarios

Scale out with Windows Azure SQL Database

Utilize SSAS for data predictions and classification using Excel

Microsoft Access 2007 integration with SQL Server

SSIS package to filter false records

Please create a username to comment.

ThoughtSpot SearchIQ enables voice analytics

At Logi Analytics and Tableau, beta feedback drives creation

6 big data visualization project ideas and tools

RHEL 8 beta looks to speed development of cloud-based apps

Evaluate Linux server distros for your data center

In IBM deal's wake, Red Hat RHEL 7.6 targets hybrid cloud

How data duplication in healthcare is diagnosed

IBM-Red Hat deal highlights changes due in data processing

How to build a master data index: Static vs. dynamic indexing

EC2 Fleet Auto Scaling targets diverse workloads

How CloudFormation Macros stack up against other IaC tools

AWS, Oracle trash talk spotlights cloud database migration

DataScience.com set to drive Oracle cloud analytics efforts

Oracle Cloud IaaS security gets superhero status from Ellison

What the 3 versions of Oracle Cloud at Customer offer users

At Acquia Engage, CTO talks of open source WCM, Red Hat buy

Five ways ECM software can benefit your organization

SharePoint Online web parts modernize corporate intranet

Hyper-convergence forms core of Windows Server 2019 features

Understanding what Azure AD federation really means

Windows zero-day fix highlights November Patch Tuesday

Related Resources

Dig Deeper on SQL Server Interoperability

Related Q&A from Adam Machanic

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.