MS Access on a Linux Server

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello to everybody,
I need to put an MS Access database on a Linux Web Server.
Can you please let know, if it possible first of all, and suggest (if
available) a weblink where I can learn how can I do this step by step.
I tried to search on the Internet but the best solution seems to be
Mysql+php.
The MS Access database is ready, it works, and it a simply list of names,
address, city, phone number, age of the member and should be update via web
from different locations.

Thanks for your help.
Kind regards
John
 
You not quite being clear:

How can I put a VB6 application on a web server?

ms-access has two parts:

The forms software development part. that is code, forms, appcation
design part. This is no different then using vb, or c++ to develop an
application. This part of your application needs a windows box to run on.
(no different then vb6, c++, or any other development tool for windows).

You are aware that Oracle, sql server, MySql etc are database only engines,
and don't have the ability to let you build an interface with forms and
code.

ms-access makes a great front end to Oracle, sql server, MySql, or whatever
your favourite database engine you use. So, ms-access is more the
development tool then the database part.

There has been two database engines that ship on the office cd for use with
ms-access (been shipping for the last 3 versions of office). One database
engine is a desktop edition of sql server, and the other data engine is the
JET database engine (this is the default one that most people use).

Since ms-access is not a web based product, then you can't use the code,
forms, and reports.etc on a web based system.

Since you can't use any of the features of ms-access, then it makes VERY
little sense to try and use ms-access on a web server, let alone a Linux
one. Any code, or anything you write in ms-access can't be used. (can't even
be used on a ms web server).

So, you only left with the data only part..and there is at least 2 or 3 free
data engines from Microsoft that you can use..and others such as MySql also
exist. All of these data engines can be used to store the data, and you can
connect to these data engines with VB6, c++, and yes even ms-access also
makes a fine front end development tool for those data engines.

It is not clear if you are trying to just place the data on the server, or
an actually run the ms-access code/forms (appcation) on the server (you much
failed to distinguish this issue).

Further, since the JET database engine is a file share, then it you *could*
place the back end mdb file on a server (in your case a samba share), and
then connect to it via a VPN. So, in theory, this would work on your linux
box. However, the performance of a high speed t1 line is about 100 times too
slow. I explain this issue here in detail:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Since you can't use any features of ms-access, or vb6, or c++ on your web
server..it makes zero sense to use ms-access in this case....
 
Further, since the JET database engine is a file share, then it
you *could* place the back end mdb file on a server (in your case
a samba share), and then connect to it via a VPN.
Click to expand...

Because Access's record-locking mechanisms are so intimately
connected with the Windows file system (the DISK OR NETWORK ERROR
message is an indication of just how intimately connected), I would
never contemplate storing an Access back end on a Samba server. Many
people report success with this, and good performance, but I'd never
take the risk.
 
Thanks for your answer and a detailed explanation even if some part are
still not clear to me, due to my lack on knowledge.
At the moment we have a very basic MSAccess database (name/surname,
occupation, address, city, phone numbers, email address, year of
subscriptions, paid, note field), and we (different persons work on it)
updated it via email. Approx 600 records.
The database consists of 1 table and a few queries, some of them are
parametric, plus reports.
So there are no codes or modules.
Basically we would like to share this database on a web instead of sent via
mail.
Which is the simplest way to share on a Linux server, considering that we
need to do the usual use of a database: insert, delete, update the records
and print the result of a query?
Am I able to preserv at lest the data store on the table?
Is any online tutor available on a web?

Again thanks for your patient, time and a great help and effort to make
things easy.
Kind Regards
John
 
The database consists of 1 table and a few queries, some of them are
parametric, plus reports.
So there are no codes or modules.
Click to expand...

No forms either? You mean those poor people have to figure out what fields
are needed, and have to edit them in a poor spreadsheet type format?

I doubt that you don't have any forms. However, if you don't have any forms,
then you don't need to bother with ms-access at all.
Basically we would like to share this database on a web instead of sent
via mail.
Click to expand...

As mentioned, since you not using any features of ms-access, but just have a
table, then use
something like MySql. You have to build some web pages for users to view the
data, but
that not too hard...
Is any online tutor available on a web?
Click to expand...

You not going to find one for ms-access, as it is not a web based system.
I would not use ms-access and "jet" for a web based system. So, you
essentially are using the wrong tool, and ms-access is not a web base
system. So, wrong tool, wrong newsgroup...wrong road....

Just use something like the free edition of Sql server "express", or even
MySql (which is not free for commercial use).
Either of these database systems run on a web server...and ms-access really
does not.....

ms-access is just plain the wrong tool here...
 
Thanks Albert,
you are right, I forgot to mention "Forms". I apologies.

And, thanks again to clarify to me that MSAccess is not a right tool for a
web based system so I dont have to invest time and resources for something
that is not correct.
Regards
John
 
Back
Top