[AccessD] MDB on the web

Hi Shamil:

I will try and convince the client to go MS SQL... speed, reliability and
features. 

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Thursday, February 14, 2008 9:51 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MDB on the web

Hi Jim,

If:

- your (client's) mdb is local to the web app and
- you develop ASP.NET 2.0 web apps

Then you can use relative references to MS Access mdb within .aspx web pages
like that:

<asp:AccessDataSource 
    DataFile="~\App_Data\nw.mdb" 
...

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, February 14, 2008 9:34 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MDB on the web

Hi All:

What connection method and code do you use to connect to an MDB DB on your
web sites? (I have only used MS SQL in the past and that is fairly straight
forward.) 

My client had originally hard coded the MDB location in a Global file
variable and used the DSN-less Database Connection method but that will not
work now that he is planning on migrating to a public internet hosting
company. Is there a way to pre-setup an ODBC Database Connection that would
work on any location?

Any insights and coding samples would be greatly appreciated.

TIA
Jim    

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com