managing local data file - warning about mdb and mdf files

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-05-08
I am reading a MSDN page - how to manage local data files in your project.
I am concerned - I have just got my C# form working with a microsoft access database. I have copied from the releas folder an .exe file and access database.
I am entering data into database from form and it seems to be working well.
Now this article mentions:' Caution this option is not recommended for .mdb or .mdf files The database can change even when no changes are made to data.'
Should I be concerned about this- I am hoping to have a number of users using this form to enter data into database? -
thank you
Question by:davetough
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 20

Accepted Solution

clarkscott earned 2000 total points
ID: 26297247
I've been working with Access tables (backend for VB and Access) since version 2.  I've never encountered the Access database changing "even if no data is changed'.   The only way I can see this happening is if the Access forms, queries, reports, etc. are in the same MDB as the tables.  In this case, the actual MDB can expand without changing data.  But if your Access mdb is only tables and you're linking (dao, ado, etc) to these tables.... I wouldn't worry about much.

I've seen databases become corrupt if a user has a problem PC (locks up or other hardware issue) and they are working in the tables when the PC crashes..... but that can probably cause issues with any back-end database.

My "2 cents"...  you're OK

Scott C

Author Closing Comment

ID: 31676332
thank you-I was hoping my feeling of success that I have it working wouldn't be short lived

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question