Using A Form With An Access Database

[tmccartney66]

Folks:

 

Since this is not Windows-based hosting, is there no way to set up a form that feeds results into an ODBC database (in this case, MS Access)? I'm choosing Access because this is a pretty simple procedure using FrontPage, and I have NO clue how to use MYSql databases, nor could I make much use of the data once I have it.

 

I suspect the problem is that with Unix hosting it appears impossible to establish ODBC system data sources, but I could be wrong about that. (There may be a Unix-based analog I don't know about.)

 

Any pointers in the right direction are greatly appreciated. As you can tell, my background is in Windows web servers.

 

 

Tracey

[SlitheryImp]

I don't know if this will help you, but if you set up your form to feed the results int a mysql database (most people here can help you with any queries regarding that) you can export/import all of the information into MS Access via the ODBC.

 

download the MySQL ODBC driver here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

 

_________________

You can import via:

 

File | Get External Data | Import..

 

Scroll to the bottom of the list and Choose 'ODBC databases ()'

 

Then you can fill in your account and server details to import the data.

_______________

 

Hope fully this will help you, I am at work at the moment, so this has been done in haste.

 

Marcel.

[borfast]

Tracey, Marcel is right. You can use the MySQL ODBC driver to use your data from within Access and take advantage of what you already know.

 

By the way, just as a side note, you can establish ODBC data sources in a Unix system, as long as you have the drivers for it. You can see that there is an ODBC connector available for a lot of Unix systems, right in the page Marcel pointed.