Msaccess Db Locking Up

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:

View Replies


ADVERTISEMENT

Locking Files ??

I have an asp intranet app which allows users to download files from the
server.

It all works fine but now I have been told that in the case of Word and Excel files the user, after downloading or opening the file the file must be locked in some way so that other users cannot change it. On top of that I also have to allow users to save changes they have made to these files on the server.

View Replies View Related

Locking With Access

I am having a problem with locking, and it is crashing our website. I suspect it is a locking problem because everytime the database goes down, I ftp into the site and see the dreaded *.ldb file. Access is susposed to support from 15 to 20 concurrent users, right? The log files show no more than two or three users accessing the database at the same time. By "same time" I mean within one second.

Below is the code which updates the database. Can anyone see anything wrong with this?

Also, if I wrote the information to a text file with the FileSystemObject instead to Access, would I solve the problem of locking?

BEGIN CODE .....

View Replies View Related

Locking Pages

I have developed an asp application to track the training of employee training records. I'm close to done but I have one nagging problem. Multiple users can log in at once of course, but I don't want more than (1) person to open a training record. So I put some code in: Code:

View Replies View Related

Locking Header Row

I know this is client side but this is coming from an asp page. Is there a way to lock two rows on a table so that when a user scrolls down a long table they always see the header row? Without using frames.

View Replies View Related

Webserver Is Locking Up

i am having this problem with my webserver. everytime i run an asp application that will display pictures, my server will lock up. i used to this it was due to the asp itself, but whenever i run asp apps that display pics, it works fine.

this only happens when i access my websites from my personal computer within my network. whenever i access the sites from outsite my network, it runs fine. is this a problem due to my server or is it because of the data that flows through my network?? any thoughts?

View Replies View Related

Locking MS Access

I have a table at MS access database, and I want when I perform an insert action at that table to be locked, noone other to insert. maybe can do updates or see the values but no insertions values to that table via the asp application. Is that possible?

View Replies View Related

Locking Account Problem

I wrote this script which for now it works fine. The purpose of this code is to lock the account whenever a particular document comes to its expiration date. So, if I have a document that expired on 7/31/06, the it should lock the user's account once they'd logged in.

However, the problem I am having is that is locking everyone that has already an expired document. What I would like it for the code to check during the current month. If a document expired, say yesterday 8/9/06, lock the account, else let then user continue to access their account. Code:

View Replies View Related

Access Database Locking Up

I have an access database that used to be on 1 box and now is on another.
There's asp pages calling it. The gals that use it said they used to be able
to get into the access database at anytime and modify it without the asp
pages locking up. Does anyone know how this could occur?

View Replies View Related

Locking All Text Boxes In Asp Page

I need advise as to how to do the following. In a asp page, the user can input
information via text boxes which goes to a database. If users click a check
box named final and submit the asp page, then next time they come, they will
not be able to change any information.

This means, I would like to grey out the text boxes so that users are unable to edit the values in the text boxes. The only way to allow edit is via adminstrator's intervention.

View Replies View Related

Msaccess Database

How can i save file in msaccess database?what should be the object type of the database field?

View Replies View Related

ASP And MSAccess Error

I 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 Related

Corrupt MSAccess DB

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

View Replies View Related

Could Not Quit MSACCESS.EXE

I 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;

View Replies View Related

VbScript / MsAccess Time

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....

View Replies View Related

MSAccess Entry Form

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:

View Replies View Related

MsAccess And Shopping Cart?

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?

View Replies View Related

Connecting To A Msaccess Project Database

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

View Replies View Related

Reading MSAccess Table Names

Is there any way of using ASP to read the names of all the tables within my database?

View Replies View Related

Unable To Insert Record To My MSaccess Database

I am trying insert a record to my database from my webpage customeradd2.asp Code:

View Replies View Related

Send Image & Capture CursorX,y Onclick Positions To MSaccess

Basically 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 Related

How To Populate "chapter" Table Fieldname (MSAccess 2000) By Selecting Book From Drop

I 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







Copyrights 2005-15 www.BigResource.com, All rights reserved