Web-enabled Access Database question

Forum Moderators: phranque

Message Too Old, No Replies

Web-enabled Access Database question

How does it work?

Hiro

10:58 pm on Jun 30, 2004 (gmt 0)

Hi all,
I'm new to the site and I've looked everywhere else. I can't seem to make this work. What I'm trying to do is to make a Microsoft Access database that is accessable from the web.

I've already went through the normal "HTML design wizard" thing. The only problem is in the HTML code I get by default:

Data Source=C:\foo\bar\somewhere\database.mdb

That's well and good for me, but I need the database to point to a web address. I tried changing the database simular to this:

Data Source=http://www.somesite.com/data/database.mdb

..and I get all kinds of errors. Namely:
"Not a valid file name" and
"Data provider could not be initialized"

The http path is right, it just... doesn't work. Anybody out there know what I may be doing wrong, or perhaps a way to remedy this?

macrost

3:29 am on Jul 1, 2004 (gmt 0)

Welcome to WebmasterWorld Hiro!

One question, what language are you using for the connection to the database? This is going to be a server-side technology such as php or asp. Once we know, and see the code you are using to try and connect, we can help you out.

Hiro

4:22 am on Jul 1, 2004 (gmt 0)

It's an object of some type. The language appears to be XML. I'm basicly using Microsoft Access to build the html code, then polishing it up by hand. The problem lies nested in a param tag. Below is the tag..

Note the "Data Source=H:\Assett Tracking1.mdb" shortly after the <PARAM> tag begins. This is the problem. I need that to point somehow to an http address, but it gives me the above mentioned errors when I try to change the path to anything without a drive styled path. (such as C:\blahblah..). Any ideas?

<PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com:office:access">
 <a:DataSourceControl>
 <a:OWCVersion>9.0.0.4309</a:OWCVersion>
 <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=H:\Asset Tracking1.mdb;Mode=Share Deny None;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;</a:ConnectionString>
 <a:MaxRecords>10000</a:MaxRecords>
 <a:GridX>24</a:GridX>
 <a:GridY>24</a:GridY>
 <a:ElementExtension>
 <a:ElementID>AssetCategoriesNavigation</a:ElementID>
 <a:ConsumesRecordset/>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>AssetCategoryID</a:ElementID>
 <a:ControlSource>AssetCategoryID</a:ControlSource>
 <a:ChildLabel>AssetCategoryID_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:ElementExtension>
 <a:ElementID>AssetCategory</a:ElementID>
 <a:ControlSource>AssetCategory</a:ControlSource>
 <a:ChildLabel>AssetCategory_Label</a:ChildLabel>
 </a:ElementExtension>
 <a:GroupLevel>
 <a:RecordSource>Asset Categories</a:RecordSource>
 <a:DefaultSort></a:DefaultSort>
 <a:HeaderElementId>HeaderAssetCategories</a:HeaderElementId>
 <a:FooterElementId></a:FooterElementId>
 <a:CaptionElementId></a:CaptionElementId>
 <a:RecordNavigationElementId>NavigationSectionAssetCategories</a:RecordNavigationElementId>
 <a:DataPageSize>1</a:DataPageSize>
 </a:GroupLevel>
 <a:Datamodel version="0816">
 <a:SchemaRowsource id="Asset Categories" type="dscTable">
 <a:SchemaField id="AssetCategoryID" datatype="3" size="0" iskey="1"/>
 <a:SchemaField id="AssetCategory" datatype="202" size="50"/>
 </a:SchemaRowsource>
 <a:RecordsetDef id="Asset Categories">
 <a:PageField id="AssetCategoryID"/>
 <a:PageField id="AssetCategory"/>
 </a:RecordsetDef>
 </a:Datamodel>
 </a:DataSourceControl>
</xml>'""></OBJECT>