Hi frank,

How about using the application role to give your application permissions and lock down users own security privilages in your...

Hi,

The view was created like this:

CREATE VIEW dbo.VIEWTesting

WITH VIEW_METADATA

AS

SELECT *

FROM dbo.TBL_Testing

Thanks

Chris

Thanks Guys,

Adding the alias solved the problem.

Cheers

Chris

Hi Frank,

Links,links,links! get as many as you can all over the web. If it's a technical site like, say,.. SQL server,...

Hi Guys,

This site is always my first port of call 🙂 It could do with a section just for Access frontend apps...

Hi Mark,

Thanks for your help. I prefer your way of writting triggers without the set commands, I will write all my triggers...

Hi Mark,

Thanks for replying. As far as I know the view should meet the requirements, but I will have a good hard...

Hi Frank,

Unrelated issues with the front-end mean that it will be quite a while before I have an end-to-end solution, but...

Hi Frank

Thanks for that. Just trying to sound out how other people are doing this. It looks like we have a similar need. I have been able to get...

On commenting in general(not just TSQL);

I think well written, self descriptive code is the most important thing. Every effort should be made to get this right, indents, readable variable names...

I have found the foxpro drivers to be a real pain especialy with date fields.

Question: Is the code you posted the code you originally typed in or has it been...

Can't remember if I have seen this with Access, but I have seen it with Foxpro datatype and the way round it was to change the destination column type in...

Methodologies deal with both the diagramming conventions and the process by which you create your app. It's like a cookbook to what and how to go about writting software. ...

The SQL Agent is now staying up(or comming back up), but all the jobs fail.

Thanks, the mail profile looks OK, we are only using the email when the job completes without error. I have now set the SQL agent to start up again automatically...