Moving Access File Using Asp
I want to do one of two things and I not sure which until I know the difficulty level (knowing a little asp but not alot) of each. I am helping in the office and we will have several small access dbs using the FrontPage forms methodology.
So, now that I have some data bases, I will want my users to be able to 1)copy the database to their own machine where they can massage and do whatever they need to with the data, or 2) perform a query against my data bases, and have that result sent in db form to their machines to do whatever.
I've seen somewhere that asp has some file system components but am not sure how that
works. I am willing to read and figure it out if I can get a push in the right direction.
View Replies
ADVERTISEMENT
Is it poss to move records from one table to another using ms access db to arcive records and how would i do that.
View Replies
View Related
Im changing from Access to SQL Server and had a few questions:
What is the Equivalent in SQL:
Access: Memo Field
Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
View Replies
View Related
I have to move a file(Excel file) to a folder that resides in
a different server using asp. how do i that. I tried using
move file method in file system object, it says
file path not found.
View Replies
View Related
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies
View Related
this is the code I am using for MS Access
Code:
mydb="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("database.mdb") & ";"
set conn= server.createobject("adodb.connection")
conn.open mydb
I want to know what code I can use to connect via MS SQL,
I tried this one,: but no luck
Code:
mydb="driver={SQL Server};server=YOURSERVER; UID=YOURUSERID; PWD=YOURPASSWORD; database=YOURDATABASE"
set conn= server.createobject("adodb.connection")
conn.open mydb
View Replies
View Related
Looking for the best resource (book, online article, etc) for moving from ASP 2.0 to ASP.NET. I'm ready to make the jump. What do you think?
View Replies
View Related
Does anyone know how to code a button that when hovered over moves. Then maybe on the 3rd roll over it will not move and actually allow the user to select it?????
View Replies
View Related
i have this in the database section of devshed - but noone seems to know... so i'll put it in here now
View Replies
View Related
Is it possible to moves files to and from other servers in ASP?
I'm in the process of incorporating a VBS script into ASP that used to
do this job for me. However the VBS script was setup to run through
Task Scheduler as a domain user, which allowed it to connect to remote
hidden shares.Or alternatively, could I leave the VBS script as it is and have the
ASP page execute it on demand somehow?
View Replies
View Related
How would I go about reordering records in a database? Say for example, I wanted to change the output of something, and I could just click a link which would move the record up
View Replies
View Related
i have 2 rows in the table... and i wan to do a response.write("REMARKS")
the remarks sumtimes can be longer then the width of the table...
how to i make it such tat when the max width in row 1 has been reached then it will carry on writing onto the second row of the table???
<table border="1" width="100%" id="table1">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
where to place the response.write or how to add in additional codes to achieve this function?
View Replies
View Related
I have a web site and database is on SQL server,now I need to move it from this server onto another one that is on a different location as well.This process is completely new to me,would somebody have an advice or a link where I could read some info about doing this, as I am not sure where to begin.
View Replies
View Related
I have a freind who wants to convert his ASP site (with a HUGE MSAccess database) to MySQL etc. so he can move to a Linux server.What all would be involved in the conversion? I have redone an ASP site to .xhtml and .php but there was no database to deal with.
View Replies
View Related
I don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
View Replies
View Related
I currently have the below working they are testimonials, displaying 1 every day and therefore i would like be able to page through them from clicking a next> or more> link also
if WeekDayName(weekday(now)) = "Monday" then
Response.write("")
else
if WeekDayName(weekday(now)) = "Tuesday" then
REsponse.write("")
View Replies
View Related
I need to move some SQL tables from one unresponsive ISP to our new mo bettah one. Naturally the current host is not being quick about getting a cd of our tables to us. I was going to write code to move them from one place to another but it is not so easy. If it runs on the old server it can't access the SQL on the new server and vice versa.
The alternative that I see, is to download them into text files and rebuild them on the new server but that is a lot of work. Any quicker fixes out there that anyone knows about?
View Replies
View Related
If I have a page. And I want to move this. What is the best way to do this while preserving the rankings in Google (and other search engines)? From what I've read, I want to send HTTP 301 (Moved Permanently) when the old URL is accessed. But I believe Response.Redirect sends HTTP 302 (Moved Temporarily).
View Replies
View Related
I have an asp page that has 12 tables, 3 tables per row, . Im trying to get my query to fill each table with 6 records and then move to the next table with 6 records...etc then after the 3rd table start a new row. I know I have seen an example of this before, can someone point me in the right direction?
View Replies
View Related
I'm trying to build a quiz site. The page would show 1 question at a time. Basically the questio and the 4 options are being shown in tabular format. Now I want to use the same table to fetch the next set of records.
how to reuse the existing table to wipe out the previous record and to display the next record without losing the page variables.
View Replies
View Related
hen administrator logs into the system, they can view all of the members' details. So they search for a member by id/name and the members details are brought up. From THIS page I have a button "Get members records" which is to display the records in the system for that member.
The button at present calls the getRecords.asp file which shows the date and has a change date calender js function. (this works fine) What I want is for the administrator to choose a date from the calender and to see the users record for this date without having to go to another page.
It would be easy to have them choose the date on the previous page and then see that record, but is it possible to have them choose the date and then automatically get the figures displayed in the text boxes, all on the same page
View Replies
View Related
i try to move an entry to another table.
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/searchsrv/searchsrv.asp, line 315
Any ideas on how to solve this?
View Replies
View Related
I'm moving a ASP-site that my brother has done from a Linux server running ChiliASP to a Win2003 IIS server. Almost everything works fine, but one page doesn't load. Calls to the function datum_6_siffror doesn't work. Code:
View Replies
View Related
I have created a recordset with cursortype 'adOpenDynamic'. i have used "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
connectionString to open connection.
The problem is that ASP renders Operation is not allowed in this context' error when i call the moveprevious methord of that recordset. I have discovered that it doesnt move previous when i used a joined query. and it works perfectly when i use single table query. the recordset code is:
Set client = Server.CreateObject("ADODB.Recordset")
client.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
client.Source = "SELECT * FROM customer c inner join business b on c.id=b.cid"
client.CursorType = 2
client.CursorLocation = 2
client.LockType = 3
client.Open()
View Replies
View Related
I'm currently migrating an ASP/SQL 7.0 site that runs on Windows NT 4 server to an ASP/SQL 2000 platform running on Windows 2003. The current server resides in Orlando, FL. The new server will reside in Miami, FL. Here's a recap.
Old Location/Server:
Orlando, Florida
SQL 7/ASP/Windows NT 4
New Location/Server:
Miami, Florida
SQL 2000/ASP/Windows 2003
Along the way, many apps are breaking (which was expected). I've successfully recoded CDONTS to CDO and I'm slowly working my way through 1999 code.
I also found out the hard way that you need to explicitly tell Windows 2003 to run ASP pages or it will ignore all calls. I also performed the User migration steps from SQL 7 to SQL 2000 which was a breeze with the help of the Microsoft knowledge base. Code:
View Replies
View Related
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
View Replies
View Related
i have a formular using two text field. i want , when i finish writnig , moving to the next using " Enter " key.
View Replies
View Related
ok i have a number lets say its 36 and i want to divid it by 150.... 0.24 returns... i want to change 0.24 and make it a percent to it would be 24% how would i do that...
View Replies
View Related
I have a database with the columns:
id
name
phone
I have a web form with three textboxes and a button. How do I move through the records by clicking on the button. e.g, the page loads with the first record in the textboxes, if the button is clicked it displayes the second record, if it is pressed again it moves to the third record and so on.
View Replies
View Related
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
View Replies
View Related
Is there a way to force a sub or a function to be executed before the
user to move to another ASP page?
In fact I want to update a basket (table) if the user wrote a quantity
for a product in the page. I want to avoid them to click for every
single product they add.
View Replies
View Related
Is it possible to read a file from a local computer? I know how to read a file that is in the server, however I would like for the user to read a values contained in a file that is loacted in his/her computer and then load these values into a database.
A way around this would be for the user to upload his/her file into the server, but reading the file directly from the local computer would be much faster.
View Replies
View Related
I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
View Replies
View Related
