I have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.
How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#
Here's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
How can I move records from one table to another in Microsoft Access?. I would like to be using an sql.
View 4 RepliesFor some reason neither SQL managment studio nor import and export wizard works on my friends network due to some security policy
i asked a question about OSQL two days ago and StackOverflow guys told me it is going to be obselete and that i should use SQLCMD instead.
to cut long things short my question is very precise:
using SQLCMD..1-need to import and export command from AND to MDB/MDF
2-need attach / detach commands
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
i want to update row using gridview row updating , but it couldn't change anything in table . Here is my code:here Id is autonumber id my access DB.
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string Id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
[code]...
how to display image files which have been stored in Access 2007 as "attachments". The files are already in place as attachments to the database, and would be difficult to move in bulk to individual files. To store and call them individually by filename would have been my first choice, but they are already in place as attachments. At any rate, I have no problem connecting to and querying the database in asp.net for other fields, but have been unsuccessful in displaying these jpeg attachments.
View 4 RepliesI made a project to use the access membership provider from [URL] and it works. But I need to edit my database but when I configure my database, I cannot see the tabel, I can only see the queries in mdb file. when I select the field from query, I am unable to update it. My code is as follows:
[Code]....
Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?
I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.
I want to retrieve a single column from a table in a database(ms access) and then the value retrieved has to be converted to a string!!
View 4 RepliesI simply want to create one file and then delete it, means I want to access one file subsequently. I am getting the very familiar error as shown in title. (Process can't access the file,) I have tried using file stream and all other stuff that I found from Googling but no success so far. Does any body have small and neat solution? in short, I would like to run the following statements without any error.File.Create("C:\hsp1.txt");
File.Open("C:\hsp1.txt", FileMode.Open, FileAccess.Read, FileShare.None);
i have an asp.net application
c# code
i have adtabase in access and i craete adatset from it
i want to create excell file
Iam facing the problem with creating the Data Access layer using Dataset.xsd file and How to access the data from the file.
View 2 RepliesIs there a way to give users the capability to download an on-line table produced via gridview to an excel file (other than by copy/paste)?
View 3 Repliesi am building a member management site for a sports club, i have all the usual feilds
lastName, firstName, address1, address2, address3 ....
but they also want a photo
when i first made the DB i used access 2010 which uses the 2007 file type which supports attachments, however asp.net doesnt support the 2007 format. and the 2003 file type doesnt support attachments, i assume i use the OLE object data type but i have no idea how i get my aspx page "new.aspx" to upload an attachment. plus i want to restrict the file type to *.jpg
im not sure if this question qualify for getting started topic however here is what im trying to do:ive an access database with a table (no data) i wish to duplicate the table lets say tabOrigin with a different name; as since the table is empty i just want to duplicate the structure; fields name, size, type etc
View 5 Repliesi am facing some problem in update, edit and even create new data into my access database using data detail view. i am using microsoft visual web developer 2008, i can do the same when sql server database were to tore the data. but when i try to do the same using access database, an application error. may i know whats going wrong? and how to solve this problem?
View 7 Repliesi just wanted to know how to perform back up and restore of Ms Access database on a folder on the remote server through c# code.
View 1 RepliesIs there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I am writing an application on my PC to insert record on a Microsoft Access database on another pc that has static ip address remotely.I can ping the remote address of the PC that I want to access without problems. The access database is in the folder c:inetpubwwwrootdb.mdb.
I have the code below but when I run it I am getting the following error:
error on ther server the object model couldnšt be found
OleDbException 0x800a2011
<%@ LANGUAGE = VB Debug="true" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Net.Mail" %>
<%@ Import Namespace= "System.Web.UI.WebControls.Menu" %>
<%@ Import Namespace="System.Data" %>
<script Runat="Server" language="VB">
public sub button_click(s as object,e as EventArgs)
dim ssql as string
dim strconn,objconn,rs,dbcomm
Dim ds As New DataSet
Dim da As OleDbDataAdapter = New OleDbDataAdapter
objconn=new oledbconnection("Provider=MS Remote; Remote Server=http://196.45.161.123; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\db.mdb;Persist Security Info=False")
objconn.open ()
dbcomm=New Oledbcommand("employee",objconn)
dbcomm.commandtext="insert into employee values ('mostafa',7,'tanzania')"
dbcomm.Connection = objconn
dbcomm.ExecuteNonQuery()
objconn.close ()
end sub
</script>
<html>
<Head>
</HEAD>
<BODY BGCOLOR="White" TOPMARGIN="10" LEFTMARGIN="10">
<form Runat="Server">
<asp:textbox id="t1" Runat="Server" text="type" />
<asp:button id="b1" Runat="Server" onclick="button_click" text="clickme" />
</form>
</BODY>
</HTML>
I am planning to start learning asp.net mvc. And also I want to learn Microsoft's Data Access application block. But I dont want to waste time in MDAC block if theres a better option to go for, or if MVC provides any good feature than MDAC. As I have heard MVC architecture automatically generates code.
View 2 Replieshow many users can open a connection to Microsoft Access database simultaneously ?I am using asp.net 4.0 to write my application.
<add name="E_ShopAccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|
eport.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
I wan to edit Database file which is with .dat Extension.
The Connection string use in Configuration file that is.
<add name="TecsHomeConnectionString"
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TecsHome.dat; Jet OLEDB:Database Password=fdsa"
providerName="System.Data.OleDb" />
I have TecsHome.dat file. I am opening it in MS Access using Passwored = fdsa but MS access prompting invalid Password
how can i open it if the given password in connectionstring is not working.
keep in mind i don't have source code. I just want to open .Dat Database file.
Currently i am developing ASP.NET AJAX server control in which i am using jquery code. Inside jquery event, i wish to access the microsoft ajax object. If it is not clear, find the below code example,
Type.registerNamespace("MyControls");