Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [microsoft-access]

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server, can also be used as a database server for Access applications.

21 questions
26
votes
7 answers

Best practices for moving large MS Access application towards .Net?

We have a really huge MS Access application developed in-house initially for our personal needs which then was turned into a commercial software and successfully sold. The software is a sort of "all-round-software-for-your-business" and contains…
Alexander Galkin
  • 1,870
  • 1
  • 14
  • 18
11
votes
4 answers

Why is it that MS Data Access story is so fractured ? Is it the nature of Data Access or is just MS?

This StackOverflow question asks "where can I get Microsoft.Data.Objects" It turns out the answer was probably that its in the CTP4 (code first) release of Entity Framework 4 However there where a lot of guesses. Including System.Data Entity…
Conrad Frix
  • 4,155
  • 2
  • 18
  • 34
8
votes
5 answers

Is there a downside to using Access as a database?

I have inherited an application that stores data in multiple tables in Microsoft Access; the Access DB is only used for storage, all data processing is handled by the app (VB.net). Is this good practice? I need to build a similar app from scratch…
OSKM
  • 199
  • 1
  • 7
7
votes
8 answers

Alternative for Access+SQL Server for enterprise projects

We're a small software company, developing projects for manufacturing facilities about analysis, traceability, reporting etc. We're using Access for front end, SQL Server for back end. We've quite big customers too and our company is growing. So far…
Deepak Rama
  • 79
  • 1
  • 1
  • 2
5
votes
4 answers

What is a suitable replacement for an Access 2003 database required to run an older PC?

Many years ago, I wrote a small Access 2003 database for a non-profit to track the donations they received. They recently wrote me asking for some new features (I was shocked it was still in use, honestly) and I'm wondering if I could rewrite the…
Jedidja
  • 151
  • 6
3
votes
2 answers

MS-Access to Sharepoint conversion?

I do some volunteer work with a non-profit organization on the side occasionally. My main area of expertise is ASP.NET, C#, and SQL. They currently rely heavily on an Access database for their day to day operations. One of their technology guys has…
agradl
  • 717
  • 4
  • 9
3
votes
1 answer

Implementing a Username Class

I am attempting to encapsulate several features about a user in a single class. Although the main use for this class would be to initialize it once and never have to call set any variables again, I would like this class to be scalable to be called…
Elias
  • 193
  • 1
  • 6
3
votes
2 answers

Improving the performance of a db import process

I have a program in Microsoft Access that processes text and also inserts data in MySQL database. This operation takes 30 mins or less to finished. I translated it into VB.NET and it takes 2 hours to finish. The program goes like this: A text file…
mmr
  • 131
  • 5
3
votes
4 answers

.NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?

We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The initial idea was to have SQL Server 2008 as…
Daventry
  • 39
  • 2
2
votes
6 answers

Deploying Microsoft-Access databases with our application

Up to now we use DAO 3.51 (MS-Access 97) databases with our application. We are considering using a newer version. Which versions are available? How about deployment? How about royalties/licence fees? Any recommendations about alternatives? This…
Dabblernl
  • 493
  • 4
  • 15
2
votes
2 answers

Connecting to an MS Access database (OleDB) with multiple users

I'm writing C# applications that store their data in MS Access databases, (I'd rather use a different type of database but currently have no other option). The applications are in use by multiple people at a time and so when there are multiple…
Rob
  • 23
  • 6
2
votes
1 answer

Enterprise application with lots of SQL queries

Context: I'm working on a fairly large Access database (which I inherited) that has its interface and tables separated. In order to make this work together, we have a lot of SQL queries (dozens). Some pointing to that database and some pointing to…
ApplePie
  • 429
  • 3
  • 11
2
votes
5 answers

We are moving an Access based corporate front-end into a Web-based App

We have an enterprise application with a front end written in Microsoft Access 2003 that has evolved over the past 6 years. The back end data, and a fair amount of back-end logic is contained within several Microsoft SQL Server databases. This…
Hannah Vernon
  • 240
  • 5
  • 12
1
vote
2 answers

Can a wide table be the correct choice in design?

I am relatively new to database architecture and I have been tasked with designing a database that will store 250 values per entry by my group. This is pushing the upper limit for fields in an Access recordset, so my first instinct is to break up…
DisplayName
  • 21
  • 2
1
vote
2 answers

Small databases online

This is to ask whether accdb databases are suitable for this application, and how to connect the user with the database (and the phone network with the database if anyone has a comment on this). I use an old pc program that downloads data from a…
egginstone
  • 19
  • 1
1
2