RAG2007
Last Activity: Apr 8 '08, 06:15 PM
Joined: Oct 23 '07
Location:
-
Met with my DBA. They wouldn't give me permissions to add users or create roles, but suggested that in the front end I control that using windows system functions to determine who the user is. Now I'm searching for the vba code that will enable me to do that, but haven't found anything yet. Anyone know how to access that? -
OK, I found a workaround. On my main form I added an unbound field to hold my ID, so when you select the first record in the subform it's ID get's dumped in there. When the new subfrom opens, it has no recordset, but in the Tag I put a stored procedure. In the On Load event, I call the procedure using the ID from the unbound field on the main form, and then on my subform set me.recordsource to me.tag.
Docmd.findrecor d has always been...Leave a comment:
-
That's sound advice. So I'll add my users one at a time and ascribe them roles. Roles seem to be fixed, though, correct? I cannot add a new one. Doing a little research, I read that by playing around with schemas one could control which db objects users have access to, which I could see coming in handy at some point. But defining the permissions of what a user can and cannot do (eg edit) is done through roles, correct?
My problem now...Leave a comment:
-
OK, so I got the domain name from my IT department, and my server is in mixed mode. I want to add my 20 users through Windows Authentication. I'm in SQL server 2005, management studio. When I go to create a new login, for "Login Name", I would enter DOMAIN\username for each person (where username is their Windows username), select their default database, and then go to that database and add them as a user and define their role? Or do I...Leave a comment:
-
Minion got it right, I'm changing the subform sourceobject to a different form. The main form stays the same.
I had tried .Filter and couldn't get it to work for the subform. Here's what I've done:
Forms!frmInitia tive.CommView.F orms.Filter = "ID = " & iID & ""
(CommView is the subform name; iID is an integer, so I left out the single quotes). I get:
Error 438: Object doesn't...Leave a comment:
-
docmd.findrecord error 2162
Hi
Having some problems with docmd.findrecor d, getting runtime error 2162, in an adp, sql server back end.
On my main form, I have a continuous view subform giving a list of subrecords within the main record. Double clicking on the subrecord changes the subform to a form that gives more detailed information on that specific subrecord. I've been trying to use docmd.findrecor d to pull up the info, but I'm getting nowhere.... -
Sorry, tried to delete my post but couldn't so ignore this message.Leave a comment:
-
Thanks Jim for the help. I realized I didn't get your email, I wanted to ask you a quick question about udfs, I'm getting a "is not a recognized built-in function name" error. Maybe you could email me the sql for one of your views that incorporates a udf that we looked at?
Thanks!
RobinLeave a comment:
-
Great, let's do remote access if you can. I'm in NYC, and could do anytime from 8:30 to 4:30 pm. It's probably best to communicate this info via personal email, rather than the forum. My email is: rghertne@health .nyc.gov.
Robin...Leave a comment:
-
Great info. I'm doing some research into it now... Chances are I'll take you up on the remote access, as I'm still learning to navegate SQL Server Management Studio.
You mention the "unique table" the forms property, in Access. I defined that but the recordset is still not editable. Do I have to look at how the View is constructed?...Leave a comment:
-
I'm creating a Project ID number based on the information of the currently entered project. That ID is based off of a code corresponding to the client company we work with. I have to pull up related that code from a separate table not in the recordsource. I was able to do this when Access was the backend, because access saves the record as soon as info is entered; SQL Server doesn't seem to do that, so I need a way to save the record to then use...Leave a comment:
-
Save Record in VBA
ADP front end, SQL Server backend.
On my main form, I need to pull up in a select query in values from a record I am in the process of adding, before SQL Server actually saves the record to give me the Primary Key ID, which is autoincrement. I've tried docmd.runcomman d accmdsaverecord , but it is giving me this:
Run-time error '7874':
Access can't find the object 'SELECT ((0)) AS Column1, ((0)) AS Column2,((0))... -
Good, looking into that now.
Another question, I've based some forms and subforms on views, but am finding that views based on multiple tables cannot be updated. This creates a problem for my forms that are for data entry. Any suggestions for ways to get around that? In my mdb file I could create a recordsource based off of a query, I was getting errors when I did that in the adp.
R...Leave a comment:
-
I'm walking through it all now, close to finished with the ADP conversion. Didn't realize how much coding had to be changed for SQL Server and ADO, and how many little things I had to rewrite (all my FindRecords had to be reworked).
One question about security. To use windows integrated security, how do I set that up in the SQL Server? Do I need to create a new user with the windows username and passwords for every use? Or is there...Leave a comment:
-
Update: this is happening with different subforms on a main form. By sending the Access recordsource queries to the SQL Server backend as views I was able to resolve some, but not yet others....Leave a comment:
-
How to fix missing subform with error: "Syntax error access violation"?
Hi,
I'm running an ADP with SQL Server as back end. On a main form, my subform is coming up blank. When I was running as an mdb with no back end I didn't have this problem. I get an error "Syntax error access violation", and the subform is all white, not even any empty fields. I'm not even sure where to begin to look for the issue.
Thanks, any help is appreciated. -
I think I'll go with the ADP method, thanks for the clarity on the connection strings. Taking a while to fix bugs now, though, as I have to make sure my old access sql strings are valid in sql server. I'm running into some other issues now with Access, subforms now coming up blank when previously they worked fine, and on some of them I get the nebulous error "Syntax error or access violation"....Leave a comment:
-
I've made the ADP, and now am going through my vba code to adapt. I've been using DAO, not ADO (still unfamiliar with ADO), and I see the DAO isn't working anymore. Is ADO the language to use with ADPs then?...Leave a comment:
-
Thanks for the tips. I've been thinking about using an ADP, but hadn't gotten to that point yet, maybe this is time to do so.
I'm connecting through ODBC, using SQL Server authentication and a login ID. I use the same login on my computer and a users, and on mine I can access, on theirs I cannot. The server is not local, but on our intranet.
Internal tech support said I should embed the SQL connection string into my...Leave a comment:
-
Connect Access to SQL Server
Hi,
I'm a new SQL Server user, and am having initial troule connecting my Access front end to my SQL Server tables in the back end. I have no problem doing it through ODBC on my computer, but on other users machines I get this error:
SQL State 28000
SQL Server error 18456
login failed
The only different between my machine and their's is that I have SQL Server Management Suite, and they have...
No activity results to display
Leave a comment: