Search results

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

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

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

I've been banging my head against this one, but I have a query that I setup for inventory use. In that query, some fields use a formula. I, then, added a Totals row to it. I have a few, like the one shown below, that I set to Sum, but it won't show it. It will show Average/Min/Max/etc, but...

All, I have a database that its entire purpose is to grab a file that has test data for a part, parse its test data, calculate lot numbers from the parts used to make the part that was logged in the file, put it in the table, rinse, and repeat. Simple, done, no problem there... Now, with as...

All, First of all, I want to thank everyone I ever googled to learn VBA and Access. I have never had formal training, or gone to any classes for this, yet managed to land a contract job after leaving the Navy. They have been impressed with my work (Guess I should say, "Our"?). I never got...

Hello all, I have a problem with one of the databases I wrote a long time ago, kinda been out of the loop so bear with me. I wanted to update it a bit since I haven't used it in a long time. Recently my work migrated over to WinXP, and ever since my database has not been able to open due to a...