John W. got help with this task. Got a similar task you need done?
Open
Assigned
Completed

Rebuild an Access database

Posted by John W.

Location

Remote

Due date
Sunday, 23rd Sep 2012
Details
Our volunteer fire brigade has long used a fairly simple Access database with forms, reports and macros to store and manage the data on our 80 members. Something has corrupted the structure of the database and it won't allow us to modify any forms or reports. The data tables themselves are fine though. I'd like someone with a high level of expertise in Access to repair and rebuild the database structure and possibly tidy up the macros and functions while they are at it. The database will be provided to you without members data in it for Privacy Act reasons and we will drop the member data back in when you are finished. The database was originally created in much earlier versions of Access which have long been saved over - so it will require someone to rebuild the database, although you will certainly be able to to copy the forms, structures and most likely macro content. Some of the macros were written to cover functionality that is almost certainly in the current versions of Access though. A simple project for someone who knows Access. Please only respond to this project if you have a depth of expertise in writing Access databases.
Offers

No offers were made on this task.
Task Activity
4 comments about this Task
Comments are now closed
I just completed another task working with access databases, and as you said, the change between versions may be to blame. Initially i'd try run access in compatibility mode (that can address some of the issues with older versions).

So are you asking for a new database to be made with forms and macros? Perhaps that will be easier than finding the problem and fixing it, especially because Office 2010 makes it fairly simple
John W.poster
Probably created in Access 97 and has been shuffled to current versions over the years. Now in 2010. Undoubtedly that the cause of the issues, Ben
What version of MS access are you using? Have you done any upgrading recently to cause the macros to not work?
I'm willing to give this a shot. I don't have extensive Access experience but I do work in the IT industry.
0 new tasks