Topic: Database on SME7.2 for Windows Access Clients?

[TeNeCo]

I would like to move my small access 03 database somehow to my sme-server to allow the access from different places. It is just a small address database.

[cactus]

I would like to move my small access 03 database somehow to my sme-server to allow the access from different places. It is just a small address database.

You could place it in an ibay and give the required users read and/or write access to this ibay.

[pfloor]

Take note about working with DB files and Samba.  See this thread for example:

http://forums.contribs.org/index.php?topic=38087.0

Particularly this post about turning oplocks off and why:

http://forums.contribs.org/index.php?topic=38087.msg172064#msg172064

[TeNeCo]

Up to now I can't access my i-Bay from outsite. But what about using something like a SQL Database on the Server?

[cactus]

Up to now I can't access my i-Bay from outsite. But what about using something like a SQL Database on the Server?

To enable access from the outside you should properly set the access privileges properly.

SME Server uses mysql as a database server, you can port the database to it. MySQL however does not come with forms etc. you will have to write them your self for instance using a web form.

Perhaps you could try sourceforge or something like that to find a replacement for your access database that makes use of a mysql database and comes with a interface as well.

[TeNeCo]

I thing it would be nice to use the iBay-Folder files as a network folder.

To enable access from the outside you should properly set the access privileges properly.

Where? only in the iBay-settings? group= everyone, public access: via internet.

The remote Windows-PC asks for username/PW, as username I enter the name of the iBay and for PW the PW I assigned to the iBay. but the access is not granted.

[cactus]

I thing it would be nice to use the iBay-Folder files as a network folder.Where? only in the iBay-settings? group= everyone, public access: via internet.

That is not possible, you could place it in the html folder though this would make it accessible (you can download it)

Even if you modify the webserver's configuration file you would only be able to download it and not save it as the shares (files/html/cgi-bin) are provided internally by samba (as a folder on a server) and externally as a webserver location.

[soprom]

Since mdb format is very sensitive to network quality, I found it better to use a mdb file through a network mapped drive. So, in order to connect to a mdb file from the Internet, a vpn access is required. A few vba function were added to my apps to connect vpn and link odbc.

What I'm doing since for the last few months is to use a msql database through ODBC connection with an Access frontend. The results are surprisignly good for response time and I'm going this way from now on.

On a LAN, I just make sure a user starts Windows with a username known to the serveur (same username and password for windows and for server). The user is then made member of a group and that group "owns" an ibay with no internet access. The ibay is mapped to a letter and the mdb files are put in ibays\files.

Hope my experiences could help...