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