I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's. But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Is there any way to add a dropdown box or something that determines that a subrecord is active/completed, and then have a way to jump straight to the one that is active by clicking a button on the record? In the example I attached, I want to be able to click on the button above the tab and have it switch to that tab and open the first record it finds that has "Active" selected.
I have a small Help Desk db with tables that contain computer spec and user information. But I already have all this information in Active Directory and it seems pointless entering the information twice.
Is there any way i can get the database to lookup the information from Active directory i have no idea where to start.
I have built an automated procedure in VBA Access 2000 that is now great (thanks to a lot of downloaded help from this forum). I use the MSCOMM active-x control to talk to an instrument via the serial port.
Question: Is that control only working because I also have VB6 installed on this same computer? It seems to me that I tried something like this a year ago and could not get MSCOMM to work in Access, but at the same time, I didn't have great MSCOMM examples to go by. I do now as I could rob them from other programs my company has written in VB6.
I have both VB6 and Access 2000, but chose to develope this procedure in Accesss because of the heavy amount of data to store (and I know VBA much better than I do VB6). I thought Access is a natural. But now I am wondering if I will have problems distriubuting this database to other service offices that may not have a machine with VB6 on it?
Do they need just plot MSCOMM32.OCX in to their system32 directory?? :confused:
I have added an Active X control to my form. The active X control is Inventor View which is for viewing 3D drawings. At the moment I can get it to work and show one particular drawing using a filepath put in the filename property.
However, I want to save the filepath for each record in the table and then change the filename property of the Inventor View to this according to the record that is open.
I have tried searching for similar threads but still can't quite get round it.
What data type should I use to store the filepath and how can I get it to change the filename property of the Inventor View control.
I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.
I would like to query this table to provide a list of active members between a given range of dates.
For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.
I've been trying to animate in access forms by using active X controls but my access 2003 does not have Microsoft common control dialog version 6.0 and does not have microsoft animation control 6.0
theres .CAB file available from microsoft website but its self extracting not self installing so i wouldnt knw exactly which directory to place it
Apologises if the answer is out there somewhere but I have searched to no avail.
I have a number of Forms which the user can jump around from one to the next. All the forms remain open with the form they are currently viewing showing on top. If they make a change on one particular form then when they return to a previously viewed form I want to disable or hide certain certain controls etc.
I know this would be simple to do on the on open command but as previously mentioned as I am not closing the forms after they are viewed, if the user returns to a previously opened form then this is not picked up.
Soooo, basically I'm after something like
When the user moves from one form to another already opened form for the new form to immediately know that it now has the focus and for it to do something along the lines of on open.
I have a form with two sub forms and when I enter data into one of my subforms I get this error?
A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access.
I've checked the relationship and linked child / master fields and it looks ok. Does anyone know what could be causing this?
I am getting this error on a couple of different PC's running WinNT4 and Win2000.
Shutting down doesn't help and I don't get this with other databases. When I open the form (subform2) on its own I can enter data, just not when it's part of the main form?
I have a form that has invisible fields. Depending on the navigation to the form, those fields are turned on/off using the visible command.
However, the tab order on the form always takes the user to the first field visible on the form.
How can I tell access to default me a specific field first.
i.e. I have chosen to amend a training file via payroll number. I would like the payroll number data entry box to be the active field when the form opens.
Please can someone advise me how I can link the date which I select in the calendar control to a date field in the form. I want to use the calendar instead of a combo box. It's probably simple....but then so am I! Help appreciated Richard
I am working on a project where I need to monitor employees who are on vacation. I would like to run a report that would show employees who are currently on vacation, and those that have already returned. This is the information that I am looking to get from the report.
Search Dates: Entered criteria thru qry, msg windows asks for "start date" and "end date". 1/01/05 - 1/31/05
tblName John Smith
tblEmployee# 1234
tblDate left (on Vacation) 12/25/04
tblReturn Date 1/25/05
Days on Vacation 31
tblName Tina Roberts
tblEmployee# 1243
tblDate left (on Vacation) 1/25/05
tblReturn Date (If the employee has not returned it would give the "end date" and calculate the days on vacation) 1/31/05
Days on Vacation 6
This may seem simple but I just can't get the qry to show dates beyond the "start date" and "end date". Only those records that start within the two dates.
when i select a button from the active control menu and want to use that button for either next record, previuos record. attach macro, print, i am sure that was part of the menu when selecting the button. i am not seeing that menu when i select the button from the active control could you please tell me why
I have a form to add data. I have a cmdbutton to output a shapshot of a report via e-mail. I have noticed that the shapshot does not capture the data I have just entered on the active form unless I don't first close the form.
Is there a way I can capture these active records?
I have created a form that will print the active report. I have managed to make it look for the active report, but it won't find it because there's no report active, even though I have the report open. How do I make my report be active when I open it? (In a way that whichever report I open will become the active window so that my form will e-mail the report that is currently open)
Please can someone tell me how to change the back colour of a control when it has the focus and then revert to the original colour when it loses it. I have 35 controls on my form, so I need a function, rather than changing the colour with a subroutine evey time.
I have searched the site and haven't found whatI want-though I'm sure this question has been asked before.
I has install office XP but when I creat form I has problem: Active X component can't creat object I don't know to correct problem please suggest to me
