Recent content by HowardIsHigh

Hi all, I'd like my adp project to display an explicit warning message when a "save" button has been clicked. For example : "Warning! you are about to record a new customer, do you want to carry on?" (the choice would be "OK" or "cancel") How can I do...

I'll try today, thanks again for this precious explanation! cheers

Hi Bob and thank you very much for your answer. Indeed binding the form directly to the specific table may be the easiest way to do what i want. But, i need the form to distinguish the reading process and the updating/adding process. The reason is that I don't want users to accidently modify a...

Hi all, I work on Access 2000 ADP connected to SQL SERVER 2000. i aim to create a simple form that would be based on a classic "Customers" table (populated by nearly 700 rows). The form must be able to edit a Customer's details, previously choosen from a combobox sorted by customers...

Thk u for your answer, The problem is that i don't have any windows login declared in sql server...i only have the sa account and the one with public+dbreader rights on my database.

Hi all, Something really weird happened in my adp project. The project is a tutorial found on the msdn website (StateU.adp). With the "sa" login i created the database and written several stored procedures. One of these stored proc. is called EnrollmentAdd and has the following code ...

Hi, is there a way to use pessimistic locking in an adp project? I read that only the optimistic could be used.... Cheers.

Hi all! in an ADP project i struggle to manage security. I want to create a new Sql Server login that would only have the right to read data on a specific database, and nothing more. So, in the security section of the project (connected with sa) i created a new login with no server role. I...