dbml error for Access database

[Bobby Edward]

Created a new Access mdb file. Created a Data Connection in Server explorer
for it. Created a new "LINQ to SQL Class". When I try to drag/drop a table
into the designer I get this error:

THE SELECTED OBJECT(S) USE AN UNSUPPORTED DATA PROVIDED.

Any idea why? Thanks!

 

[Mary Chipman [MSFT]]

Jet doesn't support LINQ to SQL. You need to use a SQL Server
database.

--Mary

 

[Cor Ligthert[MVP]]

For the Jet db (the actual name of the only db in past used in access) is
Linq to AdoNet

http://msdn2.microsoft.com/en-us/library/bb399360.aspx

Cor

 

[Bobby Edward]

Does anyone know what it can comfortably and realistically handle (in terms
of concurrency on a website)?

 

[Mary Chipman [MSFT]]

LINQ to ADO.NET encompasses two technologies, LINQ to SQL and LINQ to
DataSet, which allows for querying a DataSet. For more information,
seeLINQ to DataSet:
http://msdn2.microsoft.com/en-us/library/bb386977.aspx.

--Mary

 

[Mary Chipman [MSFT]]

If you are creating a Web application, then SQL Express would be a
much better choice than Jet, which is designed for the desktop, not
the Web. You can get more information from SQL Express Books Online at
http://msdn2.microsoft.com/en-us/library/ms165588.aspx.

--Mary