How to synchronize and Access Local database with new Freebsd web server

Posted on 2008-10-31
Medium Priority
Last Modified: 2013-11-22
This is an open ended question becuase I have little experience with this; basically our office contracted someone to create a series of forms for the office, I am instructing them that some of that information can be beneficial posted on the web for customers, we are considering buying a unix type web server: the information is in Access so I assume it can be dowloaded into a text file; and the freebsd server will have mysql installed which can upload the files: yet how does one streamline this process so that both databases become updated becuase some input will come from the web also and should go into the lan.
Question by:solunatec
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
  • 3
  • 2
LVL 51

Expert Comment

by:Gustav Brock
ID: 22856093
Many open ends here, but have a look at CodeCharge Studio:


This will create a PHP driven site which should be able to run on your FreeBSD server.

LVL 62

Expert Comment

ID: 22856902
You should be able to convert access database into PostgreSQL or MySQL while still keeping UI in Access.
Then yoou can use any tools common to databases like PHP to create website.
LVL 51

Expert Comment

by:Gustav Brock
ID: 22857189
> the freebsd server will have mysql installed ..

Sorry, missed that.

If so, let the web frontend read and write to that database.

From Access, you can use the MyODBC driver:


to link the tables of MySQL directly to your local Access frontend database. Then any changes in either will be reflected in both frontends.

By which tool and programming language the web interface is created is of no importance.

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.


Author Comment

ID: 22868790
Let us say for example that the php was on a freebsd machine; physically the Access database would have to be on its own machine?

Author Comment

ID: 22869085
I guess what I mean is that the best way to do this would be how: I would have to buy two servers or leave the Access on a desktop...
LVL 51

Accepted Solution

Gustav Brock earned 2000 total points
ID: 22870518
Microsoft Access only runs under Windows. So a real or virtual Windows machine must be present.


Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month8 days, 4 hours left to enroll

765 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