weve gotn an access database running our intranet and its gone down.the in build trpair function doesnt work but we can still access the data through ASP,just not through the Access interface?
it says theres a jet error as someone else has the DB open but they dont
is there anyway we can duplicate the tables,data and relationships in an other db?ive tried some of the large scripts available for access that are supposed to do this,only no success yet
Some people who try to download a zip file get a corrupt file every time
again. While others don't have a problem at all. There are a few bytes at
the end of the file (6Mb) that are wrong and WinZip always gives the same
CRC error by different clients/downloads.
Downloads with a download accelerator don't seem to have this problem.
I really like to know how that's possible. Is it the cache of IIS that has
some wrong bytes? If so, how is it possible that other downloads at the same
time are fine?
Is it possible for data to get corrupted? Is there a way to check the integrity of the data through the ASP code seeing how the DB manager is currently on holiday and I don't have access to the information through him. Is there a way to just print out a bunch of random information about a recordset (similar to a phpinfo())...
There are a few fields in my db that act funny and I can't delete them through my ASP without getting an error and I can't find a reason why this has happened. It's not the information stored that is corrupted because I can copy the pages, it's just I can't edit/delete the original ones.
I have just created a register page for my site. I have had one running for years now, but I want to upgrade so it works a bit better.
Using the code below, the record that is entered into the database is corrupt. If i try and view the page with my admin page (works with records created with my old registration system), i get a 500 error, and if i view the database in access, the rows entered by thius code all show as hash symbols... any ideas? Code:
I use the code below to authorise the download of certain files.
Thus, instead of linking to the file in a wwwroot directory, I link to
this code with the filename as a parameter, and the script streams the
file if the user is authorised.
This has worked fine on PDFs, DOCs, XLS, etc. until today, and 18MB
file presents the error message 'format error: not a pdf or corrupt'.
Is there a file size limit, or a default that needs overridden? Any
thoughts? Code:
I am having problems with some ms access mdb queries that used to work fine up to about two weeks ago. All they now do is lock the database (produce an ldb file) or say there are key violations.
Nothing has changed to the asp pages or the database so I am scratching my head (amongst other things) to work out what the problem is - any help much appreciated to restore sanity! I even get the same errors when I try the sql statements below on a local copy of the database (its about 50mb) on my local machine. Code:
How can i save file in msaccess database?what should be the object type of the database field?
View Replies View RelatedI have this script that basically takes information from an XML file and checks one condition, and then inserts it into a SQL Server Database. I need to use a access database instead, so I changes the connection string and it seems to connect to the database ok. Here is the code (its a .vbs file) Code:
View Replies View RelatedI am trying to create MS access file (.mdb) from the data set with the following code. Every thing is working fine. But I found the MSACCESS.EXE is still running in the Task Manager. When ever I run this program new MSACCESS.EXE is added to task manager.
I could not kill the process after I created the file. I tried all the possible ways and checked with user forums, news group and MSDN, but no luck.
Access.Application accessData;
accessData = new Access.ApplicationClass();
accessData.NewCurrentDatabase("C:TestTest.mdb");
accessData.ImportXML("C:TestTest.xml",Access.AcImportXMLOption.acStructureAndData);
// Quit Access and clean up.
accessData.CloseCurrentDatabase();
accessData.Quit(Access.AcQuitOption.acQuitSaveNone );
Marshal.ReleaseComObject(accessData);
accessData = null;
I am pulling records out of an Access table, and comparing a time field to a time in my script. And printing some of the fields in the appropriete position.
I have printed the array that I generate from the record set and all the information is being retrieved and put into the correct order.
My page however only prints some of the records and not others. I can't find any patterns to which ones are being printed and which ones aren't.
The time field is in Long Time format in the Acess table
Here is some of the code....
I have successfully created a master detail page for this database, now I want to create an form to update the database.
When I created the form and tried to view it, I got this error
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/dlrc_resources/book_list/book_entry.asp, line 113
Line 113 is : Code:
I have a client's ecomm website under development, and have his access database with products in it. The db is structured this way:
MasterCategory
Category
SubCategory
Products
All these are seperate tables, and there are others and all have relationships(single relationship with one or 2 other tables).
I can get the recordsets and display them on the asp pages. I want to also have a shopping cart done with this db. Is there a script for this, or some way I can do this myself?
I am trying to link to a microsoft adp file using ASP
does anyone know how to (in general terms) create a connection string
to access the data base
Is there any way of using ASP to read the names of all the tables within my database?
View Replies View RelatedI am trying insert a record to my database from my webpage customeradd2.asp Code:
View Replies View RelatedBasically I need to show an image in a web browser (easy enough) I need to be able to track Mouse X & Y positions..Also OK, I have found some javascript to acheive this, but here is where the problem lies, the user must somehow click on this image & I then need to automatically record, display (graphically would be preffered) & send this info to a database !! Can NE1 out there do this How & where would I start?
View Replies View RelatedI have 2 dropdowns (or listboxes). 1 is for list of books called "book_title". I use a different recordType for value. Code:
View Replies View Related