Users login to an MS Access database table called users with a password and the time logged in is also captured in the same table.If this user updates a record in another table called KTdata, I want that user's name stamped in this table.
View 1 Replies
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.
I have a static class with serveral static methods. In these methods, I'm trying to access the current thread's context using HttpContext.Current. For example:
var userName = HttpContext.Current.User.Identity.Name;
However, when I do that, I receive a NullReferenceException, the infamous "Object reference not set to an instance of an object."
I want to check if a user in User table is found either in UserName Column or in FriendUserName Column in UserFollow table and if yes display lable found, But if no display lable notfound. This code will be excuted onse a user logs in the connection code
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] != null && Session["UserName"].ToString() != string.Empty)
{
string userName = Session["UserName"].ToString();
if (!this.IsPostBack)
[code]...
Dim ds As New AccessDataSource
ds.DataFile = "c:InputTest.mdb"
ds.DataSourceMode = SqlDataSourceMode.DataSet [code]....
I have 2 updatepanel UpdatePanel1 and UpdatePanel2. Intialy updatepanel2 is invisible. In updatepanel1 there is a dropdown list, whose Selected Index Method change makes UpdatePanel2 visible.The code
UpdatePanel2.visible =true;
seems to run without any error, but updatepanel2 is not visible on the page. Is there anyway to make it work.
I have put several buttons and panels in my update panel. I also have a script manager on that page. now when I click on any of the buttons then the functionality is working fine but problem is that the complete page gets reloaded witha a flick, instead of updating the update panel only. I have set the "children as trigger" property of update panel "true".
View 1 RepliesI want to stamp first page of any existing pdf file with any text enter by the user and save it again or overwrite the file. I found some article about it on google but all are either create a new pdf file or save the stamped file in new pdf file. I want to save the stamping in existing file.
View 1 Repliesi want to find the timestamo of the local PC.
i m printing in my label below
lblrtntimestamp.Text = dt.ToString("yyyy/MM/dd HH:mm:ss.fff");
but insteed of the "yyyy/MM/dd HH:mm:ss.fff" i wnat to display time format as per the local PC's timestamp.
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 RepliesWhen adding new DB records to a ListView, I want to update the date/time stamp of the containing ASPX page for SEO purposes. Is this possible and how might I go about it?
UPDATE:
I found Touch for Windows, bu would still prefer any kind of clever hack just to do this programmatically:
[URL]
I am trying to download byte array (l_attchmntToDownload) using the following code:
try{
Response.Clear();
Response.AppendHeader("Content-Disposition", "attachment; filename="+l_attchmntFileSpec);
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(l_attchmntToDownload);
Response.End();
}
catch (Exception Ex)
{
throw Ex;
}
Is it possible to supply Date/Time of modification for the downloaded file?
I tested "Last-Modified" HTTP header but the file gets saved with the current Date/Time only.
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 Repliesget the below error. My application was working fine until I probably modified something, but don't know what.
Server Error in '/' Application.
Method is only supported if the user name parameter matches the user name in the current Windows Identity.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.]
System.Web.Security.WindowsTokenRoleProvider.GetCurrentWindowsIdentityAndCheckName(String userName) +2195661
System.Web.Security.WindowsTokenRoleProvider.GetCurrentTokenAndCheckName(String userName) +36
System.Web.Security.WindowsTokenRoleProvider.GetRolesForUser(String username) +61
System.Web.Security.RolePrincipal.IsInRole(String role) +182....
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
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 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#
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 am trying to create a listing for a ticket company. When the user(client) adds a new ticket to the listing, all the ticket info is saved into the database table, but I can't figure out how to get their clientID in the table with that post. For example, I have event, date, venue, row, section etc...all this info gets stored, but I need to have the clientID stored also, so the gridview can show the post when the client logs in/out from the app. Right now the only way the clientID is in the DB is because I manually put it there for development reasons. But, when the client adds a new item to their listings, it does not show until I put the ID in myself. I need the ID to insert in the CID column at the same time the rest of the info is stored.
View 5 Repliesi have problem accessing HttpContext.Current.Application From global.asax its seems to be null every time i try to access it. How can i to this?
HttpContext.Current.Application.Lock();
HttpContext.Current.Application["Actions"] = "hello";
HttpContext.Current.Application.UnLock();
During Application_End() in Global.aspx, HttpContext.Current is null. I still want to be able to access cache - it's in memory, so want to see if I can reference it somehow to save bits to disk.
Question - is there a way to reference cache in memory somehow when HttpContext.Current is null?
Perhaps I could create a global static variable that would store pointer to cache that I could update on HTTP requests (pseudo: "static <pointer X>" = HttpRequest.Current) and retrieve a reference to cache through that pointer in Application_End()?
Is there a better way to access Cache in memory when there is no Http Request is made?
Suppose I have an asp:Repeater that I am using to display a list of names and phone numbers.
<asp:Repeater runat="server">
<ItemTemplate>
<p><%# Eval("name") %></p>
<p><%# Eval("phoneNumber") %></p>
</ItemTemplate>
</asp:Repeater>
Now, let's make it more fun. Let's suppose that there is one or more phone number per name. I feel like I could use a repeater within a repeater to repeat the phone numbers. I could also use a for loop in my asp code. However, the Eval function is the only way I know of to access the current record at runtime and Eval only returns a string and only runs in <%# Eval("X") %>. How can I get the list of phone numbers that is a member of the current record?
i am using this query but it is giving syntax error,
insert
into Logistics.DisInventory
values
select *
from Logistics_v1.DisInventory)
IIS is utilizing the current logged-user's credentials to access an ASP.NET application. Is it possible to create a login page on the application and pass another users credentials, so that particular web app is run under a different user?
View 1 RepliesIs there any potential pitfall for using HttpContext.Current.CurrentHandler for runtime view access?
public static GetView<T>(T view) where T : IView
{
return HttpContext.Current.CurrentHandler as T;
}
