blip

I have built a website that incorporates a simple 'news' section using ASP and an MS Access database. I now need to duplicate the site and upload it to 2 separate domains but I want all 3 sites to pull up data from just one database file sat on the original domain so I don't have to upload new articles three times, or have to maintain three versions of the database.

Is it possible to have a website pull up data from an Access database sat on a different web domain?

David_Wallis

depends on how your connecting to the database.. where the sites are hosted.. if they are hosted on the same box then you could do it by just having the dsn / recordset point to the same db in a folder accessible by all three sites..

wouldnt recomend that sort of thing though.. dunno about record locking between three sites with access.

David

blip

The site is for a client. They will just set up two new domains with their existing ISP. I don't know whether the three sites will physically be sat on the same server on not? If not does that mean it isn't possible to have all three sites querying the one db file?

The news tool is one I got off the web rather than writing myself. It uses the following type of connection string held in a single 'connection.asp' file:

-------------------
Set news = Server.CreateObject("ADODB.Connection")

news.open "driver={Microsoft Access Driver(*.mdb)};dbq=E:\wwwroot\mysitename\db\news.m db"
-------------------

Also what do you mean by record locking? Sorry to be ignorant but I'm new to database issues

NWMark

Record locking is when the database will lock a record that is being viewed / used by one person so another person cannot view/change the same record.

Happens in Access a lot, Access is crap for multi-user databases, as it creates loads of network traffic and has the record lock issue.

Mark

FrenchBoy

If you're expecting even moderate traffic, then i'd reccomend you get your DB away from access!!!

access has a nasty habit off corrupting very frequently when under heavy load. as mentioned above it has serious locking issues aswell. speak to the ISP, they will very likely be able to give you 'access' to a real database like SQL server (for a fee i'm sure) which will be a lot more reliable and able to cope with heavy use.