Re: VS 2008 Data Access Issues

If a website:
The permissions you have to watch are the permissions for the account that ASP.NET runs under. If it cannot create a file in the directory or access the Access file, you will have a failure. The reason for write on the folder is the lock file is created when someone opens the database file, even from a website.

Otherwise:
Ensure you have all rights to write in the folder and non of your code is impersonating anyone else.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"Wesley Peace" <WesleyPeace@xxxxxxxxxxx> wrote in message news:O%23jIQspKJHA.5692@xxxxxxxxxxxxxxxxxxxxxxx
Connection string is pretty generic and doing a preview on the data does ope the table successfully. So I am able to access the database but only in design mode. I also tested the connection so I know that is working.

This is sitting on my desktop so permissions should not be an issue. I've also tried recreating this in VB and on a different machine. Believe it or not I tried SQL Compact edition and noticed the same problem.

An interesting note is in prior versions of VB I was able to drag the tables over to the form. Now I'm not. The Walktrhrough docs say this is possible.

I'll check the latter two items again, but I'm the only one using this database and the machine it's sitting on.



"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote in message news:eIJ3nhoKJHA.4280@xxxxxxxxxxxxxxxxxxxxxxx
First place to check is the connection string. Second is permissions on the Access file and directory it sits in. Third is to make sure nobody has the database open, or it is set up for multiple users.

If that does not work, post more.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"Wesley Peace" <WesleyPeace@xxxxxxxxxxx> wrote in message news:%23uP1mToKJHA.456@xxxxxxxxxxxxxxxxxxxxxxx
I'm an occassional programmer who has been playing around with C#.

I've built database applications before, but running into problems with C# and using data access controls to do a simple thing like display the data in the datagridview control.

I'm using an Access database as the backend data store and I am able to preview the data in the tables in design mode but when the application runs no data is displayed. The datanavigation control shows no records either and when I attempt to add a record it is not saved.

I know I'm missing something, but I'm at a lost at this point. A search of MSDN doesn't appear to help. It appears I'm doing everything right.

VS 2008
C#
Jet 4.0
Access 2007 database


Thoughts





.

Relevant Pages

  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Active directory corruption
    ... default web site and copied the permissions to all the child ... as it may not be the database that is the problem. ... prompt, use the ESENTUTL to check the integrity of the database. ... To recover the database type the following at the command prompt: ...
    (microsoft.public.windows.server.sbs)
  • Problem is w/ .ADP..Re: SQL db Permissions for users not working
    ... You do not have SELECT permissions on the ... SysObjects system table in the database. ... figured out that qualifying the database owner (dbo in my ... >> I feel that the object owner is not dbo, ...
    (microsoft.public.sqlserver.security)