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.
View RepliesI 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?
Looking to populate an access db table 'ole object' field through asp code.
View Replies View RelatedI 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.
View Replies View Related[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
I keep getting this error message when im adding a new record to my database.
Here is my code: ....
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?
I have a custom function for checking if a variable has been set or not to make the code easier to read, as well as to keep it shorter.
However, I'm getting errors that "Object Variable not Set", even after I've already checked for null and empty. Code:
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....
View Replies View RelatedI 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.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
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.
View Replies View RelatedI 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?
View Replies View Relatedhow to find the size of a pdf which is located on the server i know i have to use filesystemobject
View Replies View RelatedI 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:
we have NT 4.0 server now, will be moving to WIN2K and ASP TO ASP.NET. Right now we have java.jmail.....
View Replies View RelatedI 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:
how to create dao.tabledef object in asp:
I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field
Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld
just trying to add a product to cart although this error has occured!
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/djfubar/addCart.asp, line 75
this is the addcart script Code:
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 .
View Replies View RelatedThe 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.