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.

Adam Machanic
Published: 16 May 2006

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.

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

Qlik exec discusses AI and its role in the future of BI

The next major trend in business intelligence will be the increasing impact of augmented intelligence and machine learning, ...

SAP BI platform stays strong due to cloud-based architecture

A cloud-native BI platform along with domain-specific applications that can be embedded to serve the needs of various industries ...

Tableau 2019.3 highlighted by enhanced AI, new data catalog

Tableau released its third-quarter update Wednesday, featuring Explain Data, an enhanced augmented intelligence tool, and Tableau...

SearchDataCenter

New Dell EPYC servers embrace AMD Rome chips

Dell EMC goes from Naples to Rome with a new line of EPYC servers, including Ready Solutions for high-performance computing and ...

Can next-gen SIEM help cybersecurity initiatives?

More organizations are using SIEM, AI and cloud technology to minimize security breaches. Though despite interest, this ...

IBM z15 mainframe secures data across multi-cloud environments

IBM unveiled the latest in its line of mainframes capable of processing 1 trillion web transactions a day. The IBM z15 ...

SearchDataManagement

Dremio Data Lake Engine 4.0 accelerates query performance

Dremio issues a new platform update, defining itself as data lake engine technology that looks to help users connect and query ...

Weighing the use of third-party database administration tools

Database expert Chris Foot details the key reasons why DBAs should consider using third-party database administration to fill ...

InfluxDB Cloud 2.0 expands open source time series database

While the core open source InfluxDB 2.0 project is still in alpha, InfluxData has advanced its cloud service to support new ...

SearchAWS

Review latest investments to AWS' machine learning platform

Improved deep learning capabilities lead this machine learning roundup. Learn how AWS is targeting both machine-learning-savvy ...

Set AWS security automation in motion with these practices

Enterprises need to continuously improve their cloud security posture. Catch up on the latest expert advice on AWS security tools...

New details emerge about AWS Outposts as launch nears

AWS Outposts will ship later this year. In advance of that launch, AWS has given customers a sense of what they can expect from ...

SearchOracle

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

Oracle cloud ambitions follow decades of transition

The Oracle cloud strategy continues to evolve, with fresh emphasis placed on how its flagship database can help customers in the ...

SearchContentManagement

Nintex launches no-code workflow automation tool

Nintex has launched a no-code workflow automation tool, Workflow Generator, in an effort to bridge the gap between IT departments...

Cohesion is latest Acquia acquisition

While Acquia would not provide specifics of the deal, the decision behind the acquisition of Cohesion was the chance to bring ...

3 things to learn before considering blockchain integration

Paul Swider, CTO at RealActivity LLC, discusses how to use blockchain technology to increase the security and usefulness of ...

SearchWindowsServer

How to keep VM sprawl in check

Virtualization improves hardware use, but the pendulum can swing the other way and result in an overallocation of resources. ...

Lessons learned from PowerShell Summit 2019

Want to refine your automation abilities? Learn about some of the insights gleaned from the advanced sessions held at the ...

September Patch Tuesday addresses 2 Windows zero-days

Microsoft issues fixes for 79 unique vulnerabilities, including three public disclosures, as part of its monthly security updates.

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.

Qlik exec discusses AI and its role in the future of BI

SAP BI platform stays strong due to cloud-based architecture

Tableau 2019.3 highlighted by enhanced AI, new data catalog

New Dell EPYC servers embrace AMD Rome chips

Can next-gen SIEM help cybersecurity initiatives?

IBM z15 mainframe secures data across multi-cloud environments

Dremio Data Lake Engine 4.0 accelerates query performance

Weighing the use of third-party database administration tools

InfluxDB Cloud 2.0 expands open source time series database

Review latest investments to AWS' machine learning platform

Set AWS security automation in motion with these practices

New details emerge about AWS Outposts as launch nears

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

The roots of Oracle's cloud evolution: A 20-year review

Oracle cloud ambitions follow decades of transition

Nintex launches no-code workflow automation tool

Cohesion is latest Acquia acquisition

3 things to learn before considering blockchain integration

How to keep VM sprawl in check

Lessons learned from PowerShell Summit 2019

September Patch Tuesday addresses 2 Windows zero-days

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.