Re: FP + Access question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Clark (non-working_no_spam_email_at_ownertrades.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 12:22:06 GMT

You need to have asp working because the FP Wizard creates asp pages.

You can design the query using Access if you like, and then at the point
in the Wizard where it allows you to edit the sql of the query, just
past in the sql from the Access-generated query.

Doug wrote:

>I've used FP2000 (minor, static pages) and Access2000, but not together.
>Now I havd a db I want to use online. I am using aplus.net to host the
>site. According to there help files, I created a DSN connection. I then
>uploaded a copy of the database file (.mdb) into their db folder. When I
>connect to the server by ftp, I see db, logfiles, and wwwroot folder. When
>I publish my web through FP, the files go into the wwwroot folder. My db
>file is saved in the db folder. I don't have a copy of my .mdb file in my
>web folder on my computer.
>
>I haven't actually created the web page that will contain db information.
>The page will be based on a query. Should I create from within Access or
>FP? I am thinking FP.
>
>My real question is, how do I create the connection from within FP? I
>looked at the database results wizard, but I am not sure on what type of
>connection to select. Can anyone explain in simplified terms what I need
>to do, or is the answer a little more involved than I think? I've read
>here a little about DSN connections and DSN-less connections, but I am
>confused. According to aplus.net, saving the database file in the db
>folder protects it.
>
>I am editing the web files on my computer then publishing them using FP. I
>don't have a web server on my computer (XP Home).
>
>Also, my type of account (primoXR) can't use ASP.
>
>Any help appreciated.
>
>Thanks,
>Doug
>
>

Relevant Pages

  • Pass Thru Qry
    ... I can't seem to get a connection using the wizard for a pass through query ... Thank you in advance for your assistance. ...
    (microsoft.public.access.queries)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Update checking
    ... My thought was to use a simple query with a "username" param ... concurrency exceptions happen if the data you queried has ... > was and basically let the user work in a similar offline mode. ... Where does connection pooling come ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: OpenDataSource & stored procedure
    ... recognises the ODBC escape syntax. ... You shouldn't need the connection parameter since Word gets it from the ... return multiple result sets - enough to confuse software such as MS Query ... >>> The call works in MSQuery but won't return the data to Word. ...
    (microsoft.public.word.mailmerge.fields)