Possible To Have Multiuser Working On Same Access File?
Feb 8, 2012Is it possible to have multiuser working on the same Access file?
View Replies
ADVERTISEMENT
Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File
Dec 27, 2014 I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
Access In A Multiuser Environment
Nov 17, 2004Has 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.
Slow To Access Multiuser DB On Server HELP
Dec 16, 2005I 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
View 2 Replies View RelatedAccess 2002 Multiuser Environment
Jan 3, 2006Hi!
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?
Jak
Access DB - Multiuser Editing At Same Time Possible?
Oct 30, 2013We are trying to cut down the # of spreadsheets we have and took a purchase tracking spreadsheet and turned it into access db (2010).
We have 3 sites, and users across network would be 1-2 at max might be in db at same time either recording a purchase, or updating a record on received items.
Can this cause corruption? Is there a way to set users up so it won't?
I know in older versions of Access there were shares that could be set up.
General :: Building Multiuser Apps With Access?
Aug 6, 2014I've always setup Front Ends and Back Ends so that a copy of the Front End is distributed to each Desktop.
I've now joined a new company (been here 6 months now) and the way things are done here is that one copy of the FE sits on a share and users open it from that location. This file contains no local tables and all data is connected to either Access or Oracle databases using ADO. The FE has built been utilizing User Defined Types to read all data in to memory.
Access 2000 & MSSQL 2000 Multiuser Problems
Aug 20, 2007Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
File Dialog - Stopped Working.
Jun 22, 2005Hello...
This should be an easy one for many of you..
I have the following to code to let the user select a file..
It worked before but suddenly stopped working...I remember adding some reference but I dont remember exactly the name of the reference..
After I did this, I converted the database from 2000 - 2002/2003 ..back and forth...I did not change/remove any references.
I have access 2003 but my database is in 2000 format because my teammates have 2000.
Thanks in advance for the help.
-------------------------------------------
Dim fDialog As Office.FileDialog
Dim varFile As Variant
' Set up the File Dialog.
Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
With fDialog
' Allow user to make multiple selections in dialog box
.AllowMultiSelect = False
' Set the title of the dialog box.
.Title = "Please select a file"
' Clear out the current filters, and add our own.
'.Filters.Clear
' .Filters.Add "All Files", "*.*"
'.Filters.Add "Access Projects", "*.HTM"
'.Filters.Add "Access Projects", "*.HTML"
'.Filters.Add "Access Projects", "*.DOC"
'.Filters.Add "Access Databases", "*.VST"
'.Filters.Add "Access Databases", "*.VSD"
'.Filters.Add "Access Databases", "*.TXT"
'.Filters.Add "Access Databases", "*.MDB"
'.Filters.Add "Access Projects", "*.XLS"
' Show the dialog box. If the .Show method returns True, the
' user picked at least one file. If the .Show method returns
' False, the user clicked Cancel.
If .Show = True Then
'Loop through each file selected and add it to our list box.
For Each varFile In .SelectedItems
DocsPath_TB.Value = varFile
Next
End If
End With
End Sub
---------------------
General :: Command Button Not Working In ACCDE File
Oct 19, 2014I have created an accdb file and saved as an accde file. The accde file opens with a form with command buttons. But the commands buttons do not work with the accde file (they do work with the accdb file). How do I get them working.
View 7 Replies View RelatedModules & VBA :: Shell Command Not Working With Spaces In File Name
Oct 21, 2013I am in trouble with the shell ocmmand,i have a text box "ExcelPath Location" in which there is a path of excel file i am using below code to open the excel file but it gives an error:
Code:
Private Sub Command11_Click()
Dim str As String
str = ExcelPathLocation.Value
strPath = Dir(str)
Shell "excel.exe" & """" & strPath & """", vbNormalFocus
End Sub
the value of text box is
O:QA FilesQC ReportingPending ReviewB329129)419479_BoxPort_RAMANDEEP BRAR_(10192013.xlsm
it gives run time error : 53 file not found.
MultiUser Environment Help
Oct 5, 2005I 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.
Multiuser Enviroment
Mar 16, 2006Hello to everyone!
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.
Something like this:
docmd.openquery "Query1"
docmd.openquery "Query2"
docmd.openquery "Query3"
etc.
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?
Thank you in advance,
gile2004
Sorry for my bad english... :)
Multiuser Issue
Sep 15, 2006I 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
strSQL = "INSERT INTO USER_LOG (userID,dateEntered) VALUES" & _
"('" & Environ("Username") & "',#" & Now() & "#)"
'save userEntered so userExit can be updated to the right record
'this will be used to query the right record when the user exits
dateEntered = Now()
Set objCommand.ActiveConnection = CurrentProject.Connection
objCommand.CommandText = strSQL
objCommand.Execute
Set objCommand = Nothing
formload_errhandler:
MsgBox ("Application has encountered an expected error")
Resume Next
End Sub
MSACESS Cannot Multiuser
Jul 17, 2007Dear 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 ?
Thanks in advance.
Cannot Close DB In Multiuser Environment
Mar 17, 2006When users try to close Access 97 databases (and this happens in several offices) we sometimes get the following three messages e.g.
Couldn't save; currently locked by user 'Admin' on machine 'CSL600'
Followed by
The Save Operation Failed
Followed by
Out of Memory
Any solutions?
Need Help...Multiuser Database Question
Apr 18, 2005Hi-
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?
Thanks,
Derek
Record Locked In Multiuser Environment
Jun 3, 2006hi,
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.
Any help is appreciated.
Prodigy.
How Do I Prevent That I Can Open My (multiuser)database Twice?
Feb 18, 2008I need some code that checks if i already opened the database. I can't use the /EXCL option because 10+ people are also using it.
I had this code when working with Acc97 but i seem to have lost it.:(
General :: Mail Merge Word File (using Data From Access File)
Mar 11, 2014I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
Form Buttons Act Differently In Multiuser Envirnment
Aug 4, 2005We recently put together a database for a call center. The file is located on a public drive, and all users seem to be able to access the file (at the same time) and input new information.
On one particular form, I've found an interesting problem: I've placed a button at the bottom of the form, which will go to a new record when clicked. The command to go to a new record is clearly in the OnClick event, however users in the call center have to click twice in order to execute the code. I don't have to.
We're using the same form, in the same file, opened with the same version of Access.
What's wrong with this database?
Thanks for any help you can give me,
Double-Clicking,
Andrew
Backup Current Access File Using Vba While The File Is Open
Jul 11, 2007I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
Does File Server Hosting Back-end Mdb File Need To Have Access
Nov 15, 2013I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.
Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?
Modules & VBA :: Multiuser Split DB - Code Causing Occasional 3049?
Dec 2, 2014I 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.
Access 2003 Buttons Not Working In Access 2000
Sep 14, 2005Hi,
I've created a database in access 2003 with the default file format being Access 2000. Everything works fine on my computer and many others, all of whom are running different versions of access (2000, 2002 & 2003).
I have not had any problems with this database until recently and in the last few weeks we have had 2 users, both of them being Access 2000 users who have had the same problem.
The problem they are having is that when they click on any of the switchboard items, the buttons depress an then come back up again when the cursor is moved away, but nothing else happens - no action, no error message - nothing!!! Its the same for all of the buttons on the switchboard.
Does anyone know what is causing this? I have another computer with Access 2000 on it and this works fine, as it does on several other computers runiing Access 2000, I just cannot understand why it is not working on these 2 particular machine.......
Many thanks in anticpation.
Steve
Access 2000 Database Not Working Under Access 2003
Dec 7, 2005i 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.