Using VB/Access to admin remote Mysql

Anon

I'm building a pretty comprehensive PHP/Mysql E-commerce site with lots of functions. I wanted to take a stab at generating a VB/Access App to handle the administration instead of a web interface. Has NE1 done this? What problems/success did you encounter?
thanx,
J

webgeek

Hi,

Try http://www.accessmysql.com/

I have used it quite a bit, seems to work ok.

HTH

Mike

Anon

This program seems rather useless. The only reason I want to use access is to make nice GUI's with their form builder etc. This is so my client can administer his data in a user friendly way. If you just want what this utility does you should look at mascon. http://www.scibit.com.

mithril

Jacob,

Have you thought about writing the admin interface in PHP-GTK (http://gtk.php.net)? Why go to VB at all? PHP-GTK brings all the functionality of PHP to client-side, and you'd probably be able to quickly hack/reuse the web-based admin into a stand-alone. You could then offer your client both admin interfaces for the price of one🙂 The main possible drawback I can see, not knowing anything about the site you're building, is that at the present the only image format supported is pixmap. If you're not mainpulating images in the admin, you should be all good. A bleeding edge Win32 exe "complier" for PHP is available at www.deskcode.com/phpcomplier. Unfortunately the largest file it can currently compile for PHP-GTK apps is about 14kb, so you need to include() most of the app..... other than that is works great. I've got a sample app up on my site that interfaces with a relatively simple mp3 db catalogue (in your choice of either mySQL or MS Access) which might give you some ideas:

http://www.mithril.ca/code/php-gtk+/mp3_gtk.php

Hope this helps!!!

Cheers,

Geoff A. Virgo

[deleted]

Just what is it you want to do? make a VB app to administrer an access database and upload that into the mysql?
That means opening up your database server to the evil internet world.
At least with a web interface you can use HTTPS and be sure nobody is listening in on your data.
Doesn't VB support MySQL directly? I know Deplhi has add-ons to connect directly to MySQL databases.

Another thing: a web interface is accessible from anywhere, your VB app would have to be installed wherever the client want's to work, and your app would have to be compatible with win98, winme, winNT4, win2k, winXP....
You'd probable have to communicate with the server on TCPIP ports that have been closed by the client's (or your) firewall.