Accessing my Access Database

[pwtucker]

I have a database on your server, but when try to access my data access pages they still look for my c: drive. I have tried to change the connection string, but with no luck. Can some one give me a hand.

Also, is it possible to just let the mdb file reside on your server and connect to it like a network drive? This would be ideal, so I could use the forms instead of the data access pages.

Thanks in advance for anyones help

Paul[:(]

[bruce]

Can you post your code, its hard to help you without the details.

THanks



[b]quote:Originally posted by pwtucker

I have a database on your server, but when try to access my data access pages they still look for my c: drive. I have tried to change the connection string, but with no luck. Can some one give me a hand.

Also, is it possible to just let the mdb file reside on your server and connect to it like a network drive? This would be ideal, so I could use the forms instead of the data access pages.

Thanks in advance for anyones help

Paul[:(]
</blockquote id="quote"></font id="quote">

[pwtucker]

Okay...this could be part of the problem. I am not very knowledgeable in html or java. This is a new adventure for me using data access pages on a server outside our network. The goal is to share this database with an outside vendor. This was my solution, but did not realize going to an external server would be so difficult. Also, I would rather just be able to share the database with out having to use data access pages, but am not sure if this is even possible (connecting to the discountasp server via a network drive).

I already have the data access pages designed, but I am the only one who can access them. This might be of interest to, I am using Frontpage to work with this page. With that said, below is what I have.

This is the connection string that I have in the properties of the data access page. e:\web\bhamstreetl\htdoc\fpdb\bham.mdb

Here it is in the code. <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=e:\web\bhamstreetl\htdoc\fpdb\bham.mdb;Mode =Share Deny None;

Hope this helps and thanks for your help.

[bruce]

Is this ASP or ASP.net code?

If you are new to displaying data using scripting language, check out this tutorial

http://www.webwizguide.info/asp/tutorials/connecting_to_a_database.asp

[b]quote:Originally posted by pwtucker

Okay...this could be part of the problem. I am not very knowledgeable in html or java. This is a new adventure for me using data access pages on a server outside our network. The goal is to share this database with an outside vendor. This was my solution, but did not realize going to an external server would be so difficult. Also, I would rather just be able to share the database with out having to use data access pages, but am not sure if this is even possible (connecting to the discountasp server via a network drive).

I already have the data access pages designed, but I am the only one who can access them. This might be of interest to, I am using Frontpage to work with this page. With that said, below is what I have.

This is the connection string that I have in the properties of the data access page. e:\web\bhamstreetl\htdoc\fpdb\bham.mdb

Here it is in the code. <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=e:\web\bhamstreetl\htdoc\fpdb\bham.mdb;Mode =Share Deny None;

Hope this helps and thanks for your help.
</blockquote id="quote"></font id="quote">

[pwtucker]

This is neither ASP or ASP.net. I am using the data access pages in Access. Is there a way I can leave a copy of the database on multiple pcs c drive and use an odbc to connect back to your server?

[albatross_singh]

I think that you are trying to access the Access DB as if it were on a network share. If this is what you are trying to do, 2000 and XP machines allow mapping of network drives over IP. If your database is on a 2000 machine and you are using 2000 or XP, you should be able to map a drive on the client using WebFolders (WebDAV). The only catch here is that only one person can work on the database at a time.

Hope this helps.


[b]quote:Originally posted by pwtucker

This is neither ASP or ASP.net. I am using the data access pages in Access. Is there a way I can leave a copy of the database on multiple pcs c drive and use an odbc to connect back to your server?
</blockquote id="quote"></font id="quote"></font id="Verdana"></font id="size2"></font id="black">

[bruce]

By the way, singh's post does ring a bell.

WebDAV is not supported here. That might be the cause of the problem


[b]quote:Originally posted by albatross_singh



I think that you are trying to access the Access DB as if it were on a network share. If this is what you are trying to do, 2000 and XP machines allow mapping of network drives over IP. If your database is on a 2000 machine and you are using 2000 or XP, you should be able to map a drive on the client using WebFolders (WebDAV). The only catch here is that only one person can work on the database at a time.

Hope this helps.


[b]quote:Originally posted by pwtucker

This is neither ASP or ASP.net. I am using the data access pages in Access. Is there a way I can leave a copy of the database on multiple pcs c drive and use an odbc to connect back to your server?
</blockquote id="quote"></font id="quote"></font id="Verdana"></font id="size2"></font id="black">
</blockquote id="quote"></font id="quote">