I am creating a web interface for an MS-Access database This db has 3 fields called 'picture1', 'picture2' and 'picture3' In the database these are used to contain pictures, word documents or any other kind of file.
To store the files directly into the database I use 'Insert Object', use Object Type 'Package', then I drag the desired file into this package. How can I make the content of these packages through my web interface visible? or how can I download this content to the users computer trough the web?
I have a form that fills data into a database, the last field in the form needs to be able to add a pdf into the data as a OLE Object.The pdf changes depending on the data entered. is there any way to "add an attachment" to the form and make that attachment the content for the last field in the database.
I have an asp app that connects to an Access database. It works properly at my work on XP with IIS5.1 running.
I zipped up the asp pages and the Access database and emailed it to my home, which is XP and runs IIS5.1. When I recreate my work environmnet at home and try to update the database I get the following error when the code hits my AddNew method.
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only.
I've tried going into Access/Security/Tools/User and Group Permissions and setting all the tables to be able to update. I've even created new ODBC drivers, but neither has worked. The database is not set to read-only.
I'm looking for a way to allow only one user to access my web form at a time. so that if there is a user using my web page / html form.. then the next user is directed to another page. So only one user is allowed access at any given time .I was hoping there is a way to do this with Application variables.
I'll admit my ASP skills are very rusty, and come seeking help.
I'm currently using a dictionary object to store a multi-dimensional array.
I want to pass this dictionary object to an object, which holds an array of dictionary objects.
However I'm finding that the array is not getting set, thus I'm having great issue with dynamically resizing the object's property for every new dictionary object I'm adding.
I have a VC++ COM object which fires an event. I've written VB EXE apps against it and they receive the event notification.
I've now built a simple VB COM object which uses the VC++ COM object internally.
My question is, assuming the ASP page which loads the object does not immediately exit, will the VB COM object be able to receive the events from the internal object?
We are using .net 1.1 on windows 2003 server. This is we are facing in our production server.
When we are doing the load testing we are getting the bellow error. While the load testing this error is not coming frequently. When we run 20 threads for 3 mins we are getting this error message 2 or 3 times. But this line of code is executed by all the threads. Code:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in order to pass the parameter to a stored procedure?
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
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?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
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'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.
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?
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
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?
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
I have one column in my access database named 'picture'. I uploaded the pictures in the database using OLE Object. Now I want to have a picture of an employe in my ASP form. It gives me an error. The page works without that code-line where picture is mentioned. Code:
I have an xml data that I want to store in a database.
I want the following fields 1. Account-id 2. order-number 3. first-name 4. last-name 5. address-line 6. address-line-2 7 city 8, state 9 postal-code 10 total-points-spent 11 the list of items that were purchased which are in the section item-redeemed
And this is the asp code that I use to move through the list. right now all I can get is the redemption top-level, but I cannot seem to go down to the subitems. Code:
I am creating an e-mail using the CDO object and using the AddAttachment method to attach a file from a URL. I am having a problem in that the file file attached is given a random name (something along the lines of ATXX412.pdf)
Does anyone know if it is possible to rename/assign a name to attached file before the e-mail is sent?
I am writing a function to take a recordset as parameter, and print a HTML Select element according to the record in the recordset. I would like to check if the input object a RecordSet before processing, how can i acheived that?
I have a table called "Document" which has 3 columns
Doc_ID Doc_Name Doc (this is a word doc stored as an OLE object in ms access)
Now in my asp if the user selects a document it should open the word file. I have my case statement that looks like as follows which I think might need some modifications to open a word file: Code:
I have an E-mail ASP Web form that is using a CDO Mail Object. This form has to be filled out before the customer can download our demo. Currently, the customer fills out the form, clicks to submit and a message appears to the customer telling them it was successful and to click on a picture on the form to download the demo. My problem is that many of the customer don't read the message. I want to modify the code so that after the customer clicks SUBMIT, the info is submitted and then the download immediately begins without them having to take further action.
What is the code I should add to begin downloading a file after the form is successfully submitted. Here's some of the code I am currently using:
i have this form sitting on my website that all the data submited trough it goes directly to an access database - what i would like to know is how could i also send an email with the data entered to the recipent? my server does not support CDONTS .
The original programmer of our website put "on error resume next" on every page to cover up his lack of skill. Many of our pages are returning errors that we never see.
I want to make a little script that emails me at the occurance of an error. I copied one that used the Err object but I don't want to use it because I would like line numbers is the email.
I then copied our custom 500 error page that uses the GetLastError function but it always seems to be empty, like no error occurred.
The function "If Err Then" returns true so the Err object sees the error. Why won't GetLastError return the error.
