how to link access database to asp dynamic web page

[Haroon]

hi

i would like to use access database for storing/retrieving data from my
website instead of oracle sql server database as it is quite basic and simple
data management.

is there a way of doing this?

many thanks in advance.

 

[Mr. Arnold]

hi

i would like to use access database for storing/retrieving data from my
website instead of oracle sql server database as it is quite basic and simple
data management.

is there a way of doing this?

many thanks in advance.

Are you talking about an ASP.NET Dynamic Data Web page?

 

[Pete Hurst]

i would like to use access database for storing/retrieving data from my
website instead of oracle sql server database as it is quite basic and
simple
data management.

You can use a connection string like this:
DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=path/to/database.mdb;

Pete

 

[Haroon]

yes i want to build asp web page to show data from ms access database.
also add/remove data from webpage when user clicks add/delete button/options
cheers.

 

[Mr. Arnold]

yes i want to build asp web page to show data from ms access database.
also add/remove data from webpage when user clicks add/delete button/options
cheers.

Well, ASP.Net Dynamic Data Web site supports Linq-2-SQL MS SQL Server
and it supports ADO.NET Entity Framework an ORM solution. ADO.NET EF
supports MS SQL Server and several other databases, but it doesn't
support MS Access.

If I recall, should be able to upload Access data into SQL Server.

 

[Haroon]

thanks,
bascially i want to build a web page in asp to show data from ms access
database, also be able to add/delete data from the website, without going to
ms access database.

also want a search and sort options on the web page.

many thanks.