www.uburst.com www.uburst.com

"MS Access Database help"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Database Ideas
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"MS Access Database help"
Posted by Scott Kappler on Feb-07-02 at 10:30 PM (EST)
Hi,
I am working on a new store - I dont really know much about databases, but MySQL is not supported by my host's servers at this time. I heard there was a way to create a database with MS Access to use as the back-end of the store - Can anyone help me with this? ( I will CC this to Tech support) Thanks a lot!
Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

Using a Database with uShop, Microburst Support Team, Feb-08-02, (1)
UShop and Databases, Brian Levine, Feb-13-02, (2)
MSACCESS, oliver, Mar-19-02, (3)
Interfacing Access using ASP, Brian Levine, Mar-20-02, (4)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "Using a Database with uShop"
Posted by Microburst Support Team on Feb-08-02 at 07:12 AM (EST)
We get a lot of requests for a database interface for uShop, but in the simplest of terms, if your store's pages can access ANY database, then you can dynamically populate any of uShop's applets with data pulled from your database.

Most people looking for a database interface for uShop are, above anything else, looking for a way to pull product data (item name, price, pictures, etc) from a database where they have hundreds or even thousands of products, and then dynamically generate their store pages and uShop applets from this data. If they can do this, then they don't have to hard code hundreds of pages and applets with their product data.

So if, for example, your store pages were written with MS FrontPage and you want to pull product data from an Access database, then as long as you can know how to work with FrontPage to get it to read your database, then the rest is easy. (By the way, FrontPage 2002 comes with a Database Interface Wizard to help you, although I have never used it). So on your FrontPage-built store page where you want to put a uShop applet, you read your product data from your database before you spit out the applet code, and then you dynamically construct your applet with the fields from your database.

I use this example because Scott asked specifically about FrontPage and Access. However, there are other solutions - Cold Fusion pages and an Access database, PHP pages and a MySQL database, and there are others. uShop does not limit you from the type of database you can use, just as long as you can access your database from your web-readable pages, then you can plop down any uShop applet and dynamically fill in the parameters with database data.

Additionally, there is more information posted in this support forum about using PHP and MySQL... http://www.uburst.com/dcforum/ushop_database_ideas/1.html

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "UShop and Databases"
Posted by Brian Levine on Feb-13-02 at 12:32 PM (EST)
Assuming that your server runs under Windows NT, you can use Access as your DB, and ASP as your scripting language.
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
3 . "MSACCESS"
Posted by oliver on Mar-19-02 at 06:50 PM (EST)
I would appreciate if you could mention if the output has GONE from MSaccess to ASP... If there is a way of interfacing that?
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
4 . "Interfacing Access using ASP"
Posted by Brian Levine on Mar-20-02 at 09:02 AM (EST)
Can you read from Access tables using ASP. I assume so, since they're both Microsoft products. However, Access was never intended to be a high-performance, server-based data engine (Microsoft markets SQL Server as that solution).

Either way, what you'll have to do, in effect, is to translate the PHP code I provided, into ASP. There is probably a more visual way to do this using Frontpage, but I'm unfamiliar with it. There is tons of online info on ASP available, though.

Anyone else have thoughts?

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.