Recent content by DalynSoft

Wow, leave the group for a night and replies abound. Thanks everyone for your time. David's suggestion was the one that worked.

I am using this code to set the recordset for a combo box: Set rstTemp = basRunDataObject("dbo.spcboNodeSubPortPartnerPort " & Forms!frmAANodeDetail!sfrNodeSub.Form!txtID & ",0", adCmdText) Set Me!cboPartnerPortIDNo.Recordset = rstTemp rstTemp.Close Set rstTemp = Nothing The...

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...