moving away from Access

[phil cunningham]

Hello again

I've set up the ASP.NET and access and everything is OK except when I have
the MDB file open with Access.

In this case the ASP.NET system wont open the file and reports the error
message

Could not use 'C:\CallidusWorld\App_Data\oakleafAccountsData.mdb'; file
already in use.

this only happens when Access is running a form open looking at the same MDB
file, when Access is closed the system works well.

Is there some fundamental problem with having both systems running at the
same time?

Thanks in advance for any help
Phil

 

[Brendan Reynolds]

Is the Access app 'split', that is to say, tables only in a 'back-end' data
MDB, forms and other objects and links to the tables in the data MDB in a
'front-end' application MDB?

 

[phil cunningham]

I have all the data tables in a seperate MDB and the main Access (Forms etc)
links these

I have another MDB with links to the same tables but it appears that when
Access open a form it is locking the MDB that contains the linked tables.
This prevents ASP.NET from opening them - I only need to read the data!

Many thanks for coming back so soon
Phil

 

[phil cunningham]

I've just noticed that this does NOT happen if I view the ASP.NET system via
Visual Web Developer 2005, only when viewing using IIS

So it may be related to IIS
I think I've set up the rights but it seems odd that it only fails when
Access has the tables open

Hope this helps
Phil

 

[Brendan Reynolds]

I haven't been able to reproduce this. Here's what I did in my attempts to
reproduce it. Possibly something in this list might provide some clue as to
why it is not working for you.

I created a new MDB, 'c:\usenet\asp_test_data.mdb'.

I imported into this new MDB all of the tables from the Northwind database.

I created a second new MDB, 'c:\usenet\asp_test_app.mdb'.

In 'asp_test_app.mdb' I created links to the tables in 'asp_test_data.mdb'.

In 'asp_test_app.mdb', I created a form bound to the linked Categories
table.

I gave the ASP.NET machine account read and write permissions on the
'c:\usenet' folder.

I created a new ASP.NET app with a datagrid control bound to the Categories
table in 'c:\usenet\asp_test_data.mdb'.

I executed the web page to confirm that it worked, and displayed the data,
without opening 'asp_test_app.mdb' in Access.

I closed the web page, opened 'asp_test_app.mdb' in Access, and opened the
form bound to the Categories table. I then executed the web page again, to
confirm that it still works and displays the data when 'asp_test_app.mdb' is
open in Access.

I closed VS.NET, and opened the web page by entering the URL in the 'Start,
Run' dialog, to confirm that it works and displays the data when opened
outside of VS.NET.

 

[phil cunningham]

Thanks for all the info so far - really appreciated

For my next step ...

I've put the whole system on to a second server also running Windows server
2003 and it works perfectly!

The problem only seems to occur on one server but not the other, ASP.NET
still refuses to open a database when Access has it open.

Is there some setting in IIS or even ASP.NET that may be causing a problem.
The only other thing I can think of is that on one system, Access is opening
the databases 'read-only' but I dont know how it would do this

Look forward to any more information - much appreciated.

Phil

 

[phil cunningham]

Success

I've checked the permissions on the database folder and allowed 'System' to
have full control and this seems to have cured it

1/ I am relieved

2/ I am puzzled - I thought the account IUSR... account was the one that IIS
used - why should the 'System' account make any difference.

Could someone point me in the diffection of definitive information about the
security settings I need for ASP.NET, Access and IIS

Many thanks for all the help in this

All the best
Phil

 

[Brendan Reynolds]

Running under the SYSTEM account is not recommended, Phil, for security
reasons. You might want to review the MSDN article at the following URL ..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000009.asp

 

[phil cunningham]

thanks again - I think we are about there now!

All the best
Phil