Problems MS Access database files and ASP.NET 2.0

[Richard Finnigan]

Hi

I'm having real difficulties getting a very simple access database file to
show its data in visual studio data controls with various error messages
occuring. I've changed the permissions on the app_data folder for NETWORK
SERVICE.

Inserting a record seems to be particularly difficult though reading from an
Access database seems to be possible at the moment. I've done the obvious
things like using the Advanced SQL Generation options and putting in a
primary key field into the Access database table.

I've been using Visual Web Developer though I will soon be switching to
Visual Studio.

Is it actually advisable or possible to use MS Access database files in this
environment ?

Any useful advice would be gratefully recieved.

 

[Guest]

It is possible to use MS Access, but with SQLEXPRESS being a free download
and offering basically the entire SQL Server 2005 engine including CLR-hosted
assemblies and Reporting Services, I find it difficult to imagine scenarios
where it would make sense any longer. If what you need is a very simple,
lightweight, zero-install database, look into SQLite.
Peter

 

[Richard Finnigan]

It is possible to use MS Access, but with SQLEXPRESS being a free download
and offering basically the entire SQL Server 2005 engine including
CLR-hosted
assemblies and Reporting Services, I find it difficult to imagine
scenarios
where it would make sense any longer. If what you need is a very simple,
lightweight, zero-install database, look into SQLite.
Peter

Thanks for the advice RF

 

[Mike Lowery]

Thanks for the advice RF

If you're considering DB options, check out mySQL as well. Full blown DBMS
(unlike SQLite) and free:
http://www.mysql.com/

 

[Guest]

Mike,
With all respect, if somebody is using the .NET Platform and SQLExpress is
free, what rationale would they possibly have for MySql? Does it have
Reporting Services and FullText search? Can you write SQL CLR stored
procedures in it? Have you looked at some test scenarios as to relative query
performance with stored procedures?

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com

 

[blaplante]

Hi

I'm having real difficulties getting a very simple access database file to
show its data in visual studio data controls with various error messages
occuring. I've changed the permissions on the app_data folder for NETWORK
SERVICE.

Inserting a record seems to be particularly difficult though reading from an
Access database seems to be possible at the moment. I've done the obvious
things like using the Advanced SQL Generation options and putting in a
primary key field into the Access database table.

I've been using Visual Web Developer though I will soon be switching to
Visual Studio.

Is it actually advisable or possible to use MS Access database files in this
environment ?

Any useful advice would be gratefully recieved.
--
Richard Finnigan
Work Website http://www.ict-action.com
Homepage http://www.richardsthings.co.uk
Hobby Webpage http://www.closeimage.co.uk

I experienced similar symptoms: Using MSAccess 2003 & ASP.Net 2005 w/ C#. After several hours of reading posts, verifying directory & file permissions, table primary keys, etc.,
I discovered that the application can update the database when run as a file based web from within Visual Studio (Web Developer), but not when it runs as a web-based application. That is, it runs when I open C:\inetpub\wwwroot\myweb , but it doesn't run when I open it as http://localhost/myweb .

Problem is RESOLVED for me. It turns out, I couldn't change the security previously because I wasn't seeing the REAL security tab.
See: http://www.4guysfromrolla.com/aspfaqs/ShowFAQ.asp?FAQID=107

From 4GuysFromRolla.com Link above
WHAT IF THE SECURITY TAB DOESN'T APPEAR IN MY FILE/FOLDER PROPERTIES?

If you are using NTFS--and especially if you are using WindowsXP--then try the following steps:

(1) Bring up "Windows Explorer" or "My Computer" in a window.
(2) Click on the "Tools" menu in that window.
(3) Click on the "Folder Options" menu item.
(4) Click on the "View" tab.
(5) Find the checkbox labelled "Use simple file sharing (Recommended)"
(6) UNCHECK that checkbox!(7) Say OK. Close the dialog. Close the window.
(8) You might have to log off and back on again. I didn't, but others have reported they had to.
(9) Now go view the properties of a folder or file with Windows Explorer/My Computer and see if the Security tab isn't there!