Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Front End for SQL Server
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Front End for SQL Server
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. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Front End for SQL Server
Solved my problem. Just needed to change permissions for my account in the
database. Thanks, Wayne C. "Stephen Bullen" wrote in message ... 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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
excel front end to access | Excel Discussion (Misc queries) | |||
Bringing Excel to the front | Excel Programming |