Please explain how this ties to WordPress. Thanks.
For what it’s worth, if you’re doing this with WP, figure out how to export your data from access in a way you can import in into MySQL. Then, you can use the database tools built into WP to access the table(s) you create via access.
Bluehost operates via WordPress, ie, a Bluehost website is a WordPress website (I get emails from WordPress notifying me of software updates). The WordPress blurb for these forums says they are for self-hosted and “Self-hosted WordPress requires purchasing hosting with another provider, such as Bluehost, …”. So I think I am in the right place.
I have tried exporting from MSAccess into things like MySQL, but there seems to be endless software to download, and no matter what I try I never get there. Some of the answers on these forums on related topics seem to suggest that direct connection to MSAccess is possible, and that would (should!) be so much easier.
I think your question has a lot more to do with PHP than with WordPress. It would probably be better to post in more PHP-centric place like StackExchange.
Thanks, I’ll try there.
You refer to “the database tools built into WP”. Are there any that I should be aware of, other than php itself?
“alien” databases can be accessed with ODBC driver (its a PHP extension)
Some documentation can be found using search terms
PHP ODBC UnixODBC MSAccess
see
Many thanks for the replies. Hopefully I’ll get there, but it will take time so I’ll close this topic as ‘resolved’.