connection using udl

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J?rg Werner - 25 Feb 2004 12:15 GMT

I'm using ACC2000 and SQL Server 2000.
The main form uses three subforms. .
In the open event of the main form I set the current connection.

CurrentProject.OpenConnection ConnectionString

After that I want to assign the recordsources for the subforms.

frmSub1.Form.RecordSource = "sp_GetSomeData"

But it does't work. I always get the error message:
2101: the setting you entered isn't valid for this property

What's wrong?

Thanks

J?rg

Reply to this Message

Sylvain Lafontaine - 27 Feb 2004 05:41 GMT

There is numerous bug with Access 2000 ADP. Upgrading to Acc2002 or 2003
will help you a lot.

From now, you can try adding the prefixe "dbo" as in: .RecordSource =
"dbo.sp_GetSomeData". Trying with EXEC or call may also help:
.RecordSource = "EXEC dbo.sp_GetSomeData"

Also, you shouldn't prefixe the names of your stored procedures with "sp_" .
This prefixe is reserved for system stored procedures and cause SQL Serve to
change the way it compiles theses stored procedures. Using it for your own
stored procedures can lead to some serious near-intractable bugs and a
diminution of performance. See the BOL for more information.

S. L.

> I'm using ACC2000 and SQL Server 2000.
> The main form uses three subforms. .
[quoted text clipped - 14 lines]
>
> J?rg

Reply to this Message

alig?k - 28 Feb 2004 14:45 GMT

> I'm using ACC2000 and SQL Server 2000.
> The main form uses three subforms. .
[quoted text clipped - 14 lines]
>
> J?rg

Reply to this Message