98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » New database files
New database files
Resolved · Low Priority · Version Standard
Tue 25 Mar 2008, 16:34Delegate Sarah said...
Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management - Framework & Processes course
New database files
Hi,
Something very strange seems to be happening, seemingly randomly, with regards to our database files.
We currently have one centrally held database which we all access at the same time from different places. To keep it simple, our database is called "Alpha".
What keeps happening is that new database files keep appearing and will be automatically named "Database" and then with 1 or 2 or 3 after it depending on the number of those files already in there. These seem to be identical to "Alpha" although I've noticed that the sizes of these duplicates differ slightly betweem themselves.
Please help explain why Access is creating these duplicates (they are not backups since we see these types of files created with "...backup" in the name), and also please help us to stop these from being automatically created!
Thank you
Thu 27 Mar 2008, 15:58Trainer Rajeev said...
RE: New database files
Dear Sarah
Thank you for attending Access Courses. I hope you enjoyed the course and they were useful to you!!
I can
Fri 28 Mar 2008, 09:45Delegate Sarah said...
RE: New database files
Hi Rajeev,
Thank you for your advice - I have since looked again at the file formats of these random 'Database' files and it seems that they are in .mdb format which from what I understand is the old Access 2003 format. What I can't work out is how to re-create these folders myself and I've been trying to change my personal Access2007 settings so that the default file format is set to 2003, but I still cannot recreate these duplicate .mdb files so I'm not sure what else could be causing them
Am I on the right track regarding the file formating? Also - when I compact the databases could this cause a new file to be created?
Thanks
Fri 28 Mar 2008, 10:07Delegate Sarah said...
RE: New database files
I have also literally just worked out that I can re-create these files - they are created in the .mdb format when I compact and repair our 2007 Access database. Does this make the problem clearer?
Tue 1 Apr 2008, 11:09Trainer Rajeev said...
Splitting database
Dear Sarah
I have done a bit of research and the most likely reason is that may be you have the option enabled to compact on close which might be causing this problem. This can occur if the compacting fails for any reason. To deactivate it you have to choose the Office Button and click on Access options. Select the Current database and then untick the Compact on Close option.
This may not resolve the problem because the main reason of it is that you have stored the application on the network drive and are running the application directly from there. Microsoft have found that the main reason for data corruption has been when the entire database is shared over the network.
It is suggested that you split the database into two databases:
A front-end (FE) and back-end (BE) application. A copy of the Front end (FE.mdb) should be installed on each users local hard drive.
The back end will contain the tables, as well as the relationships you have defined for those tables in order to maintain referential integrity.
The front end of your database will contain the application objects: queries, forms, reports, data access pages, macros, modules and temporary tables as well as Lookup tables that rarely change and the links to the tables contained in the back end database.
May be you have a database developer who might have the knowledge and experience of splitting the database. Please note that although Splitter Wizard is commonly used to quickly and easily split the database, but if it's used on a secure database, the back end database file will be left unsecured.
It is suggested that if the database is secure then to split the database manually.
1. Make a copy of your database - this will be the backend.
2. Open the backend and delete all objects except the tables.
3. Open your original database and delete the tables/relationships.
4. Go to File, Get External Data, Link Tables and locate the backend.
5. Choose all the tables and link.
I hope this helps
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
