[AccessD] MDB on the web

Jim Lawrence accessd at shaw.ca
Thu Feb 14 14:59:41 CST 2008


Hi Gustav:

If they could be guaranteed a stable environment but I am not sure they
would be able to have that with a public hosting provider...

Server.MapPath("/mydatabase.mdb") might work but maybe MS SQL Express is a
better solution.

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, February 14, 2008 1:05 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] MDB on the web

Hi Jim

Well, if you are able to use a standard ODBC connection, the database
converter wizard in Access will do the routine work for you creating the
tables in the server, copying the data, and relinking to the new source.
Then you may need to modify some queries in the app with the parameter
dbSeeChanges - that may all that is needed to do.

/gustav

>>> accessd at shaw.ca 14-02-2008 09:55 >>>
Thanks Gustav for the in sites to sites. I knew that an MDB DB for a web
site would be a temp fix and maybe it is the time to see if the client is
willing to pay for migration to MS SQL...

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, February 14, 2008 12:24 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] MDB on the web

Hi Jim

The short answer is none. If at all possible it will not be reliable as the
connection to the site easily can be lost.

The recommended method is to use a database engine like SQL Server or MySQL
which at most decent hosting companies is available for a fair if not low
additional cost. Then connect to that. The simple method is to use ODBC, and
- if the database is moved to another host - all you need to do is to change
the IP address of the connection.

/gustav

>>> accessd at shaw.ca 14-02-2008 07:34 >>>
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




More information about the AccessD mailing list