Problem On Querying Access Link Table In ASP Page
I connected MS Exchange Server to MS Access database using Access link
table function. I can open the database table and see the fields and
data inside the link table. However, the table seems cannot be queried
by SQL statement.
My situation is:
I'm building an intranet. I have a ASP login page for all staff in the
company to login. Other people can't register or login the intranet.
That's the reason I use the company email address to verify username
login name.
After I made the link to the Global Address List (rename to
StaffList), I can see the Alias field. I wrote ASP code to use Alias
field to verify user login name. But, the ASP page seems experiencing
difficulties. I always got the "Connection Timeout" Error. Code:
View Replies
ADVERTISEMENT
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies
View Related
Is there any way to quiry two tables in one select command to limit the number of database connections. One quire displays members from a members list the other quires achievments for each member. i.e.
select name, memberno from memberlist
then select * from achievements where member = memberno
currently this is done by a loop which requires lots of connections
View Replies
View Related
I wrote a Windows Form Application to query the IIS MimeMap on the localhost which worked fine.
I ran the same code in asp.net and got "Access is Denied" exception. What is the least permissions set I should grant the aspnet account to avoid the exception. Or any other suggest would be fine Code:
View Replies
View Related
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)
Joe Bloggs ---> 100 Closed
Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
View Replies
View Related
I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database. I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following:
http://sports.espn.go.com/nba/players/profile?statsId=3282
I am having trouble becasue the stat page is not by the player name but a numbered ID.
I tried using a player search like follows:
<a href=http://www.tsn.ca/nba/player_list.asp?name=<%=(Blair.Fields.Item("IDPlayer").Value)%>&Submit=GO ><%=(Blair.Fields.Item("IDPlayer").Value)%></a></td>
When I do this it only seems to search for the first name.
View Replies
View Related
I'm trying to figure out if this is possible before i have someone start scanning a bunch of images.
If i scan a bunch of images and give them specific names can i then look at that dir and read the name of the file and write a link in a field of a table?
example
FOLDER CONTENTS
123254.jpg
125684.jpg
168468.jpg
TABLE record example
epn =123254
name = Bob
Picture = 123254.jpg
i want the name of the file to be written if there's one in the folder for that epn.
View Replies
View Related
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
View Replies
View Related
Does anybody know if it is possible with asp to link a txt file to an access database?
Now I have linked the file using Access and uploaded the database back to my webserver, so I have a 'link specification'. I'm not sure how this is called in English since I'm using MS Access in Dutch , but a don't have any idea how to use this specification (where is it stored in Access? to link a txt file to the database.
View Replies
View Related
Is it possible to link forms developed using Access 2K
with an asp page? I want to be able to pass on the order
no. by clicking to an access form and display results.
Is it possible? If yes, can you give me some leads how
to do?
View Replies
View Related
Can anyone tell me or guide me (in details) on how to link Access Database in ASP, including SELECT, INSERT, UPDATE, DELETE issues.Is there any sites offering this resource?
View Replies
View Related
Ok.. I have a form the user fills out. An email is sent to them and one to our office with a link to the DB so they can view all the info. My form works fine, my emails work fine. The info gets inserted in to the DB fine.
What I would like to do is:
When the link is sent to our office, I would like it so when they click the link it opens the DB right to the info from the link. You know, like when you get an email from here saying someone posted your link has it set so when you click it, it will go right to that post.
So there you have it, any takers.. I sure could use this, otherwise they open the DB and have to search for the info and they do not like having to do much work..
View Replies
View Related
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies
View Related
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies
View Related
why does this 'file download' box pop up when I click a button on my html page? Saying
do I want to open or save the asp file? if I click open it opens it in development.
View Replies
View Related
I have the following code that works great with html, but I am having problems doing it an ASP, since I am not to familiar with it. Code:
Response.Write " <TD width=100 style=border-style:none; border-width:medium; bgcolor=" & BGColor & "><p align=center><font size=2><B><A HREF=Schedule.asp?TeamID="rst.fields("TeamId").value">" _
& rst.Fields("Tournament_Description").Value & "</B></font></TD>" & VbCrLf
I am trying to pass a variable as you can see. It works with html but with ASP, I am doing the syntax wrong.
View Replies
View Related
How can I remove the page.asp link from the address bar? For example I have a link called www.mysite.com/page.asp?f=1, after the user clicks on the menu navigation. How can I get rid of page.asp?f=1 so that only www.mysite.com appears? Another thing, will request.querystring still work then?
View Replies
View Related
I am storing times into Access and that works fine and it stores into access the way i want it, like so 12.30 but it is displaying in asp like so: 12.30.00. does any one know how to change this?
View Replies
View Related
Does anyone know the best way to pass a value from the same line to the next page?
View Replies
View Related
i want to know the previous page address.ie,from which link the current page come here.
Is there any function in ASP to find that........?
View Replies
View Related
Trying to access an SQL Table....
'ATTACHMENT'
I have a form that is set up to search the table and attached is the code that is trying to get data from that table.
Need help please, if anyone has any ideas.
This is the error Im getting:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '2003'.
/pub/property/tpp/SearchRes.asp, line 124
I cant figure it out.
View Replies
View Related
I have a user based service where each user has their own information, user settings, etc. I want to be able to add tables in my user settings and allow the users to enter in their IM Service (AIM, Yahoo, MSN, etc) and their screen name/user name.
That is the easy part.
What I do not understand or cannot figure out is how to link this information to the icons for each service they enter that will open up the appropriate service with their correct IM name, etc.
Basically I want to provide a way for my members to IM another member when they pull up that users information, or associated information, etc. Basically I need the script to make the Icon execute the correct IM service if the user clicking on it has the service installed as well. The majority of my members use AIM.
Where can I find information on how to install this kind of script and associate it with the users information and an icon?
View Replies
View Related
The following html code appears in an ASP page. The hyperlink is set to
white (see the page link color), but when the page renders in IE 6.0, it
initially appears in maroon with a white border around it. When the user
clicks anywhere on the page, it turns white. Does anybody know how I can
make it appear white when the page first renders?
View Replies
View Related
How would I send an email to someone from a webpage with a link to the
current page? I've seen this where you can put in your email, the person's
email that you are sending teh page to, a subject for the email, and a
message along with the link.
View Replies
View Related
I am passing variables around from page to page using the following:
../new.asp?Info=stuff&name=Fred
then re-capturing it with:
<% 'Get the users info passed from the previous page
strUserInfo = Request.QueryString("info") %>
strUserName = Request.QueryString("name") %>
I use that info to personalize pages:
Hello <% strUserName %>, glad you are back to work on your <% info %>.
This works great for pages/forms that only update a record or display the strings, but the problem I'm having is with a form that creates a brand new record using the passed data.
I use hidden inputs into the new record so that the user does not have to re-enter it but when they hit submit Front Page posts a confirmation page with a link to return to the same form. I need to change that link but cannot figure out where the confirmation page is generated.
View Replies
View Related
how do i link an asp page to a pdf document and render it (the pdf document)in a web browser without it downloading to the client computer viewing it?
i have tried the response.contenttype="application/pdf"
now the main problem is how to embed the pdf doc in that asp page!
View Replies
View Related
my problem is with a db(that i upload on server every day) which has some "static" tables in it plus a table updated every day.
the website must show the date of last update of that table so i first retrieved that from the access file, but this means that every time i upload db(with that table untouched) the last update changes. i've found something about table's extend properties on the internet but i don't know if this can be useful to me.
View Replies
View Related
Can anyone direct me to a web page (tutorial) where there is an explanation on how to create a web page that connects to access database and I can enter data and update the table? I can create a page using visual Interdev that displays the table only.
View Replies
View Related
trying to run an UPDATE query on an Access DSN.Done the following.Updated DSN to full access.Given write permission on the IIS directory.still getting error, Operation must use anupdateable query.whats going on?
View Replies
View Related
I have a table in an Access database that I would like to download in an excel spreadsheet. No editing required, I simply want to copy the whole table.
I can connect to the table and, if I wanted, could display the complete data in the table on a web page but importing that data into excel is where I am stuck at.
View Replies
View Related
Access db with a table tbl_faults
id autonumber
firstname text
lastname text
datelogged date
email address text
faultdesc memo
When a user fills the form with these fields the data get saved to the table AND I would like to see a message saying your unique ID (fault number) is xxxxxxx .
View Replies
View Related
how do you create a table in MS Access from with an asp script? I will be creating the table name from Request.querystring("name"), also needs fields of branchname and branchcode. guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.
View Replies
View Related
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?
View Replies
View Related
