Recent content by DalynSoft

Yes that works (the removal of the asterisks made the difference). I decided to use VBA code in the end for greater flexibility. Thanks everyone for your feedback. Much appreciated.

Thanks Duane. I will defer to practical over academic. :) (Meaning that I used VBA code to validate rather than the validation property)

I have a text field that should only allow either numbers or the character "+" or the character "-". Eg valid entries are: 12345 97 + - Invalid entries are: +45 -67 12+ A87 I have tried this in the validation rule: Is Not Null And (Like "*[0-9]*" Or Like "+" Or Like "-") but it allows -67...

Thanks - that highlighted that my API key wasn't set up for this service.

I have downloaded your file and put my API key in the Public Const GOOGLE_MAPS_API_KEY declaration. I have left the country as nz. I don't get any results when I enter an address in the search field. Do you have an example of an address that works that I can check?

Thanks for the explanation. And yes, the only way to protect anything is to write it on a piece of paper, burn it, then develop dementia so you will never remember it again :)

Incidentally, the original question was more concerned with protecting intellectual property rather than not trusting SA's to play around with the code.

Thanks everyone. I tried to attach a link to a web page which pretty much sums it up but kept getting an error. Search for learn.microsoft.com protecting-your-sql-server-intellectual-property

Good point @Josef P. I also checked WITH ENCRYPTION but it seems that there are unecryption tools easily available so that is not much help anyway. So basically if I want to protect the code in the Stored Procedures I should not use SQL Server?

There has already been a lot of discussion around this. Do you mean from the SQL Instance, or just the database? If from just the database would they not be able to add an admin user if they have admin rights for the server instance?

But does it replace the sa user if it has been removed from the database?

Thanks everyone for your input. My scenario is more "Microsoft product" rather than software specifically developed for a client (and definitely not military grade requirements :)). We are concerned that the clients may "sell" the application to others. In preventing the stored procedures from...

Hi Listers, I have an SQL database which will be installed on a client’s server. Is there a simple way to prevent the client’s server system administrators from accessing the database (specifically changing security settings or accessing the stored procedures and functions) but still allow me...

I have a number of forms that call SQL Server procedures and then return a resulting recordset. I have a pop up form that explains to the user what is happening. If the process takes some time (and it may be only a few seconds) the heading in the pop up form shows "(Not Responding)" after my...

It also crashed for me when I clicked the get Current Location button. I am running it on a Desktop and I note on your site that it requires a geosensor to work so that might be a problem in my case.