[Pro] Does Freeway Pro support Access database support?

Hello.

I am new to Freeway Pro and I want to create a website that links to a multi-table Access database that allows users to view, add, edit and search through the data in that database.

As a Mac user, does Freeway Pro allow me to do all of that? I have contacted support and asked if they offer Access support but have yet to get a reply.

If anyone can point me towards any tutorials that would also be much appreciated.

Thanks for your time.

Ian


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

On Feb 12, 2012, at 12:54 PM, Ian Walker wrote:

Hello.

I am new to Freeway Pro and I want to create a website that links to a multi-table Access database that allows users to view, add, edit and search through the data in that database.

Not directly, and not through any Actions I can recall. I believe that Joe Muscara made some Actions back in the late 90s or early 00s for “classic” ASP, and you could connect to Access through that route, but you would need ASP support from your server. You’ll have to check with Joe to see if I’m even remembering correctly. http://www.freewaytalk.net/person/view/1407

As a Mac user, does Freeway Pro allow me to do all of that? I have contacted support and asked if they offer Access support but have yet to get a reply.

Unless you are hosting on a Windows server (a contradiction in terms, really) and have “classic” ASP support enabled, you are going to have a very hard time interfacing with an Access database. It’s not up to Softpress or Freeway, it’s up to the server. Access on the server will be a very rare thing to find, and you would be much more easily served by finding a way to export the data from Access into standard SQL, and upload that into your server, which will doubtless be running a standard relational database like MySQL or PostgreSQL. Connecting those to your Web pages is simple, there are Actions and loads of tutorials and help to get you going, and it’s a much more mainstream way to work.

If your client needs to maintain the Access database and periodically upload to the server to change the site, then you’re going to need to create a system whereby they can export to SQL and replace the current data on the server, or create an administration console for them to use through a browser (the more usual way to do this).

Walter

PS: You may find a Unix/Linux server that claims to have ASP support available through cPanel. Don’t be fooled. This is ChiliSoft ASP, and while it does support the ASP syntax for creating a dynamic site out of includes and server-side VBScript logic, it resolutely will not support an Access database. Found this out the very expensive way when I had to switch servers and hire third-party coders to finish a job I thought could run on that platform.

If anyone can point me towards any tutorials that would also be much appreciated.

Thanks for your time.

Ian


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options