Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [access]

24 questions
63
votes
15 answers

Co-worker renamed all of my queries

I don't know if I should be very irritated or what. I single handedly built over 300 queries for a large database, and developed a naming convention so I could find them later. No one else in my office even knows how to build a query, but I came in…
anon
17
votes
9 answers

How much database access should developers have?

So I've worked in many different workplaces as a developer and my level of access to the database has been varied. I typically don't have production db access. Most of the time I have access to the test database, but it varies. Sometimes I can do…
RoboShop
  • 2,770
  • 6
  • 29
  • 38
9
votes
6 answers

When would dynamic scoping be useful?

With dynamic scoping, a callee can access the variables of its caller. Pseudo C code: void foo() { print(x); } void bar() { int x = 42; foo(); } Since I have never programmed in a language that supports dynamic scoping, I wonder what…
fredoverflow
  • 6,854
  • 8
  • 39
  • 46
8
votes
6 answers

Would you re-design completely under .Net?

A very extensive application began as an Access-based system (for database storage). Forms were written in VB5 and/or VB6. As .Net became a fixture in the development community, certain modules have been rewritten. This seems very awkward and…
IAbstract
  • 1,556
  • 11
  • 24
5
votes
2 answers

Alternative locking strategies

I'm having a problem with the design of my application, that neither optimistic nor pessimistic locking tends to solve. Here is a simplified/altered version of the problem that describes the situation. Premise of the problem: A document-processing…
Limbo Exile
  • 705
  • 2
  • 7
  • 11
5
votes
5 answers

How do you keep logins organized between multiple developers?

I've worked at several places with 2-10 developers and each place has struggled in the area of tracking if the company has an account on a given web site or service. We're always left wondering... What's the username What's the password (Obviously…
Ben
  • 625
  • 1
  • 5
  • 10
4
votes
2 answers

A Question about using different data access layers for different database providers

I have a question about whether we should use different Data access layers for different database providers like SQL Server, MySQL Server, Oracle etc.. Is it not better to use a single data access layer with the ORM or like mappings so that the…
Saravanan
  • 133
  • 7
4
votes
2 answers

Best Way to Express Meta-Info on Missing Data?

I work in healthcare IT, reviewing data management processes of various observational studies. One problem I have repeatedly faced is the poorly encoded data, especially when some values are missing. Background, skip if you like I am currently…
blubb
  • 2,754
  • 18
  • 34
3
votes
2 answers

Is Excel data model as good as or better than Microsoft Access?

I'm working with several Excel worksheets and workbooks that need to consolidated or linked to each other. These workbooks will track client interactions for different team members. I did the initial consolidation in Microsoft Excel, but realized…
Jasterix
  • 51
  • 5
3
votes
3 answers

What is the best strategy for quickly implementing small business applications?

I'm not a software developer, but I have previously developed a project-specific Access application for another employer. My current employer would like me to help organize their workflow and data for an upcoming project, and I was considering using…
Patrick
  • 133
  • 3
2
votes
0 answers

Viable ways to handle an access token on the resource/web application server

Use case: We have a product which ties a set of resources to a concrete user. Now we would like to provide the customers with an API so that an automated client application can have access to a subset of a concrete user's resources. A single user's…
Lyudmil Grigorov
  • 29
  • 1
2
votes
2 answers

Insertion sort vs Merge sort - memory access

I am a computer science sophomore doing a data structures and algorithms course. My professor said that insertion sort requires random access, while merge sort does not. According to him, the insertion step in insertion sort requires random access.…
James Bond
  • 386
  • 3
  • 9
1
vote
1 answer

What are ways to manage secrets in a big organisation?

Many articles on the internet focus on methods to keep secrets outside public-access (like mobile apps, website frontend etc). But let's take the example of a really big organisation. It has secrets outside public-access, as recommended, but it is…
Siddharth Venu
  • 137
  • 5
1
vote
1 answer

Git strategy for separate teams in one project without access to eachother source

We have one project and separate teams which work on separate modules. What we need is a strategy that allows our teams to work on one project but without access to each other source codes. one project multiple teams (separate) each team doesn't…
Hamid
  • 119
  • 3
1
vote
1 answer

WAN Connectivity between multiple MS ACCESS DB

I have a client that asked me to develop his Windows Application and use MS Access instead of SQL database. I did and now he asked me that he deployed the Application through several of his offices. Now he wished to have a "main Server" with all…
Sid
  • 127
  • 5
1
2