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

Updated AtScale platform streamlines analysis of big data

By improving the machine learning and augmented intelligence capabilities of its platform, AtScale's newest release attempts to ...

ThoughtSpot strategic partnerships help add capabilities

Through its partnership strategy, ThoughtSpot is adding to its capabilities as a BI software vendor the same way others are ...

IBM battling to change perception of Cognos Analytics BI platform

While some see IBM's BI suite as being too complicated and expensive for citizen data scientists, the company is adding updates ...

SearchDataCenter

How machine learning in data centers optimizes operations

Machine learning can help manage your data center more efficiently and address power consumption concerns and hardware ...

3 ways to benefit from open source infrastructure

Using open source infrastructure can reduce operating costs and streamline upgrades, but it's important to weigh the pros and ...

IBM mainframes face competitive pressures inside and out

IBM's mainframe business continues to be under pressure from cloud-based competitors, and perhaps even its own Power server. ...

SearchDataManagement

11 real-time data streaming roadblocks and how to overcome them

Experts detail common challenges that IT teams encounter when deploying and managing real-time data streaming platforms and offer...

Snowflake product VP expounds on data warehouse for the cloud

In this Q&A, Christian Kleinerman, vice president of product development at cloud data warehouse vendor Snowflake, talks about ...

RavenDB Cloud automates database management

RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to ...

SearchAWS

Prepare for the deprecation of Amazon S3 path-style API requests

AWS' users should start building apps with virtual-hosted API requests, if they aren't already. Learn about the S3 path-style ...

Inside Amazon Managed Blockchain components and pricing

Many enterprises can benefit from blockchain technology, but few should build it from scratch. See how Amazon Managed Blockchain ...

How to use Athena to troubleshoot AWS operations issues

Amazon Athena runs analysis against data stored in S3, where AWS admins can find a trove of ops data for troubleshooting and ...

SearchOracle

How Oracle RPA systems can automate business tasks for users

Robotic process automation software can be integrated into Oracle environments to help strengthen business operations by ...

Oracle Analytics Cloud update unifies BI products, pricing

Oracle Analytics Cloud now offers a consistent UI and all-in-one pricing for Oracle's analytics tools. But an on-premises BI ...

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

SearchContentManagement

Investis Digital Connect.ID, a CMS suite, launched

Connect.ID is composed of Connect.ID Platform and Connect.ID Intelligence. It is designed to enable enterprises to build business...

3 ways snackable content creates relevant digital experiences

Businesses can deliver snackable content through contextual commerce, content as a service and digital twinning to create ...

Alfresco cloud migration service moves content off premises

With new cloud migration services, Alfresco promises to move content from IBM, SharePoint, Documentum and other legacy ECM ...

SearchWindowsServer

How to plot out an Office 365 tenant-to-tenant migration

IT pros in organizations on Office 365 that undergo a merger or acquisition will have their work cut out for them to successfully...

Construct a solid Active Directory password policy

Most user authentication still relies on a strong password to keep attackers at bay. Here's how to keep your guard up without ...

Microsoft patches two Windows zero-days in July Patch Tuesday

Microsoft fixed two Windows zero-day flaws as part of the July 2019 Patch Tuesday release, which also saw the remediation of 75 ...

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.

Updated AtScale platform streamlines analysis of big data

ThoughtSpot strategic partnerships help add capabilities

IBM battling to change perception of Cognos Analytics BI platform

How machine learning in data centers optimizes operations

3 ways to benefit from open source infrastructure

IBM mainframes face competitive pressures inside and out

11 real-time data streaming roadblocks and how to overcome them

Snowflake product VP expounds on data warehouse for the cloud

RavenDB Cloud automates database management

Prepare for the deprecation of Amazon S3 path-style API requests

Inside Amazon Managed Blockchain components and pricing

How to use Athena to troubleshoot AWS operations issues

How Oracle RPA systems can automate business tasks for users

Oracle Analytics Cloud update unifies BI products, pricing

How to create Oracle Multitenant database user accounts

Investis Digital Connect.ID, a CMS suite, launched

3 ways snackable content creates relevant digital experiences

Alfresco cloud migration service moves content off premises

How to plot out an Office 365 tenant-to-tenant migration

Construct a solid Active Directory password policy

Microsoft patches two Windows zero-days in July Patch Tuesday

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.