Database connection in Studio

[comblitz]

Hi, I hope someone can help.

On my Index.aspx (start page), I created an OleDBConnection and put the following Connection String:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WEB\MYDATAFILE.MDB;

So far so good, I realize that E is on the server and not my local machine. That is where the problem begins. I then try to add an OLEDBDataAdapter. The first question the wizard asks for is data connection. The pull down provides all the active data connection I currently have configured in Studio. So, I click New Connection, and realize this is not where I should be.

Is there no way to remotely access the .mdb file and create tables and queries with a user friendly tool such as MSAccess?

The goal of my effort was to populate a datagrid with data (that isn't even in the .mdb file yet).

Any ideas?

[bruce]

I don't believe you can connect to Access remotely

However, your problem can be resolve rather easily.

1) you can either change the path to the correct path to your DB. You can find you path in the account info section in the control panel

2) you can use server.mappath

Check out this post

http://forum.discountasp.net/topic.asp?TOPIC_ID=21

[b]quote:Originally posted by comblitz

Hi, I hope someone can help.

On my Index.aspx (start page), I created an OleDBConnection and put the following Connection String:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WEB\MYDATAFILE.MDB;

So far so good, I realize that E is on the server and not my local machine. That is where the problem begins. I then try to add an OLEDBDataAdapter. The first question the wizard asks for is data connection. The pull down provides all the active data connection I currently have configured in Studio. So, I click New Connection, and realize this is not where I should be.

Is there no way to remotely access the .mdb file and create tables and queries with a user friendly tool such as MSAccess?

The goal of my effort was to populate a datagrid with data (that isn't even in the .mdb file yet).

Any ideas?
</blockquote id="quote"></font id="quote">