The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
49 views

Access Database Migration: Sharepoint or Custom solution [closed]

In order to migrate a local Access database and make it available on-line I'm considering two solutions: Migrate the database to SQL and build a custom ASP application in order to add/edit/delete ...
2
votes
2answers
152 views

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 ...
0
votes
1answer
42 views

Multiuser's impact on Access Database

Can someone explain to me how are effected the performances of an Access 2003 DB when it's used by a lot (30) of users on the same LAN? I'm working on a vb6 project with this access 2003 DB wich ...
-1
votes
1answer
245 views

Should I label class diagram variables as private or public?

In my program, I have several class variables whose access specifier is known as private package. The default accessor specifier in Java is known as private package where it is accessible within the ...
5
votes
5answers
256 views

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... ...
1
vote
1answer
566 views

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. ...
1
vote
1answer
897 views

Effective programming of data layer management/access

Short Version: What is the term/concept which describes the efficient design of programming the data layer for efficient data access and what are some sources/books/articles/website which discuss this ...
8
votes
5answers
2k views

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 ...
3
votes
3answers
224 views

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 ...
4
votes
2answers
350 views

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 ...
62
votes
16answers
5k views

Co-worker renamed all of my queries [closed]

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 ...
3
votes
2answers
125 views

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. ...
8
votes
9answers
3k views

How much database access should developers have? [closed]

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 ...
0
votes
4answers
274 views

Learning new thing and implementing new thing in a company [closed]

In my new company, I wanted to use Doctrine DBAL for data abstraction. But it's not working due to the PHP Version 5.2 we are using on our development server. Here it's all about rights issues. You ...
8
votes
6answers
746 views

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