Intermittent Database Access
Dec 27, 2006
I have a website that runs on a host out in the real world. I need to do some work on it in a test environment. I started IIS on XP pro and created a website under the default wwwroot. The site runs and connects to a MS Access database and will show a list of records pulled from the database, but only once. Refreshes fail with an error: Provider (0x80004005) Unspecified error.
If I wait a few minutes I can access the database again. I can not find the problem. Please help.
View Replies
ADVERTISEMENT
Aug 19, 2005
Hi all,
I have a problem in a database I'm designing at the moment. Basically I have a form (frmMain) which is filtered (from another form). I can then go through the filtered records no problem. I made a query, and also a report based on this query. The query has all fields from the main table (same as frmMain), and I want to base the query on a field on the filtered form (fldJobRef). Now, sometimes this works fine, othertimes I get the box saying "enter a parmeter value" for Forms!frmMAIN!fldJobRef. The form frmMain is open at this time, and I can see plainly and clearly on this form a fldJobRef ! If I go into design view in the query and "build" the criteria again, it works for a short while, can anyone offer any suggestion?
Thanks
[UPDATE]
I found that if I simply open the main form without any filter at all, then the query works fine.
View 2 Replies
View Related
May 2, 2007
hi,
I've got a database that is split -front/back on a server. It is used by roughly 5 people. Usually one or two people use it at one time, with one of the users who leaves the application open at all times. Sometimes when the users are working in the screen, which would be in the subform, an error like "record is locked" pops up and they cannot enter any data. This happens on a date field where I have put some code to auto fill the date if the previous record has today's date in it. It doesn't seem like it should be locking on that. Should it? This is what I have in the code:
Code:Option Compare DatabasePublic DateValue As DatePublic DatePresent As BooleanPrivate Sub DateLog_AfterUpdate() 'fill the date with previous entry - if it has been entered in same session DateValue = Me.DateLog.Value DatePresent = True End SubPrivate Sub DateLog_GotFocus() If (DatePresent) Then Me.DateLog.Value = DateValue End IfEnd SubPrivate Sub Form_Load()Me.RequeryDatePresent = FalseEnd Sub
View 2 Replies
View Related
Dec 1, 2006
:mad: and tearing out my hair with this one...
Someone out there please help:
I have a form that should open, linking to the date on another form (that is changeable using a Calendar Control), and display records for that date.
My underlying data is available for a variety of dates but some of the dates (and therefore the records) will not appear when this form opens.
They will all show if the form is opened without the filter. Or they will show in a report.
So I know that the coding is correct.
This intermittent-type thing is really bugging me.
Have even tried re-typing some of the dates in the table in case the format has somhow got changed.
Nothing is working.
View 14 Replies
View Related
May 26, 2006
Hi,
I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages:
"Error Executing this command"
AND
"You cancelled the previous operation."
I removed the error handling code from the application to get more detailed error messages and we got the following error message:
The expression On Click you entered as the event property setting produced the following error: .
The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
There may have been an error evaluating the function, event, or macro.
This is only intermittent and when they close the database and open it again it works fine for a little while and then the error occurs again. As you can imagine this is a major inconvenience for users.
I have searched the web and forums and there just seems to be 101 reasons why this could happen. Nothing has changed on our system which might cause this occur so I don't know why this is happening.
Could anybody provide any ideas on how I might go about trouble shooting it. We are thinking of opening a support call with Microsoft but the error messages are so generic that I'm not sure what help they could be.
Any help / ideas or suggestions would be greatly appreciated.
Many Thanks
View 4 Replies
View Related
Dec 25, 2005
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
View 3 Replies
View Related
Apr 13, 2007
Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
View 4 Replies
View Related
Sep 9, 2005
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
Thanks in advance.
View 3 Replies
View Related
Apr 15, 2007
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
View 1 Replies
View Related
Dec 7, 2005
i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:
You dont have permissions to modify.
If i run it on access 2000 it runs fine.
Someone please help.
View 5 Replies
View Related
Sep 27, 2006
Hi,
A few years ago I’ve made an access database on access 2000. The problem is that now I’ve installed the office 2003, and I can’t make the database work properly.
At first says that are missing those files: “tshoot.ocx”, “msioff9.ocx” and “msowc.dll”; so, I’ve copy them from another computer using office 2000 and now only complains about “msioff9.ocx” saying that my database contains a reference incomplete to it.
Is there no other way to convert my database do work properly with access 2003? What can I do?
Regards
View 2 Replies
View Related
Mar 8, 2007
Hi All,
Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb).
Problem: In the split database, I've saved the Application .mdb as 2003, relinked and made a new .mde. But the Users still cannot open the database. (I did this in a copy until I figure out the nuances with 2007.) The 2 other unsplit databases can be saved as 2003 version and Users can open OK.
I'm grateful for any suggestions on working with Access 2007. I've been trying to tackle the ribbon which is a whole other question.
View 4 Replies
View Related
Mar 30, 2007
Hi
I have an Access 2000/2003 database which opens up and displays correctly in Access 2007, but when I go to use the File>Print command, or for that matter any of the other pull down menu's nothing happens?
Has anyone else experienced thisproblem, or does anyone know what I am doing wrong?
Any help greatly appreciated.
Thanks
Steve
View 1 Replies
View Related
Jan 10, 2007
Hi
I have this Access application. Now I want to see the databases and fields defined.but when I open the access file, it straight opens the access application.
Then when i press Alt+F11, it opens VB Editor. Then when I click on Design mode it comes back to access in the design mode, but still does not shows the design mode for databases and reports and all.
I can remember there is one more step I need to do after getting into the design of the form.But I cannot remember that
Could anyone please help me out
thanks
namit
View 1 Replies
View Related
Feb 20, 2008
Hi,
I am doing some computer work for a company that has an Access 2000 application. This app is split up between a program database that contains the forms, reports, etc. and a data database. Both the program database and the data database are located on a Windows 2003 teminal server. There are usually two or three remote users logged into the terminal server, but this number is about to increase to 6 or 7. I am concerned that these user's will all be running the same copy of the program database. I have read that this can lead to performance problems.
I was wondering if anyone hear thought either of the following would be an improvement:
1. Put a separate copy of the program database in each user's profile on the terminal server.
2. Rather than keeping the program database on the terminal server, put a copy of it on each of the remote client pc's. Then set up a VPN connection to the server and use this to link to the data database.
If anyone could tell me if either of these options would lead to improved performance, I would really appreciate it.
Thanks in advance,
Paul
View 2 Replies
View Related
Jul 20, 2007
I'm wondering if there is a way to open an access database (ive started with a microsoft template for an inventory management database) outside of the access environment. I'd like the program to run more like a .exe file rather than a database, but still having the links to and the functionality of the microsoft database
is this possible?
View 2 Replies
View Related
May 9, 2005
I have written (what I think) is a great database, but when I came to install it I found out that the users I wrote it for did not even have MS access on their computers.
Is there a way that I can save the FE in a different format, or is there a tool, that they can use the FE without having to install Access?
This is the only database / Access they will use
View 2 Replies
View Related
Aug 2, 2005
Has anyone here used Access on a PDA yet?
I'm looking into the possibilities of creating a db to be used on a PDA for people to instantly update records, and then possibly download the data onto a pc to update the main db.
Any suggestions?
thanks
View 3 Replies
View Related
Aug 14, 2006
We have this database which is used by a member of staff for some reason even though the system clock is at the correct time and all other office programs like word and excel save the file and show the correct time. when evre this user saves there database and goes to view the time its showing as being saved an 1 hr behind insted of at the correct time.
Has anyone ever heard of this before.
Phill
View 2 Replies
View Related
Sep 10, 2006
:confused: Can I make my Access database into an .exe file or something like that so anyone can use it w/o Access?
View 6 Replies
View Related
Sep 26, 2006
hi,
can anyone help me i am trying to find a very competitive person, company who can deisgn my companies database for me.
i will behonest i have tried myslef and got stuck,therefore resorting to asking for help for someone to do it for me. lol
it will be a basic database,
all i need is the following:
Customer information.
Accounts(to keep track of payments etc)
orders
deliveries
expenses.
service records
and if possible be able to print off all worksheets etc from the database instead of having them stored elsewhere.
em
View 7 Replies
View Related
Jan 25, 2007
I'm new to this site. I have Access 97 Pro. I have a problem as cited below. I have 2 Access 97 tables called: Name and Activity. The fields in the Name table are: NameID (set to autonumber and primary key) and Name (set as Text). The fields in the Activity table are: ActID(set to autonumber), Activity(set as Text) and NameID(set as number). There is a one-to-many relationship between the tables. Name is the ONE and Activity is the MANY
Have a form and subform; Name is on the form and Activity is on the subform. The idea of this database is to link a name to various types of activities. Each name could have a multitude of activities. There are only about 25 names. I want to make the Name field a combo box so the user can pull down the menu and select a particular name. I also want the Activity field in the subform grid to be a combo box so various activities can be selected easily, probably in alphabetical order. There are some other fields in the grid: date of activity, staff, participated, etc. I'd even like the staff field to be a combo box so a staff name is easily entered (I'm probably wishing for the impossible). The problem I’m having is knowing how to link the two combo boxes so that when the user selects a name, any related activities show in the Activity field in the grid. If there are no activities related to a Name, then the user could pull down the menu and select an activity. Currently I have both the name field on the form and the activity field in the subform as a text boxes. I can enter names and activities and the particular name is connected to that persons unique activities. Using textboxes works fine. My wanting to use combo boxes is my attempt to make the database that much easier for the staff to use. Is there a way to do this? If not, I'll have to tell the staff that it can't or I don't know how to use the combo boxes and they will have to live with the way it is now. Any help would be much appreciated.
View 3 Replies
View Related
Feb 26, 2007
Hello,
I want to do something quite simple to start with and expand on it as my knowledge of databases grows.
This is what I need:
Open Access
Window appears ''Type company name'' and a textbox
Company001 is typed and a new window appears with something like: Add, Edit, view, Switch company.
Next to ''add'' there should be a dropdown list were the user can type in the name or select it from the list (something like if you type the first 3 letters the whole word will come up). Now comes the part which I cant do: i need the user to either press enter or click on a ''go'' button which takes the user to a new form to enter details. Just like the name their typed where a button.
View 1 Replies
View Related
Oct 12, 2004
I need some suggestions on how to put my access database into the web. Here's what I have and here's what I need. I have a database with forms that need to be put on the web so that users can fill out the forms. The first thing that should appear is a switchboad and they can then select which ever form they want to fill out. There's a total of 4 forms right now. If anyone has any suggestions let me know.
View 3 Replies
View Related
Apr 21, 2005
Hello,
I am doing a project in Ms Access for a Restaurant. I am doing their booking system and take away odering system and would like some help in it.
I have created some relationships which I have attached.
I need to find out how can I check the allocated restaurant table bookings
View 1 Replies
View Related
Oct 5, 2006
Hi,
I am recreating a database that have these fields
State, TeamMember1, TeamMember 2, TeamMember 3 etc.
Here is an example that list various names under these columns
State, TeamMember1 TeamMember 2 TeamMember 3
MD John Adams (TL) Lola Mills George Johnson
CA Lola Mills (TL) John Adams George Johnson
For instance, I want to query all the State John Adams visited including the time he was a team leader as well as being a participant in visiting a State when a nother person was a team leader. Can any body help me.
Thanks.
View 1 Replies
View Related
