Solved

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

Posted on 2008-10-31
6
278 Views
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.
0
Comment
Question by:solunatec
  • 3
  • 2
6 Comments
 
LVL 49

Expert Comment

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

http://www.yessoftware.com/products/product_detail.php?product_id=1

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

/gustav
0
 
LVL 62

Expert Comment

by:gheist
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.
0
 
LVL 49

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:

  http://www.mysql.com/products/connector/odbc/

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.

/gustav
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:solunatec
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?
0
 

Author Comment

by:solunatec
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...
0
 
LVL 49

Accepted Solution

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

/gustav
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add records to a form to a table 11 41
Does anyone know of an easy way to Uninstall Office 2010 but not Access 2010? 4 22
Calculation in Access 5 27
Help with DoEvents 8 28
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

831 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