Question...

From: skc (anonymous_at_discussions.microsoft.com)
Date: 04/21/04


Date: Wed, 21 Apr 2004 06:08:03 -0700

Hi,

I have been using FP98 and FP2000 for a number of years
now. I always use Access as my backend database and
generate custom .asp code to access the database and to
interrogate the data with custom SQL.

I am now going to engage in a new project that involves
uploading files - hence my move to FP2003. I have not
installed it yet, but I have some questions before I begin
playing with it...

Application
-----------
This is going to be for a lighting company so to let them
fully control their stock lists. The lighting company
will take a pic of a lamp shade, fill in an online webform
and attach a picture from their digicam to be uploaded to
an access database. Similarly, records can be deleted
using webforms and custom .asp.

My ISP has the latest FP extensions and hosting is
provided by an NT box - good news!

Questions
---------

1. Is Access good for this? I do not want to go down the
SQL route, but for managing around 100 different items of
lamps and uploading pictures, would Access be efficient?

2. Are there any pointers on how to get the file upload
component working in a web form so pics can be posted into
an Access table?

3. Any other things I should know about before I explore
FP2003?

Thanks,

skc



Relevant Pages

  • Re: typed datasets vs. business objects
    ... When I use a business object to populate a gridview, for example, I ... don't have to loop through anything. ... I have done lots and lots and lots of reading on them vs custom ... DAL objects that the in-house written database engine used. ...
    (microsoft.public.dotnet.general)
  • RE: getting Membership userid to use and store in a custom databas
    ... I would like to use the key in a many to one database the (one being your ... custom home page. ... what you'd like to do is something like the Profile ... getting Membership userid to use and store in a custom ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Dear Mr. Wainwright, et al... please help re: database corruption
    ... My Entourage 'custom views' seems to be damaged. ... I get a message that my database is damaged with the following detailed ... have a lot of mail accounts, folder, rules etc that needed setting up again. ...
    (microsoft.public.mac.office.entourage)
  • BCM Sharing, Add-Ins and Synchronization
    ... additional information on a new region within a BCM Account. ... Let me say first that simply using custom fields is not feasible due to ... didn't seem to work when using a shared database. ... Is there some built-in feature of the BCM synch mechanism that can ...
    (microsoft.public.outlook.program_forms)
  • Re: Data Access for Custom Collection Design
    ... I only know of three ways to interact with the database ... loop over the data and then create objects accordingly (Fetch). ... the Custom Collection, you would pass in the datatable object that you wish ... 'if iRet> 0 Init our Garages ...
    (microsoft.public.dotnet.framework.adonet)

Quantcast