Re: Created on Access 2003, but.......................

David W. Fenton wrote:
Bri <not@xxxxxxxx> wrote in NyIag.170651$P01.126736@pd7tw3no:">news:NyIag.170651$P01.126736@pd7tw3no:

Actually, I connect to the MySQL database via MyODBC from an
Access frontend. I enter and maintain the data in this database.
The database is read by the users of it via ASP web pages. The
host allows for both types of connections. . . .


I've never heard of that setup. Normally web hosts only allow local
connections.

I can't seem to find a reference in their support area that I can quote from. I just downloaded MyODBC and put in the same connection info as they supplied for connecting via ASP and it worked. Never occured to me that they wouldn't allow it so I just did it.

I really don't see how an organization that couldn't afford a
Terminal Server (it can be functioning as a file server at the same
time) could afford the work it would take to engineer a remote app
like that.

Its a two person outfit. They have laptops, no server or network. The amount of data they will be sending across the internet won't be large, dozons of records per request at most. The app just has to make sure that it doesn't bring over any extraneous data, as any client-server app should do (no bound tables, just a query for the current record plus child records).

I agree that we did stray off topic, but the original comments I
posted were about the issues I had with the Access FE to the MySQL
BE. http://groups.google.ca/group/comp.databases.ms-access/tree/browse_
frm/thread/879a5bc7157cc3df/30fc044d5b6a5872?rnum=11&q=created+in+a
ccess+2003&_done=%2Fgroup%2Fcomp.databases.ms-access%2Fbrowse_frm%2
Fthread%2F879a5bc7157cc3df%2Fd82c8dc3869e9da2%3Ftvc%3D1%26q%3Dcreat
ed+in+access+2003%26#doc_30fc044d5b6a5872


I really don't believe you. I think you're fabricating.

That my original comments were on topic? Or that I have a functioning Access FE - MySQL BE over the internet app? Believe what you want but both are true. What reason would I have to lie about it? What proof do you require other than my word? I don't like the implication that I am making things up. I can prove everything I have stated in this thread.

--
Bri

.

Relevant Pages

  • Re: app vendor telling porkies?
    ... what I was thinking - that its a database issue. ... app with our own code which it is designed for. ... instructed us that to return connections back to the pool, ... I frequently find the real root cause ...
    (comp.lang.java.programmer)
  • Re: Basic application design
    ... You will need to look up Web Service in ASP.Net, ... Basically, as Spam Catcher said, you setup an interface to the database. ... The web service will then manage the actual database connections and pooling, ... You then build both a web page app for use in a browser, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
Loading