Recent content by Porisius

Managed to solve own issue... Person gets denied if trying to access the HR DB if they are only in the Training DB, even if the query/view used is in the Training DB. Sorry, had to find someone with Training DB Rights to test.

I have a MS SQL Server 2008 here at work with two backends in question. One is the HR DB and the second is the Training DB. We use Active Directory Groups for granting permissions. I do use Datareader/Datawriter Mappings, if you have a better solution, feel free to enlighten me. I did it because...

Oh quick note, not sure if you knew this or not... but SQL Server 2008 R2 uses the Pre-Windows 2000 AD Group names. Our NetAdmin forgot to change two of the Pre-Win2000 names over, and I struggled to update them in SQL. We had this issue when I was renaming them. I went to re-add a group...

AccessMSSQL, again thank you for the assistance. I guess it must be linked to AD's GUID then. You would think, (I know, I know), that it would update or something would have happened because its all Microsoft products. Guess I should be happy that I didn't have a bunch of angry users...

Simple inquiry: Our setup: MS SQL Server 2008 R2 with Access Front-Ends. Read and Write Active Directory Groups for each Dept's DB - Example: DB_Production_w ("_r" for read only access) Network Admin wanted to get rid of the read-only groups because they're not being used. So he renamed...

Okay, scratch what I said there... This was a simple fix, and I do mean simple. The source is here, but in Access 2010, go to File > Options > Current Database, and check the ODBC fields in the Filter lookup options. Thanks to you both, mdluek got me thinking a different way, and AccessMSSQL...

Out of curiousity, would it matter if I am using a DAO, ADO, or ODBC (currently using) to connect the front-end to the SQL Server?

AccessMSSQL: Okay, that's new to me... I know I use a lot of *s in my work. I'll have to keep the % in the back of my head if I get further in SQL. I looked at the data through the Microsoft SQL Server Management Studio and there are no spaces before or after the data in the non-null fields...

Thanks for the reply, and I probably should have been more clear. It's the Field List that is not showing up, with only 500+ records and the fact it works locally, there should be no issues. I'm not even getting the "Too many items to show." Thanks, Chris

All, I just recently discovered and learned a bit about Access and a MS SQL Server 2008 R2. Primary Keys and Indexes, yeah... I learned that I need to be more stringent on those. There have been some learning pains, but hey, no pain no gain. Well, I got a pain that I think I better call the...

Good ol' Micro-Shaft... and there's nothing Micro about the Shafting, too... I got into programming a few years ago, so I am still considered new by most programmers, (I'm fine with that). I have been building/repairing PCs since I was 6, now 27. So, yeah, I know... I know... at least some...

I think I am going to go with Bob's suggestion and ditch the First/Last. For inventory purposes, it shouldn't be used... then again, they should be using multiple part numbers. I appericate both of your efforts, and yeah, Bob, I've been working with Microsoft since DOS 3.3. They come up with...

Yes, for whatever brilliant idea, they have the same part number for different types. In their old DB, they imported 2 excel files, used a MakeTable query to do what my 2 SelectTable queries do now. Then used a second accdb to run reports and charts. So, I am combining the two, plus some of...

I tried just making a new query for the totals, and I get an error message "Division by Zero" How, I don't know, but it does give me a lead...

Same issue... Got Average/Min/Max, no Sum...