how to link access database to asp dynamic web page

  • Thread starter Thread starter Haroon
  • Start date Start date
H

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.
 
Haroon said:
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.
Click to expand...

Are you talking about an ASP.NET Dynamic Data Web page?
 
Haroon said:
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.
Click to expand...

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

Pete
 
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.
 
Haroon said:
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.
Click to expand...


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.
 
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.
 
Back
Top