Help with SQLite database connection

[Nyc]

OK so lets not worry about remote access to start off.

This is my main problem.

[droberson]

OK now I see what you are after.

[droberson]

How concerned about security are you or getting hacked from the internet?

Microsoft Servers have remote access feature built-in for clients. What does the server currently offer?

Your manager should be able to RDP to his workstation and have access to your application.

[droberson]

Also Microsoft Servers have the ability to export an application for remote application access.

Depends on the server software they have.

[turtle]

Yes, you need the host machine to be online all the time.

Just a point on security,

Unfortunately like what droberson is concerned on, if you use it this way (the path mapping way), security might be an issue as anyone who knows the path and is given access might just cut / delete the .db file.

[Kimera]

Nyc,

Sorry it has been a bit since I had time to come to the site. I have been tied up with some projects.

You can do what you want! I am a web programmer and what I did is used an ODBC driver for SQLite that was free online. In fact I think I got the link from the SQLite site. Anyway I then used web based progamming to connect through ODBC to the SQLite DB. This supported a web site that did about $300K - $500K a month in business. The user count went way above 20. The key for me was that I could write the web side of it with no issues, wich requires some form of server side scripting.

I have also used Lacewing to communicate the requests to a central server that communicated with the database. This works as well but you have to have the ability to install the server side of your lacewing program on the server itself and it's best run as a service in case the server reboots when nobody is around.

I have used SQLite to have multiple people reach accross a local network and read a flat file database. It works but it's a much slower option and I have never put it to the test with a ton of users as, well, it was to slow.

Hope this helps.

[Nyc]

Thank you very much for your help. I'll take a look at ODBC drivers and see what I can do. But this server-side scripting and lacewing is giving me headache.