I have a multiuser split db with this code on a listbox:
Code:
Private Sub lstsearch_DblClick(Cancel As Integer)
' The following is the variable definition for the error handler
On Error GoTo lstsearch_DblClick_Error
Dim ErrorForm As String
Dim ErrorControl As String
[Code] ....
The error function sends me an e-mail listing the error, user, form and sub. Ocasionally some users get error 3049 when running this sub. It is generally one user out of about 10 or so and the db keeps working fine for everyone else. I have reviewed the back end several times and I cannot find any obvious corruption signs. I have compacted and repaired it several times with very small changes is size.
I've got a database in Access 2007 that keeps track of client data for work. It's been working fine for about a month, and suddenly today other users can't change any information because the records are suddenly locked when accessed from their accounts.
I've already checked that they can't update forms, tables, nothing.
I've checked the database properties, it defaults to shared with no locks.
I've checked the properties of my forms - no locks.
I've double checked the permissions to the folder that the database is in - no restrictions.
I have a database that I've split and have deployed to 7 persons.
The thing is, I have three (3) forms:
Form 1 Form 2 Form 3
...that require changing a portion of a line in each form's respective VBA codes. I need to change the directories to where an excel workbook is stored after exporting, and another is where same excel is moved to after being uploaded.
At the moment, during deployment I have to manually change the directories.
I was thinking of maybe a pop-up form with four (4) fields that allows the user to select his/her name at the start-up of their frontend app, and paste the directories in the other text boxes provided.
This information will then be used to replace the directories in the VBA.
If I were to make changes and have to redeploy, I would have to do everything manually again.
Is there a way around this occasional problem with and combo box using a select query in Access 2000?
The query in Row Source is: SELECT [qryCSZ].[pcID], [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip] FROM qryCSZ ORDER BY [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip];
The problem occurs when I enter a pcID number and Access will display the first string of numbers that begin with the entered number that comes up in the select list .
Example: pcID City StProv Zip 53 Addison IL 60101 206 Alsip IL 60603 5 Anywhere IL 60nnn
Using this example, if I want to choose Anywhere and enter the value 5 into the combo box, Access finds the first occurrence of 5….. and puts 53 into the box. If the user is not paying attention they get Addison instead of Anywhere.
Its almost like Microsoft Word finishing a word for you.
I'm trying to have a command button send info on the form straight to Outlook as a meeting. So far, the code below works apart from the address bit. I need the code to automatically add the same 2 email addresses as recepients everytime.
Error message highlights the red line below with the following message:
Runtime error '438' Object doesn't support this property or method
I'm new to VBA, so don't understand what is wrong here. The reference is set, I've tried different permutations of the "To:" & "Recipients.Add" for the email address with no joy.
Code: Private Sub cmdSend_Click() Dim outApp As Object Set outApp = CreateObject("Outlook.application") Set outmail = outApp.CreateItem(olappointmentitem)
I've got a Split Database (Front End & Back End). So far it was all good until recent when a department placed in a different city (200 Miles apart) wants to use my application. The Application has gone very slow for them when they access the back end.
Things which I've already done. Analyzed Tables Analyzed Performance
The only best way I could think of is to have two separate Back Ends for both cities and synchronize them may be every hour or so. Is this possible and how much feasible is this? Or is there an even better way to accomplish this.
I am having some major problems so i thought i would ask you guys out there for some help because i am starting to bang my head against a brick wall.
I have a simple database, well i have 3 but the problem is only occuring on 1. each of these databases sit in a shared folder on the company network. I am trying to allow multiple users access this database but every time a second user tries to open the database they are unable to get access and receive this message
The table 'MSysAccessObjects' is already open exclusively by another user
However i have set the default open mode to be shared.
can anyone help as i really need this database to open in shared mode.
This is my first post but I am reading this for a while now and I learned a lot from this site. Now, I have a problem which I cannot solve and I hope that you can help me with some advise.
I designed database for production proces calculation and for warehouse management. I have BE and Fe which are on server and every user has the copy of FE for himself. FE is also on server. Maximum number of concurent users is 3. The problem is that sometimes I get wrong calculations.
For example, when someone click the button for finishing the production process, calculation of production cost goes wrong. But, that is not happening everytime. Let's say one of the 10 calculations goes wrong. I tested aplication localy on my computer and everything is working normaly. I also tested the database in network enviroment (in my house, BE on one and FE on second computer) and everything is also working good.
I have to mention that this factory is rather old and we are constantly experiencing power loss or voltage disruptions. And also I have to mention that network cables are not installed profesionaly. We bought several aditional UPS devices to secure the network from voltage disruptions and now I will test the database again. But, any additional help would be appriciated.
The strange thing is that I never get any kind of error message. Everything seems to work good, but when I look at the numbers I can see that some of the calculations are wrong.
And just one more thing. In my database I have some procedures which are based on several queries which are executed one after another.
In some places I have up to 7 queries which are executed one after another one (first query deletes the data from table, second one makes the initial calculation, thirdone updates the warehouse data, fourth is calculating the new price, etc.) Maybe this is the problem?
I have split my db and distributed the FE to client pcs while BE is on the network. To demonstrate it i have 2 users , userA who has read/write rights on the shared folder where BE is while userB only has read rights on the shared BE folder. When userA opens the FE he can get in(writing userinfo in the table on the OnLoad event) but when userB gets in the FE opens fine EXCEPT he gets the error that there was an error on the OnLoad event, which i am fine with because userB doesnt have right access to the db yet. But now if the FE is closed by both users and this time when userB logs(read rights only) in before userA(read/write rights) he gets in with no error on the onLoad event but now if userA logs in he is shown the same error on the onLoad event!!! i am totally lost as to what i have missed, can someome help? this is my code on the onLoad event in the FE:
Private Sub Form_Load() On Error GoTo formload_errhandler Me.InsideHeight = 5000 Me.InsideWidth = 10000 DoCmd.Maximize Me.picBox.Height = Me.InsideHeight 'authenticate the logged user Dim userName As String userName = Environ("Username")
'check to see if username is in the SECURITY table Dim objRS As ADODB.Recordset Set objRS = New ADODB.Recordset
With objRS .CursorLocation = adUseClient .CursorType = adOpenKeyset .Open "SELECT * FROM USER_SECURITY WHERE userID='" & userName & "'", CurrentProject.Connection .ActiveConnection = Nothing End With
If objRS.EOF Then MsgBox (userName & ", access denied") userAuthenticated = False DoCmd.Quit Else userAuthenticated = True End If
'at this point userAuthenticated is true 'log the user in USER_LOG table updating userID,dateEntered fields Dim objCommand As ADODB.Command Set objCommand = New ADODB.Command Dim strSQL As String
Dear All, My company have an application that is using Microsoft Access for the database. The Application created by VB.
Because of server hardware failure, I have to reinstall the server (OS Windows XP) dan also the Microsoft Access. Now my application cannot run in multiuser anymore after reinstall the server. My applcation still can run in client computer but cannot run simultaneously in several client computer, because if one client computer has access the database in server, the other client computer cannot access the database, raising error inform that the database already open by other user. what should I do to solve this problem ?
I am using Access 2010 in a split database. The intent is to place the back end and associated linked files on a server and the front end on work stations for each user. The typical user will just be searching for information in the database not altering it. My current code re-links the tables once the path is known i.e. I have to hard code it into the global constant. Is there a way in VBA or utilizing VBA to read/write to an ini file (for example) that the UNC path would automatically be updated to a global constant in my current code that can be updated automatically based on where the back end is installed.
Global Const BE_DATABASE = "192.168.2.3FMCENFMCTABLES.accdb" Global Const BE_PASSWORD = "***********" Global Const BE_DATABASEPATH = "192.168.2.3FMC" 'used to open files Public Sub CreateDatabaseLinks() On Error Resume Next 'new Dim ws As DAO.Workspace Dim db As DAO.Database Dim td As DAO.TableDef
The file is huge with many sections (eg Names, Address) in it. What I need to do is load it into Access for some analysis.Is there a way I can split the file one loading to the system into multiple tables?
Code: SELECT tblZlecenia.ID_Zlecenia, tblZlecenia.TerminOdbioru, tblOffset.ID_RodzajZlecenia, tblZlecenia.NazwaZlecenia, tblZlecenia.Id_K, tblZlecenia.Id_Rodzaj_Pracy FROM tblZlecenia LEFT JOIN tblOffset ON tblZlecenia.ID_Zlecenia = tblOffset.ID_Zlecenia where
I have a form in a database that is just a look up form (you cannot add or delete records). How can I prevent this (see below or attachment) from happening?
************************************************** ******* 'FormName' has been changed since the last time you opened it, either by another user or because another instance of it was opened on your own machine.
Do you want to replace the changes that you or another user made?
*To save your most recent changes and discard the user's changes or your previous changes, click Yes. *To save this version of the object with another name, click No. ************************************************** *******
What's the best way to handle multiusers and forms? The database is split but sending the front end to all users is not an option. I've tried different settings thru the Record Lock...Locked fields...Allow Edits/Additions/Deletions...and we still get this message. I've tried adding 'DoCmd.RunCommand acCmdSave' to a timer. It doesn't help. I am at a total loss...does anyone have any ideas?
Has anyone deployed or is anyone using an access database in a shared drive environment over a network? If so, how is the databases performance and what kind of problems/headaches do you encounter in this environment? Thanks.
I need writing a function to split the image names. In essence, I need to create a separate record in a related image table. I have searched over and over again I can't seem to produce the results I need.
I would like to review the records in query so that I can add criteria before appending them.
BV-GB bv-gb.jpg CSO-C sso-c, cso-c, eso-c.JPG
The number of images for each product varies as well.
My database was working fine until I split the database and now I'm having issues with this function:
Code: Public Function OpenFirstAttachmentAsTempFile(ByRef rstCurrent As DAO.Recordset, ByVal strFieldName As String) As String Dim rstChild As DAO.Recordset2 Dim fldAttach As DAO.Field2 Dim strFilePath As String Dim strTempDir As String
[Code] ....
It's getting stuck on the "strFilePath = strTempDir & rstChild.Fields("FileName").Value" line. The debugger says that there is no reord. The strTempDir is correct. I am assuming that the issue has to with linking to the database.
I not a big time DB person so please be gentle. I am a computer technician at a school district and need some help. We use a program called Aeries made by Eagle Software for out attendance and grading. It uses an interface that runs through Microsoft Access. There are two version of this software. One is the SQL version and the other just uses an Access DB on a server. We have the Access DB version running Access 2003. It was explained and accepted in the beginning that we didn’t really need the SQL version because of our district size which is some where around 1500 students. Our district consists of 6 school sites that are all connected with a fiber optic backbone running at 200mb with a minimum of 100mb to each desktop. We have a DB for each site running on 1 very beefy server in a central location. I’ve run my problem by the software maker and don’t feel like I’m getting much help. The problem I am having is slowness during login. When the first user of the day attempts to login the program is fast, about 10 seconds from “ENTER” to the main menu. As soon as that 1st user clicks one of the menu buttons anyone else who attempts to login to that database after that experiences at least 30 seconds from “ENTER” to the main menu. I’ve watched what files are accessed and when. I see that when the 1st user logs in, the systemxp.mdw file is accessed and a systemxp.ldb file is created. Then when the user clicks a button on the main menu, the sch05xxx.mdb is accessed and a sch05xxx.ldb file is created. The sch05xxx.mdb file is the main database file for any particular site. The “xxx” would be the site number. As soon as that file is accessed or that lock file is created the user will experience the long login times and sometimes as long as 4 minutes. I don’t believe this is a hardware problem. During the same time that users are slow I have made a copy of one of the databases onto the same HDD on the same server and as long as I’m the 1st person to open it, it will fly. The 2nd person is slow just like the rest. I also don’t think it’s a permission issue, at least not in the domain. I’ve run all these test logged in as myself and have Domain Admin rights to everything. I believe this is a “split database” with the tables on the server and the forms, and queries on the users computer. I read an article here, http://www.microsoft.com/office/previous/xp/columns/column05.asp called “Why is Access 2000 slow for more than one user?” Has anyone else had this problem or have a solution? If I’ve missed something and you need more info please let me know.Thank you for your time and I appreciate any responsesJohn
Hi! I have constructed a database in Aceess 2002 that four persons or more are going to work with. The users have there own computers in the same network. And they are going to work in the database at the same time the database is placed on a shared drive in the network. They must have the possibility to work in the same bookingformular. Is there something that I have to think about so that everything works allright? I mean in the multiuser environment. I had a lot of problems when rhe same people worked with an Access 97 database, But I hope that Access 2002 is better for multiusers. Is that correct?
hi, am trying to create an application for a company that has a small call-center (strength 20). the db is in the central server and each caller sits with frontend on their computer. the central DB is shared on the network which these 20 PCs are accessing.
The frontend: 1 Form only which is based on a query that displays records. Form Lock property: Edited Records Query Property: Edited Records
As the telecaller starts calling the customer looking at the records, they are not able to edit certain records as the respective record is locked by MS-Access when am sure that no other telecaller has opened the particular record.
