I have used Access to MS SQL Server on a web server. We had a Cold Fusion web site, but needed some internal reports. I created a DSN to the web server, and the situation worked nicely for over a year. You do have to setup the same DSN on each machine that will use the Access DB. TJ
--- In AccessDevelopers@yahoogroups.com, "AAP" <[EMAIL PROTECTED]> wrote: > Hey All, > > > > It seems to me that Access can use any DSN (User defined, System, and File) > which you can set up on any machine which has the ODBC Drivers installed. > Direct the DSN to the static address of the remote machine. Personally I > would establish the Oracle DB through the Administration Data Sources prior > to setting up ODBC in Access. If you already have the ODBC DSN set up for > another program then the set up is even simpler (this would mean that anyone > needing the DSN should already have it set up as well). As far as the syntax > to the connection string, I would use the ODBC to set it up. > > > > Carl > > > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Oakes > Sent: Wednesday, June 29, 2005 5:33 PM > To: AccessDevelopers@yahoogroups.com > Subject: RE: [AccessDevelopers] ODBC to internet database > > > > I'd be inerested in knowing how you're doing this, too. What is the syntax > of the connection string to an Access database on a remote machine? > > > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.968.6946 (C) > 713.583.7091 (F) > > > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Harold Glenn P. > Minerva, ECE > Sent: Wednesday, June 29, 2005 2:41 PM > To: AccessDevelopers@yahoogroups.com > Subject: RE: [AccessDevelopers] ODBC to internet database > > sure...you can even do this: > > > > ACCESS ~ INTERNET ~ MySQL > > ACCESS ~ INTERNET ~ MS SQL Server > > > > But I have not tried Oracle. :) > > > *********** REPLY SEPARATOR *********** > > On 6/29/2005 at 10:24 AM George Oro wrote: > > Harold, > > > > I will appariciate if you could share it.. > > > > George > > > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] Behalf Of Harold Glenn P. > Minerva, ECE > Sent: Wednesday, June 29, 2005 7:51 PM > To: AccessDevelopers@yahoogroups.com > Subject: RE: [AccessDevelopers] ODBC to internet database > > Access - Internet - Database => OK, I've tried it, as long as you can > connect to the database via ODBC access can open it. > > > *********** REPLY SEPARATOR *********** > > On 6/28/2005 at 7:24 AM Tom Oakes wrote: > > I should have specified - I don't think you can do it with an Access > backend. I frequently use an Access frontend and a remote SQL Server > database as the backend. > > > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.968.6946 (C) > > > > > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] Behalf Of Angelo Antonino > Sent: Tuesday, June 28, 2005 12:57 AM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] ODBC to internet database > > Hi, > > > > Has anyone had any expereince linking an Access frontend to a database on a > webserver, through the internet, using ODBC? > > > > I'd be interested to hear of people's experiences? > > > > Thanks, > > Angelo > > > > > Please zip all files prior to uploading to Files section. > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > Harold Glenn P. Minerva, ECE > > Sr. MIS Researcher > > Cebu Port Authority > > CIP Complex, North Reclamation Area, Cebu City > > Telephone No.: 63 32 2321461 loc 36 > > > > > Please zip all files prior to uploading to Files section. > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > Harold Glenn P. Minerva, ECE > > Sr. MIS Researcher > > Cebu Port Authority > > CIP Complex, North Reclamation Area, Cebu City > > Telephone No.: 63 32 2321461 loc 36 > > > > > Please zip all files prior to uploading to Files section. > > > > > Please zip all files prior to uploading to Files section. > > > > > SPONSORED LINKS > > > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+acc ess+database&w1=Microsoft+ > access+database&w2=Microsoft+access+developer&w3=M icrosoft+access&w4=Microso > ft+access+database+design&w5=Microsoft+access+data base+training&c=5&s=163&.s > ig=TjCMMZaJBtroyAQ8dznVsQ> access database > > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+acc ess+developer&w1=Microsoft > +access+database&w2=Microsoft+access+developer&w3= Microsoft+access&w4=Micros > oft+access+database+design&w5=Microsoft+access+dat abase+training&c=5&s=163&. > sig=oqhFqsmlUZ5Zh6pQgnvTDQ> access developer > > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+acc ess&w1=Microsoft+access+da > tabase&w2=Microsoft+access+developer&w3=Microsoft+ access&w4=Microsoft+access > +database+design&w5=Microsoft+access+database+trai ning&c=5&s=163&.sig=MMKzpe > wSlzpK714XaCARAQ> access > > > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+acc ess+database+design&w1=Mic > rosoft+access+database&w2=Microsoft+access+develop er&w3=Microsoft+access&w4= > Microsoft+access+database+design&w5=Microsoft+acce ss+database+training&c=5&s > =163&.sig=ecBsMdKeZw8i4_1kkC6epA> access database design > > Microsoft > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+acc ess+database+training&w1=M > icrosoft+access+database&w2=Microsoft+access+devel oper&w3=Microsoft+access&w > 4=Microsoft+access+database+design&w5=Microsoft+ac cess+database+training&c=5 > &s=163&.sig=FHk4Yggbv_zB-TsXvHyeig> access database training > > > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] om?subject=Unsubscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of Service. > > > > _____ Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
