Search results for query: *

Good morning, I am looking for some help around SQL server 2005 and how to setup users with different permissions. I was trying to setup up people to have select only access to tables. however I found out that it seems to behave different to setting up users in SQL 2000 any help would be much...

Good morning All I am looking for some guidance I am working on a job that requires the end user to have a access front end (.adp)linked to a SQL server database, however the process requires them to run some DTS packages. what I am looking for is there a simple way to run the DTS package(s) or...

Hi guys, thanks for the help I jus twanted to check with you though that the public role still stays in the users list or permit database roles but I only tick the sp_start_job for that user so thats all they can do Is that correct?

i am looking for some help around running jobs, I am a system admin and have full access to the server to run the jobs we have set up for certain processes, however we want to give other people access to run jobs without making them system admin is there anyway to allow a non system admin to run...

Sorry for the long time to reply. I have tried to use the wizard to create a form to the table but I just end up with a msg saying this Recordset is not updateable any idea how I can change that?

The record source would be whatever the person types into the boxes on the form ..if thats what you mean

So How would I be able to update the table using a form? I basically need a form that can be used to input data into a table

No the form is not based on a query Does that mean I have to create a update query which I then use in the form to input values into the table?

Yea I can see the tables and whats in them and when I am designing the form it looks ok the minute I view the form or save and open it its just the background

Do you mean the front end not connected to SQL prbably because it seems fine on that front. Its purely when I try to view the form after I have created it and saved it

Hi there I am a new user to .adp and am trying to develop a front end that will allow users to input data via a form and update the SQL tables. However I have tried to create the form and in design view everything looks fine but the minute i view the form its black nothing appears but the...