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

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

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

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

Self-service analytics tools hand BI power to business users

Self-service BI software opens the door to wider analytics uses in organizations. This handbook compares top self-service tools ...

Tableau vs. Power BI vs. Qlik: How the BI rivals stack up

Tableau, Power BI and Qlik Sense offer similar self-service BI functionality, consultant Rick Sherman says. But he points to some...

Tibco analytics capabilities get upgrade in Spotfire X

New Tibco AI and natural language processing functions in the soon-to-be-released Spotfire X look to create a simpler and faster ...

SearchDataCenter

Nvidia partnership bolsters VMware live migration capabilities

As part of vSphere 6.7.1, admins can now live migrate virtualized workloads supported by vGPUs. The Nvidia and VMware partnership...

GPU-buffed servers advance Cisco's AI agenda

Cisco's latest UCS servers with Nvidia's GPUs aim to help larger IT shops more quickly run AI and machine learning workloads -- ...

Discovery functions, FIPS compliance increase DCIM security

Data center infrastructure management is one way to track security patches and unauthorized hardware access. There are a few ...

SearchDataManagement

5 trends driving the big data evolution

The speedy evolution of big data technologies is connected to five trends, including practical applications of machine learning ...

Containers key for Hortonworks alliance on big data hybrid

Hortonworks is joining with Red Hat and IBM to work together on a hybrid big data architecture format that will run using ...

Big data tooling rolls with the changing seas of analytics

Hadoop data tooling is expanding. A view holds that Hadoop is moving from alternate data warehousing to a full-fledged big data ...

SearchAWS

Avoid messy breakups with your AWS consulting partner

Maintain control over cloud credentials and permissions to avoid a bad breakup with your AWS consultant, and structure your ...

AWS bare-metal instances target a niche market -- for now

AWS' addition of bare-metal instances runs counter to its heritage but is another example of how the vendor wants to keep users ...

Centralize AWS account management with native SSO tool

Some third-party tools have longer track records, but AWS SSO offers an appealing alternative as a native service to handle cloud...

SearchOracle

Breaking down AI-infused Oracle Autonomous Cloud services

Oracle offers a variety of AI-infused cloud services that it says will automate common administrative and operational tasks for ...

Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and ...

The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the ...

SearchContentManagement

New rules for WCM tools enhance the search experience

WCM used to mean platforms for webpages viewed on desktops. Today, it's morphing into digital experiences, and it taps AI as well...

AI-assisted image and video search is next content frontier

You can search text, but it's harder to catalog images and video. New tools are automating those processes at the enterprise ...

Box AI strategy looks to give users AI development tools

Box wants to be the hub of its enterprise users' software and AI content ecosystems with integrations and partnerships ranging ...

SearchWindowsServer

Mulling a public folders migration? Weigh your options

Should you stay or should you migrate? Microsoft offers a bevy of alternatives to public folders. This tip breaks down each ...

Explore the Cubic congestion control provider for Windows

Microsoft made Cubic the default congestion control provider for Windows 10 and plans to do the same for Windows Server 2019. ...

Microsoft shuts down zero-day exploit on September Patch Tuesday

Administrators should prioritize patching systems affected by four public disclosures resolved by the Patch Tuesday 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.

Self-service analytics tools hand BI power to business users

Tableau vs. Power BI vs. Qlik: How the BI rivals stack up

Tibco analytics capabilities get upgrade in Spotfire X

Nvidia partnership bolsters VMware live migration capabilities

GPU-buffed servers advance Cisco's AI agenda

Discovery functions, FIPS compliance increase DCIM security

5 trends driving the big data evolution

Containers key for Hortonworks alliance on big data hybrid

Big data tooling rolls with the changing seas of analytics

Avoid messy breakups with your AWS consulting partner

AWS bare-metal instances target a niche market -- for now

Centralize AWS account management with native SSO tool

Breaking down AI-infused Oracle Autonomous Cloud services

Oracle Autonomous Database Cloud gets transaction processing

The future of SPARC/Solaris is cloudy -- in multiple ways

New rules for WCM tools enhance the search experience

AI-assisted image and video search is next content frontier

Box AI strategy looks to give users AI development tools

Mulling a public folders migration? Weigh your options

Explore the Cubic congestion control provider for Windows

Microsoft shuts down zero-day exploit on September 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.