connecting to Access and pulling images for display

[Caitlin-havener]

I'm new to server and database scripting so I need a little direction.I have access on my computer and I have uploaded a database of about 400 lingerie items that I sell.I want my description pages to access a cell within my database and pull that information out and insert it into a html <img src"...."/> I also want it to be able to pull item description and price to display on html page. Where do I start with this? I host with godaddy so I don't need any installation instructions. Also, best resource for really learning this stuff???

[Synook]

Well, do you know ASP? If you don't, I suggest you learn ASP.NET instead. Then have a look at ADO.I suppose you have a Windows plan with Go Daddy? Note that they may not allow you to access remote databases, in which case you will need to transfer your database to them. If you keep the database on your computer, the machine will need to be on 24/7.The best site to learn all this? W3Schools, of course! Well, there are probably many around, but I since I don't do much coding in the Microsoft web languages other people may have more suggestions.P.S. Access is not the best database solution for applications that will have multiple concurrent users (i.e. like websites) - you may want to look at SQL Server or MySQL instead.

[Caitlin-havener]

Well, do you know ASP? If you don't, I suggest you learn ASP.NET instead. Then have a look at ADO.I suppose you have a Windows plan with Go Daddy? Note that they may not allow you to access remote databases, in which case you will need to transfer your database to them. If you keep the database on your computer, the machine will need to be on 24/7.The best site to learn all this? W3Schools, of course! Well, there are probably many around, but I since I don't do much coding in the Microsoft web languages other people may have more suggestions.P.S. Access is not the best database solution for applications that will have multiple concurrent users (i.e. like websites) - you may want to look at SQL Server or MySQL instead.

Does MySql have software that works like Access (preferably where I can export my data)?Yes it is windows hosting.

[Synook]

MySQL has many front-end tools, a popular one is phpMyAdmin. You should be able to export your Access database as SQL (or CSV) and import it into MySQL that way.

[trevor-]

MySQL has many front-end tools, a popular one is phpMyAdmin. You should be able to export your Access database as SQL (or CSV) and import it into MySQL that way.

Also remember (obviously) that many of the Access types will have to be changed (i.e. Memo might become blob if you use one of those automaters, and you might want to use long text instead), autonumber isn't the same thing either as the MySQL equivalent, etc.