|
Hi fellas. I am trying to do a simple registration system with MS Access.
Currently I am using Access 2003, along with C# is VS.NET 2003.
The thing is, whenever I am executing the database connections part, I get this error:
The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data. <br />
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br />
<br />
Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\SamsTestData\Member.mdb'. It is already opened exclusively by another user, or you need permission to view its data.<br />
I have absolutely no idea what is going on. I tried googling the web, however I am clueless, as well as where I should start. I am guessing I have to tinker with some settings, but where??? 
Anyway help would be greatly, greatly appreciated! THANKS!!! 
|
|
|
|
|
A few clues:
1) Is the MDB open in Microsoft Access IDE, typically any table in its design view? If yes, then preferably close them.
2) http://support.microsoft.com/kb/174943[^]
3) Is MDB Path writeable by ASP.NET?
|
|
|
|
|
Thanks for your swift reply. I have closed the MS Access application when executing the page. I guess that is good enough?
I did went to the link you provided before I asked for help in here. However I just baffled by the terminology that's in there.
How do you determine whether the MDB path is writable in ASP.NET? Is the settings set in Access, VS.NET 2003, or from the Internet Information Services in the Administrative Tools of the Control Panel?
Thanks a bunch and looking forward to your reply!
|
|
|
|
|
do u have the Database already opened somewhere??
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Thanks for the swift response.
Nope, I had MS Access closed when the webpage is being executed. So I am just perplexed at what could be the culprit.
Any other ideas? Thanks!!!
|
|
|
|
|
Is this File accessible by all kind of users??
may be u have some permission problems. Have you read that article mentioned by another friend of mine
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Thanks for the reply.
Which article are you referring specifically?
I'm stumped whether I should be looking at Access, VS.NET 2003, or the IIS in the Administrative Tools...or is it somewhere else I should be looking at?
Thanks again.
|
|
|
|
|
http://support.microsoft.com/kb/174943[^][^]
Thats the one I was talking abt
well first you should look for permissions on the file itself u know right click the file>properties>permissions... make it accessible by the 'Everyone' Account. you should also keep an eye on the folder permission in which taht file resides.
if its still not helping the refer to IIS which is some thing I dont know too much about :->
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Infernojericho wrote: An unhandled exception occurred during the execution of the current web request
Ok, this seems to be an ASP.NET issue, so this is not the right forum.
Anyway, from the message given, I would say that ASP.NET doesn't have the necessary permissions to open the file. The folder in which the file is located was, I suppose, created by you, so by default, ASP.NET doesn't have any permissions set for this folder. You need to look into that matter by checking the properties->Security tab of the folder and making sure that the local user ASPNET has permissions to at least read the file. You would also need the write/modify permissions to be able to write into the file.
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
That was a helpful reply. Finally got it working. And of course, gave it a 5-star vote. Thanks again!
|
|
|
|
|
Hey,
I want to make a frontend for application that allready exists, and make it more userfriendly. Like for instance, many applications work with LAME.exe and/or LAME.dll. My questions are:
a) How do I best send parameters to these exe's? Plain usage and use System-call on exe with added parameters??? (no idea, just a guess)
b) All those other applications that use an exe, never make the exe 'pop-up', while I was thinking to use a System-call, and send parameters to the exe. That would open it (and a doslike window) and inject the parameters to the now open exe. But with a window visible. How else could it be done?
b2) Can I internally link the exe in my project, so it works like a process in the background, and my GUI awaits an ending state of the process running in teh background? Is that possible and how it should be done in a neat way?
Some pointers or things to look for are enough, I don't want entire pieces of code. As a beginner, I just don't know where to start, that's all.
|
|
|
|
|
You will be able to get what you need if you use Process class.
a)You can set Arguments property of ProcessStartInfo instance and then pass it to Process instance
b)You can specify Hidden for WindowStyle property of ProcessStartInfo or set CreateNoWindow property to true
c)I don't know what you mean by linking but if you start process by using Process class then you can retrieve its output if you set ProcessStartInfo's RedirectStandardOutput property to true
|
|
|
|
|
Hello there. At the moment im currently creating some code to query active directory. I am listing the users that are on a particular domain. howevr the results are over 15,000 and mine bottoms out at 1400.
I get an error message saying that i should use message pumping durin long processes but i have no clue what that is? Can anyody help?
Regards,
Mark
|
|
|
|
|
deviao wrote: i should use message pumping durin long processes but i have no clue what that is?
Have a look at this[^] article.
|
|
|
|
|
I'm trying to use Linq in VS2005 on .NET 3.0, but I think I'm missing references. Could someone please tell me which assemblies to reference ?
Johan Lombaard
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein
|
|
|
|
|
I think you need Visual Studio 2008 for that. And LINQ is part of .NET 3.5
|
|
|
|
|
You can use (bits?) of LINQ in VS2005 with the March CTP I think, not as capable as VS2008 (haven't tried) but I think because the "add-on" for VS2005 does not update the framework (as far as I know) you don't get all the benefits of LINQ such as the var keyword, etc. I might be mistaken since I haven't played with it much.
|
|
|
|
|
Yeah, if it isn't working for you now, wait until release unless you are really dedicated  I think only a handful of ISVs are fully supporting LINQ right now.
|
|
|
|
|
It's odd I was really tempted by LINQ to begin with for one particular project I was working on but because it wasn't release (well perhaps for MS it was) quality I couldn't justify it. I thought to myself I should really learn it, thought the same about WPF but since I haven't had a decent project to get started with either I've become quite interested in ASP.NET as it's something I haven't done alot of that type of programming since I come mainly from an embedded background.
Perhaps once Orcas is released I shall have a proper play.
|
|
|
|
|
I've been following it because it would be a really useful addition to our Diamond Binding product. I'm not really into managing long beta periods
|
|
|
|
|
i have 3 different applications
i want a single setup project for all the three applications
three applications are different
1)windows application
2)web application
3)web application
|
|
|
|
|
Hi, all
I have a question about using DataGridView.
Could you write me a code sample how to get and set SelectedItem in Combobox column in DataGridView
Here is the code i use to create a new row
DataGridViewCell dgvc = datagrid.Columns[0].CellTemplate;
datagrid.Rows[index].Cells[0].Value = dgvc;
in CellTemplate two items
Fast
Slow
and it's not clear for me how to set 'Slow' item programmatically
i've tried
((ComboBox)(datagrid.Rows[index].Cells[0].Value)).SelectedIndex = 1;
((ComboBox)(dgvr.Cells[0].Value)).SelectedIndex = 1;
((DataGridViewComboBoxCell)(datagrid.Rows[index].Cells[2].Value)).SelectedIndex = 1;
but it throws exceptions
What should i do?
|
|
|
|
|
hi
i can upload my xml into database easily
but i am getting a problem when the xml tag is a keyword(like desc,double)
saying syntax error in insert into command....
in general insert if keyword canbe changed like [keyword]
but i am not coming accross insert statement when i am using da.update(table)
please help me
|
|
|
|
|
plz give some code and show us how ur inserting the data
Rocky
You can't climb up a ladder with your hands in your pockets.
Follow this rule
Arrive. RAISE HELL. Leave.
|
|
|
|
|
have an xml
i am able to change into data table
and insert into database also...
StringReader xmlsr3 = new StringReader(region);
dset3.ReadXml(xmlsr3, XmlReadMode.IgnoreSchema);
OleDbDataAdapter da3 = new OleDbDataAdapter("select * from drregion", m_Conn);
OleDbCommandBuilder cb3 = new OleDbCommandBuilder(da3);
da3.Update(dtab3); dtab3 = dset3.Tables[0];
like this it gets updated
now the problem is when xml string has a keywords (of databases)
while updating into database that is in the last statement
there is an error saying insert into syntax error
i need to change the
ex: keyfield-desc
to [desc] (i could nt do it in xml ) there was another error if i do that
how can i do this
or is there any other way....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
