how to open or do a connection to open switchboard in the Acccess database? Really Really need help from you who knows the code to open the switchboard in access database using asp. or Is there a way to link switchboard form to the asp page so that when i click on a link , it will open up the switchboard form (lets say the form's name is called "Contact") from the Access Database ?
I have finished an access database, complete with forms and reports. I now want to convert the entire thing into ASP. My questions are: 1/ Can the visual basic in ASP do everything (call every function) that MS access can? 2/ Normally when you change a drop down list, or click a button, it runs code (a sub) without submitting the form. Is this possible with ASP? 3/ Can I still preview access reports through ASP? 4/ What else should I know/consider?
I am looking to make my company's access database (forms, reports, etc) available through a web server. Any idea what type of programming will be needed (ASP, JSP, PHP)? If there is anyone that can help me with this please let me know. I am willing to compensate them for their time and help. It should be a fun project.
I am in the process of building a small Intranet application. Iam using ASP along with access backend on IIS 5.0.
Info will be sent from an HTML form, [an inventory report] various drop down lists, text boxes, etc.
This info from the form is then added to the mdb, but an administrator needs to pull the same form back to add further info to complete the form, [cookies?] and finally it gets exported to excel format and saved on the server. Also an admin page needs setting up so "admin" can confirm when some reports are completed and when others need completing, maybe this could be the way the first part of the form could be stored and pulled back from ? Could it all be done in MS office applications?
how to open a mde file from a web page (asp,html,shtml,apsx) ? I know there is a security setting that don't allows web server to run/launch executable files but can it be turned off.
I have created a form dynamically which displays questions and a selection of possible answers. These questions can come in many forms ie radio buttons, select box etc this is controlled by the entry in the database. My problem is how to update the database with the results entered. I am confused as they all have the same name for question and selection and there can be up to 10 questions. Code:
I have a windows 2003 server with a "classic asp" application on it with some com Dlls doing the business logic. my problem is when i add these DLLS to component services, all my buttons on my web server start returning the error access is denied. it keeps this problem if you remove the dlls from component services and restart the server.
I'm using ASP to pull info from a database and open it in Word. Everything works fine but I want to specify the paper size to be Legal. Is this possible or am I stuck with Letter size?
this should be an easy one. I have a script which I use to add a new record to a database. Simple enough. But I have always used this string in opening up a database for just such a purpose: "SELECT * from images" Ok, I obviously don't want to select all every time I want to add record, so how would I just get access to that table without opening all of the records? Would it be - "SELECT images
I try to use as much functions as possible. So I have written a function to open a database and retreave the information from a specified field but it don't want to work. This is the function I use Code:
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt) DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
Basically everytime I need a page to access a database I will create a connection object, and then at the end of the page I will close the connection object.
Would it be more sensible to create all the connections to the database that a user will need when they first visit the site, and then close these connections once they leave the site. (Using something to do with Start Session and End Session).
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
I am urgently finding a set of codes to write data into a form and the data will go to my database. However i have tried a lot of form but couldn't successfully process. Below is one of my problem...
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9a8 Thread 0xa08 DBC 0x3041e1c Jet'.
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails. /<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
I have four input variables from a form (first name, Last name, registration number and pin number). I want to check if this variables conform to the data I have in a database (mind you the Pin number is initially not related to the registration number, first name and last name and it is a list of numbers in a separate table in the database;I want to have the flexibility to supply any Pin number, tie this number to the registration number, first name and last name for the purpose of accessing other data in the database for a specified number of times) . how can I do this in an asp environment ?
I'm trying for the longest while to access a database and i keep saying error 3219 which states that the operation is not allowed in this context.
The error occurs when i add obj.AddNew. I have declared a variable called obj which handles the microsoft access database. i set it to obj.Open tablename, connection,0,3,2 and after assigning the values to the fields i then said obj.Update.
I'm creating a form for users to fill out and submit the form via email(outlook). But at the same time I want their names and phone numbers to be registered in an Access database(once submitted). I can't figure the ASP coding to do this.
I have a whole database set up in MS Access with all the menus etc. It's a flight reservation database for a school project. Is there a way to import everything (including the interface) to a website using ASP or ANY other kind of software?
i want to write a intranet webpage (can be in ASP / HTML) to connect our Access Database and to search in the Database. We are using WinNT Server here, and php is not allow. And i have no permission to install anything to the server ... I have experience with php and mySQL, but have no experience with asp ... 1. what is ODBC ? how to link db with ODBC in intranet ? (coz' i only saw instructions to link db to local computer) 2. any sample codes of ASP with access database to follow?