I might not have expressed it correctly.... The problem is to merge the information existing on the DB (where one of the fields is an [Appointment date], maybe in 3...

Thanks for the answer and the screenshot, SSCcertifiable. On the contradiction, basically what I meant is that the merge field has the wrong format, but the view shows the right...

Thanks toddasd, just one more question.

I'll assume I get the connection thing, but what isn't clear to me is, again, the parameters issue.

1/ First you'll need to iterate the...

It's a security issue. The way the SQL DB is built is not possible to simply link tables. The whole 'project' is split into 2 databases, one is accessible...

Thanks SSC-Enthusiastic, but I forgot to say there's no ADP project file. That complicates things a bit.

A second point worth considering is that the SP procedure called doesn't return any...

Thanks GSquared but I think there's a lot more going on. To summarise it, these are some of the usual scenarios and related questions on the UPDATE ISSUE I've posted:

1)...

To answer your questions:

• Architecture: I don't have the skills (or the equipment) to use Sharepoints or webservers. There will be just an Access front-end + a SQL 2005 back-end.

•...

Thanks so much. Just a couple of questions on this:

1. If you do Right click>Script view as>Create to..>New window, as suggested, you get a window with fuzzy code that starts...

Thanks both, I'll check that. Could also be the source of the query the cause of not being able to edit the form??

The source in this case is a SQL...

Thanks Lowell and Matt, both seem good solutions.

Obviously I would have preferred a synonym just for the database name, because if it has to match just a single object...

Are you sure? The problem seemed easy enough: we have 10 table value functions (multistated) with many hard-coded references to 2 databases. It's as easy as replacing the names of...

Hi Chris,

@eventsList is a TABLE type with several fields. It is defined as the RETURNS value of a function (all this comes from a function. The final goal is to...

I can't run the instruction PRINT (@SQL) on a separate query. The reason for this is that I can't reproduce (or don't know how) the values of the @eventsList variable.

Hi guys,

Thanks to all, but I'm still struggling to see what the problem is (and that would really help). Structures like this:

set @sql=<whatever>

exec(@sql)

usually work in dynamic SQL (I...

BTW, the error is 443: 'Invalid use of side-effecting or time-dependent operator in the EXEC command'