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
ADVERTISEMENT
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
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
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
View Related
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
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
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
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
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
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
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.
<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>
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
Does anyone know how to connect to an Access database using C# in ASP.NET?
View Replies
View Related
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 ?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
how can i access other pc database and send a signal to that computer based on the IP address.i can not find any component for it.
View Replies
View Related
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?
View Replies
View Related
Hope that i could find my solution here.i'm working on an asp page and i need to display data from 2 different databases one is in sql server and the other is in access
currently i have linked the sql tables into the access database but problems occur where i have to refresh the tables regulary
so what i need is to be able to select from the sql and access seperatly in one select statment How could i create the connections for both of them to be able to do so?
View Replies
View Related
I have been trying forever to get info from an RSS news feed and send it to an Access database.
The structure is a basic news feed
channel/item
with childnodes: title, link, description
I can supply more info if needed
Anyone have any examples or know how to do this?
View Replies
View Related
I want to have a sentence reading:
There are "x" numer of records in the database.
What code do I use? Bear in mind that each ACCESS record has an Auto-ID, but since some records may have been deleted, the number of records in the database does not equal the maximum ID number.
View Replies
View Related
For a new project I just got,I am being asked to code a small web site but it has to be in ASP. The company doesnt have alot of money, and wants to use ASP and an Microsoft Access database.I had thought that ASP was only able to use MS SQL, but maybe that is wrong.
I am very adept in PHP and MySQL, and have programmed a little in ASP, but never with ASP+ and a database. Could someone please recommend a site or give some examples on using ASP with MySQL or with Access?
View Replies
View Related
I am trying to get records from an Access database that can be viewed from a WAP enabled phone.I understand that I have to create a WML file, but dont know how to do this.
View Replies
View Related
i have a form that adds subjects to access Database.It works very well but the problem is when i request the fields by their Name and not by Id. If the subject have to 2 words or more between the 2 words, there is Space so it take Only the First Word and ignore the rest of the words.
View Replies
View Related
they have a database which stores information about their properties.. as well as one image of the property from the outside and 3 or interior images of the property.they would like the 'property' section of the website to pull the images and descriptions from this database.
they would also like to edit the properties section on a daily basis using forms.. (deleting properties.. adding properties.. deleting images.. uploading new images.. )
does this sound viable in asp and also some tutorials on uploading files i think will benefit me.
View Replies
View Related
I have a single table, with 8 fields. I want to allow users to filter their selections on 3 fields, specifically County, DistrictName, and Date. I would like users to be able to chose one a specific field from each of these 3 or default to all. Users will not be able to update the database, they will simply be returned data.
Add to this one of the fields is an amount field in which a user can see the sum of the data returned. In conjunction I will also need a flag for amounts which have not yet posted so that these do not report in the sum amount. I would be most grateful for any assistance or if i can be pointed to a product which will aid me in completing this task.
View Replies
View Related
How can I secure an Access database that I use on my Web site? That is, I don't want users to be able to guess the URL of my Access .mdb file and download my database.
View Replies
View Related
I can't insert records from a form on one of my pages that has SSL on it. It encrypts the data and so then I get a microsoft jet error saying data type mismatch. Is there any way around this. or am I doing something wrong?
View Replies
View Related
How can I give "write" privilege to the database to the visitors of my website. I want them to upload their personal information and photoes instantly. I am using MS-Access. How am i supposed to set the configuration? Is the web-hosting company responsible for it
and which software to use for it.
View Replies
View Related
I have database containing the results of students in MS ACCESS.I have created form containing one textbox for entering the roll number of students and two buttons -SUBMIT and RESET using HTML .
Now I want to access database from this HTML File using the textbox and SUBMIT button so that details about the particular student whose roll no. is entered in the textbox, is displayed on another HTML page using ASP.
View Replies
View Related
We are using ms access database for our development and we r facing a strange problem.
We've to store date in dd/mm/yyyy format and display so to the user.Ifwe enter a date in the range 1-12 the date is getting stored in the format mm/dd/yyyy whereas dates above that get stored properly ie dd/mm/yyyy format.
Why is that. Is it a known issue ? How do we solve that ? Please advice.Is there any setting that we need to change or set some format in the access table ?
View Replies
View Related