Find Jobs
Hire Freelancers

Access database update

$30-250 USD

Completed
Posted over 6 years ago

$30-250 USD

Paid on delivery
My company uses an MS Access database that was created with Access 2000. We recently updated to Access 2007 and it broke it. We need to have it modified to work with Access 2007 and later. Here are the specific issues: The database contains a few Forms, reports, tables, and VB modules. All of them are quite simple. The biggest problem we are having is with the printing of various reports. Some of the lines simply print with "#error". We suspect these problems might be in the way the reports are designed or formatted, but it might be the Build Events or VB modules, we don't know. All we know is it used to print fine with Access 2000, and now it doesn't. And it always fails with #error being printed. To try to fix things, we started using a new printer. The original database was written or formatted for HP LaserJet 4 Plus. The new printer is an HP LaserJet 4350. All the same problems still exist with the new printer, so we don't think the problems are related to the printer. To use the database, we open a Form called "Form1". This Form has a few buttons that trigger events to print the reports. The reports are mostly just shipping labels of various flavors. Open Form1 and you will see what I'm referring to. It's a very simple database. A few requirements: All changes that you make must be documented as follows: Create a simple text document where you list the changes that you had to make to any Reports or Forms. Any changes to Event Procedures or VB code must include a comment in the code for each line that you added, deleted, or modified. For example, ' [coder name] added this line Your documentation and comments should be good enough that we could take an identical database and easily find and make all the modifications that you did. Please note that the project will not be considered complete until this requirement is met. Thank you for considering this project. Please let me know if you have any questions.
Project ID: 16015896

About the project

16 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi! There are several issues with the database. First, it must be converted to 2003 format, then imported into the blank database (I think I see a file corruption), then naming must be changed because the field in a table cannot be named like "Name" - in Access 95 it can, but in newer Access, it cannot. Then Names of reports must be changed (cannot have # or / in the name)... but all is fixable. If you are using Access 2007 or newer, I'll update it to ACCDB. But note fore Access 2007, it is important to tell are you using plain Access 2007 or Access 2007 with at least SP1? File format between these 2 are different! Regards, Branislav Mihaljev
$155 USD in 3 days
5.0 (245 reviews)
7.5
7.5
16 freelancers are bidding on average $168 USD for this job
User Avatar
Greeting, I have understood your Access database update task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Microsoft Access, Visual Basic
$200 USD in 3 days
5.0 (167 reviews)
7.6
7.6
User Avatar
This might be a simple fix or it could involve making some changes to code/forms/reports. I suspect it might be a simple issue of fixing the references that are broken. I will confirm after I check the database. If you have any queries please let me know. Regards Rajiv Shah
$166 USD in 10 days
4.9 (160 reviews)
6.9
6.9
User Avatar
I have 4 years experience in Access VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Programming. Thousands of different tasks has been fulfilled from a simple daily routines with formulas and VBA to the complicated VBA projects in microbiology. I am looking for the projects on: - Excel - Excel VBA - Google SpreadSheet - Outlook VBA - Visual Basic - Data processing - Web scraping Mohsan
$250 USD in 3 days
5.0 (39 reviews)
5.9
5.9
User Avatar
Hi, I am a VB6 expert, worked in access as well. Will get the reports to work and will give change documentation. Also comment where required. Thank you
$155 USD in 3 days
5.0 (86 reviews)
6.0
6.0
User Avatar
Hi..I have gone through your project details and would like to take an opportunity to work on it. Being experienced in workin on MS Access on various versions and have completed numerous projects on it, based on which I can fix and made changes to make you db file working. Waiting for your response for detailed discussion. Thanks.
$133 USD in 3 days
4.8 (155 reviews)
6.2
6.2
User Avatar
Hello, sir I saw your project/mdb and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. Sure here no printer issue- it's a vba issue. I'll mark where I write my vba codes. I hope to upgrade to Access 2016 will be ok for you. I am senior Access/SQL/VB /Excel developer since 1997 . I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work. Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details. Thank You and Regards, Zura
$222 USD in 3 days
4.7 (52 reviews)
6.1
6.1
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
$122 USD in 3 days
5.0 (84 reviews)
5.8
5.8
User Avatar
Hi, send me the .mdb file via chat, I'll take a look at it (today) without you awarding me, if I find the reason I'll let you know, I'll prove the fix to you through screen shots, then you award me, if not you could hire any of the other dozen of applicants. Felice,
$155 USD in 3 days
5.0 (10 reviews)
5.7
5.7
User Avatar
I am not a random bidder... Could you please provide more details of the access db file... I hope I can help you on this one.. Please ping me if you are interested wtih my proposal and thank you..
$250 USD in 3 days
4.9 (27 reviews)
5.0
5.0
User Avatar
Hi I can fix your new printer problems and the other issues. Let's talk Regards, Monillo ##########################################################################3
$155 USD in 10 days
5.0 (4 reviews)
4.1
4.1
User Avatar
Hi there, I've been working with Ms Office (Excel, Word, Access, Power Point) since before 2000. I have few years of experience working with macros and writing / debugging VBA code. I have previous experience on similar data entry projects and with great reference from previous employers. Good English knowledge, technical skills and vocabulary should be considered a plus. I am a professional and I can do a very good job. Also an accurate one. Do not hesitate to contact me for further details. Kind Regards, Jon
$130 USD in 5 days
4.9 (7 reviews)
3.5
3.5
User Avatar
I am very able to update the spreadsheet and ready to start
$156 USD in 3 days
5.0 (5 reviews)
3.5
3.5

About the client

Flag of UNITED STATES
Thetford Center, United States
4.9
16
Payment method verified
Member since May 22, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.