Re: Access and WebDNA

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 44651
interpreted = N
texte = Right - see this would be way easier if you were using a PC or I newanything about Macs.I think Macs have issues when it comes to making ODBC connections tomicrosoft databases.Access is in fact a little harder to... err... access over IP because itsnot meant to be used this way.A horribly dodgy workaround would be to write a macro on the Access box toexport all the tables as flat files then just crab those and treat them likea webcat db. this isn't as hard as it sounds but you have the whole -non-live problem when i comes time to look at the data on your intranet.Or, as you said - find somebody who knows a little about ASP, SQL and getthem to write a page that select *'s from each table and display the resultsnicely for you to collect with a tcp connect.It would just be soo much easier if we could all just get along.----- Original Message -----From: Donovan Brooke To: WebCatalog Talk Sent: Friday, November 01, 2002 10:38 AMSubject: Re: Access and WebDNA>>> Andrew Simpson wrote:[snip]>> >> > If you can map to the .mdb file accross the network then you should beable> > to make an ODBC connection to the file from one machine to another.> >> > Once you have the ODBC you shouldn't need to have to do anything with> > TCPconnect and you shouldn't have to touch the Access Box.>> Thanks Andrew...> Since I'm new to this I haven't really got an idea on how to start besides> knowing the IP address. The only way I would know how to map> to it would be to mount a volume and use a alias (shortcut) to access it.> I don't think this is an option. The database is running on an NT but it> is not located within the service for Macintosh directory.>> Can you give me an idea of how I would go about mapping to it?>> Thanks,> Donovan>> >> >> >>> -- Donovan D. Brooke> Administrator of IT/> Assc. Art Director> Epsen Hillmer Graphics> HG Professional Forms>>>>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Access and WebDNA (Alain Russell 2002)
Re: Access and WebDNA (Donovan Brooke 2002)
Re: Access and WebDNA (Andrew Simpson 2002)
Re: Access and WebDNA (Donovan Brooke 2002)
Re: Access and WebDNA (Andrew Simpson 2002)
Access and WebDNA (Donovan Brooke 2002)

Right - see this would be way easier if you were using a PC or I newanything about Macs.I think Macs have issues when it comes to making ODBC connections tomicrosoft databases.Access is in fact a little harder to... err... access over IP because itsnot meant to be used this way.A horribly dodgy workaround would be to write a macro on the Access box toexport all the tables as flat files then just crab those and treat them likea webcat db. this isn't as hard as it sounds but you have the whole -non-live problem when i comes time to look at the data on your intranet.Or, as you said - find somebody who knows a little about ASP, SQL and getthem to write a page that select *'s from each table and display the resultsnicely for you to collect with a tcp connect.It would just be soo much easier if we could all just get along.----- Original Message -----From: Donovan Brooke To: WebCatalog Talk Sent: Friday, November 01, 2002 10:38 AMSubject: Re: Access and WebDNA>>> Andrew Simpson wrote:[snip]>> >> > If you can map to the .mdb file accross the network then you should beable> > to make an ODBC connection to the file from one machine to another.> >> > Once you have the ODBC you shouldn't need to have to do anything with> > TCPconnect and you shouldn't have to touch the Access Box.>> Thanks Andrew...> Since I'm new to this I haven't really got an idea on how to start besides> knowing the IP address. The only way I would know how to map> to it would be to mount a volume and use a alias (shortcut) to access it.> I don't think this is an option. The database is running on an NT but it> is not located within the service for Macintosh directory.>> Can you give me an idea of how I would go about mapping to it?>> Thanks,> Donovan>> >> >> >>> -- Donovan D. Brooke> Administrator of IT/> Assc. Art Director> Epsen Hillmer Graphics> HG Professional Forms>>>>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

DOWNLOAD WEBDNA NOW!

Re: Access and WebDNA

2002

Top Articles:

Related Readings: