May 23, 2010

Can windows access run on a linux website?

I think this tread has become irrelevant. We don't know how to answer the...

I think this tread has become irrelevant. We don't know how to answer the question because the OP hasn't had the courtesy to clarify his meaning. If he doesn't care enough to do that, then why should we bother speculating?

If his intent was to "stir the pot" and then be able to post somewhere else about how "mistreated" he was "by those Linux people," then maybe he succeeded.

IMHO, there is no such thing as a "linux website." If the site complies with the standards, you shouldn't be able to tell what the underlying OS is.

Like  (0 likes)

Please split your question in two parts:1) You only need access to MS Access...

Please split your question in two parts:
1) You only need access to MS Access data stored inside an MDB file, you can access them form a linux webserver by: using ODBC with your favorite web language, convert your data with an external tool and import them into your favorite Linux database server (MySQL, PostgreSQL or whatever)

2) You need to run native applications inside an MDB file, because you've stored forms, macros, Access VBScripts programs. In this case you need crossover office or something you can use to emulate original Windows environment

Can you be more precise on what kind of "access" you want from "MS Access" ?
Thanks

Ben

I agree with Andrea, to just access an mdb file via windows that is stored on a linux server will not present issues. But to open it from a pure linux based system is very touchy without a emulator because the Visual Basic envirnoment is a core process in windows and it is needed for everything is access but table and query creation.

Like  (0 likes)

Now we have content moderator for this.

Now we have content moderator for this.

Like  (0 likes)

Please split your question in two parts:1) You only need access to MS Access...

Please split your question in two parts:
1) You only need access to MS Access data stored inside an MDB file, you can access them form a linux webserver by: using ODBC with your favorite web language, convert your data with an external tool and import them into your favorite Linux database server (MySQL, PostgreSQL or whatever)

2) You need to run native applications inside an MDB file, because you've stored forms, macros, Access VBScripts programs. In this case you need crossover office or something you can use to emulate original Windows environment

Can you be more precise on what kind of "access" you want from "MS Access" ?
Thanks

Ben

Like  (0 likes)

Hi to the group. I think I have a solution for David, in a roundabout way....

Hi to the group. I think I have a solution for David, in a roundabout way.

Here is a solution that will work (but it may take a day to setup)

a) on your Linux box install VirtualBox (formerly from Sun now from Oracle). Latest release is rock solid (at least on Ubuntu 10.04 that is)

b) Inside of VirtualBox install the Windoze version you have at hand and require.

c) Install MSAccess & any other items inside of your windows instance that you require.

d) Get MSAccess setup properly as you desire, presume you are using ASP inside of your win32 to push your db data out to a browser (if this is what you are trying to accomplish?!) Get this working inside your windows instance, first before you move on.

e) Reroute the VirtualBox ports for web access from inside your VirtualBox virtual machine out to your hosting Linux instance. (think its called VBoxManage command if I recall) For instance VirtualBox (win32) port 80 -> your redirect to be seen from outside (Linux) say port 1234

f) debug from your linux instance using port 1234.

g) if you want the outside world to 'see the whole linux universe including the win32 VM (with MSAccess on it), you may? need to do some further port redirecting at the linux layer.

Obviously this is a whole lotta trouble, so only you can decide if this is worth it to you.

Cheers from Huntington Beach CA //GHudd

More: Here is info re: port forwarding in Virtualbox...

Found at this blog: http://tombuntu.com/index.php/2008/12/17/configure-port-forwarding-to-a-...

.....cut-paste.....

Alzaf says:
December 15, 2009 at 3:21 pm
I have Ubuntu 8.04 as both host and guest. The only way I could get ssh working is installing openssh-server on both guest and host.

I also managed to get an apache web server working on guest and could communicate with host.

To get this working enter the following commands:

VBoxManage setextradata “VBoxInternal/Devices/pcnet/0/LUN#0/Config/apache/HostPort” 8080
VBoxManage setextradata “VBoxInternal/Devices/pcnet/0/LUN#0/Config/apache/GuestPort” 80
VBoxManage setextradata “VBoxInternal/Devices/pcnet/0/LUN#0/Config/apache/Protocol” TCP

Once the apache server is setup on guest, enter the following commands to open ports on iptables

sudo iptables -A INPUT -p tcp –dport 80 -j ACCEPT
sudo iptables -A OUTPUT -p tcp –dport 80 -j ACCEPT

To view the web server on host, enter the following command:

firefox “http://localhost:8080″

Like  (0 likes)

you can use wine software for run windows office packages in linux...

you can use wine software for run windows office packages in linux environments.

Like  (0 likes)

No but you can access a remote machine using Linux to connect to a Microsoft...

No but you can access a remote machine using Linux to connect to a Microsoft access database server using something like php for example.
Use the industry standard open source database MySQL instead. Or even postgresql.
Then your clients aren't tied in to sub standard proprietary garbageware from vendors such as Microsoft.

Like  (0 likes)

If what you are asking is can a MS Access database be stored on a Linux...

If what you are asking is can a MS Access database be stored on a Linux server and accessed by Windows clients, then the answer is yes. Nothing special required. The server is just a storage location for the file.

Like  (0 likes)

you dont need to You can access microsoft access database using the ODBC...

you dont need to You can access microsoft access database using the ODBC protocol thats if micro$oft still supports it using a wide variety of languages such as PHP. .

Like  (0 likes)

I assume you are talking about Microsoft Access -- That will not run natively...

I assume you are talking about Microsoft Access -- That will not run natively on Linux, but it might run under Wine or Crossover Office.

Open Office also has a database program if you are just in need of a database program and not tied to MS Access.

Like  (0 likes)

Pages