Excel Front End for SQL Server

  • Thread starter Thread starter TheVisionThing
  • Start date Start date
T

TheVisionThing

I'm using Excel as a front end for a local copy of SQL Server 2000 on my
WinXP machine.

I'm having no problem using SQL to retrieve records from my SQL Server.
However I cannot delete records in my SQL Server from Excel. I think it's a
permissions issue, but I'm not sure how to alter the permissions or which
permissions to alter.

Thanks,
Wayne C.
 
Hi Wayne,
I'm having no problem using SQL to retrieve records from my SQL Server.
However I cannot delete records in my SQL Server from Excel. I think it's a
permissions issue, but I'm not sure how to alter the permissions or which
permissions to alter.
Click to expand...

What error messages do you get when you try?

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev
 
Solved my problem. Just needed to change permissions for my account in the
database.

Thanks,
Wayne C.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel as front end and SQL Server as back end 0
Excel 2007 to SQL Server??? 1
import Excel worksheet to SQL Server table 7
Push data from Excel to SQL Server 2
VBA Excel data to SQL Sever table 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
recordset vs collection 2
Using Excel as Interface for big SQL Server Tables?! 1

Back
Top