Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

managing local data file - warning about mdb and mdf files

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
1 Solution
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
davetoughAuthor Commented:
thank you-I was hoping my feeling of success that I have it working wouldn't be short lived

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now