Search results

I don't like writing SQL in Access, SQL-Server (Management Studio) is much more comfortable. The "inteelligence" is on the server with us. And we usually fill the fields in access with vba, not link to actual tables.

Windows authentication seems the way to go, at least for me. But we don't allow users to access SQL-Server, only groups. And for the groups we define specific roles. These database roles define actions and objects, that they can access/perform. First step, take away all rights on the server for...

You have to get to know your DBA and talk to him. He should be able to help you. Mine is sometimes quite difficult, but keen on security. Yours seems not to bother. there are several levels of security in SQL-Server possible. including user authentification (2 step with our company), user groups...

I have similar problems, my "solution" is to group the records. my records are unique, so I will get the same number of records, but grouping seems to force Access/Excel to look at all records, which means the query will be slower, but it won't quickly decide on a data type.

I find the debugging somewhat cumbersome. And we have the problem, that some part of of our programs don't work on certain computers, despite all being company set up computers. And we also have Mac OS X computers ... not a lot, but some "privileged" people. And as we do some serious...

I hope I am in the right section and my question is not too basic: We started developing tools for budgeting and financial reporting on the base of ms-Access. Now we have moved the data to SQL-Server and (most of the logic) to stored procedures and use Access only as an importing tool and a...

Hi Richard Your "job" sounds very intriguing and exciting. Music therapy is very complex and depends on the field you are working in. You could be working with people whose communication skills have been diminished (or not developed very much yet), as for instance with newly Borns, people in...

Hi My name is Chris(toph) and I restarted working with Access in Mai because I found a job as a controller and that is what I am supposed to do. I started programming in the 90s on apple macs with Think Pascal. I love music and I graduated as a music therapist in 2016, but could only find a job...