I tried to install SQLVer in a datatabase with an account in the dbo group (i.e. I'm the owner of that database). Here's what I got:

.Net SqlClient Data Provider: Msg...

This is because Excel uses MSQuery which needs to access to several system objects.

1. User must have connection rights (login) to the SQL Server or be member of an A.D. group that has connection rights to the SQL Server.

2. User must have the...

You're welcome!

Here's a solution you can use provided that:

1. MS Access is installed on the SQL Server machine.

2. You can create a text file and write into it from your SQL...

Using: Set cmd = cmd.Execute there does not make sense as cmd is declared but not instanciated yet. Use:

Set cmd = New ADODB.Command

instead.

As far as I know, the limit is 64K characters. If it's not enough, you'll need to call a stored procedure with a pass-through query, which should be shorter.

jdasilva (5/15/2014)

---

This is starting to get more complex... I am not the only one using the front end, which would mean I would have to turn this on for...

In your sample, you're using DAO because Application.DBEngine.Workspaces(0).Databases(0) represents a DAO object. You can also use CurrentDb which is a shortcut to the same object.

A very good way to...

You're welcome!

For editing (changing) a stored procedure, you can:

1. Reload the file you saved when creating it (if you did so), then change the instruction "CREATE PROCEDURE" to "ALTER PROCEDURE".

2. You...

When you create a stored procedure with SSMS you:

1. Click on the "New Query" button (or select "New query with the current connection" in the File menu, or press CTRL+N).

2....

J Livingston SQL (5/9/2014)

---

just to refresh my memory on Access... is it Form.RecordSource or Form.RecordSet that can be set in VBA modules for unbound forms.....would like to clarify my...

Sean Lange (5/9/2014)

---

Makes me very happy that I don't use Access for anything at all...and haven't in a LONG time. Even when I did a few things with Access I...