Multi User Access Database Performance Issue.

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

General :: Multi-User Database Access?

Sep 10, 2013

I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??

View 7 Replies View Related

How To Make Multi User Access Database

Jul 18, 2012

i have build a single user application in access 2010. now i want to build multi user application and want to deliver to end user.how can i make my all vba code safe from end users.

View 3 Replies View Related

Using MySQL BackEnd With Access FrontEnd For Multi-User Database

Mar 31, 2015

If I want to distribute a front end to connect with a MySQL back end ... do I need to set up the system DSN on each workstation that will be using the front end?

View 4 Replies View Related

Multi-User Database

Jan 29, 2008

I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I�m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options

Any help is appreciated! Thanks

View 2 Replies View Related

Need Help On A Multi-user Database

Mar 17, 2008

Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.

I appreciate any help you can provide me on this!!

View 1 Replies View Related

Multi-user Remote Database

Jun 22, 2005

I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.

The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.

View 3 Replies View Related

Multi-user Database And Design Changes

May 4, 2006

My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?

View 6 Replies View Related

Multi-user Database With Security

May 23, 2007

Okay, wonderful gurus! I'm getting ready to split a db and I'm seeking advice or counsel from you. I know how to do this, but want to make sure no one out there has some mystical secret to reveal. What do you think I need to know before I do it? Assume that I've done this before and am looking for little "good to knows".

One MAJOR question I have is concerning the security involvement. I am going to assign a workgroup (security settings) to the db, and I'm wondering how to make sure that both ends are usable with security after the split. I know this is confusing, but I know how smart you all are and I'm hoping you know what I mean.

THANK YOU, THANK YOU, THANK YOU!!!!!

KellyJo

View 6 Replies View Related

How To Create Multi-user Database

Apr 12, 2013

I've read instructions for making a multi-user Access 2007 database. Summary is:

1) Split the database
2) Put back-end part of the split onto shared drive
3) Make copy of front-end of the split and give to each user of the database
4) Open Tools, Options, Advanced Tab. Set the default open mode to shared and the default record locking to edited record. While in options area, go to general tab and turn off compact on close and name autocorrect.

These instructions were posted by an Ms-Access MVP.My questions is about step 4. How do these settings get saved to the particular database that I am trying to make multi-user? None of these settings are in the Current Database Tab for Ms-Access 2007. Since they are in the general tab, does that mean all database I open with my copy of Ms-Access will take on these multi-user settings?

View 1 Replies View Related

Problem With Multi-User Split Database

Aug 24, 2007

Ladies and Gentlemen...

I have had this in another Access forum ... without a resolution. I am pulling out what little hair I have left, so hopefully someone can help me.

I have created a program using MS Access that a small business will use to enter service contracts and invoices. The program was created in Access 2000, but converted nicely to Access 2007 which resides on the 3 brand new Dell computers that the business bought.

I did some research and determined that since 3 people would possibly be using the database at once, I needed to split the database. I did so using the wizard contained in Access. One of the computers acts as the "server" and houses the back-end of the database (in a "Public" folder that is shared to anyone on the network ... with all rights). All three computers have the front-end (forms, queries, reports, etc.) The front-ends all point to the shared "Public" folder on the "server" computer.

In each of the computers, the program will open and work properly. The problem comes when trying to access any of the input forms (that get data from the back-end). Only 2 (and sometimes 1) of the computers will open the form at the same time. If 2 are currently open and I try to open the third, it will sit and crank away as if it cannot find the file. It will not open. If I close one of the other forms, the third will open immediately with no hesitation.

At first I thought it could be a network bandwidth problem, but all are running at 50 - 100 Mbs and shouldn't have a problem opening a simple database file. I can't find anywhere that says Access would limit the number of users to 2; everywhere I look says that a split database should allow up to 10 users at once.

Again, the program works fine ... I just can't get it to open by 3 concurrent users.

Thanks again for any help you can give me.

Mike

View 3 Replies View Related

Changing Idle Time In A Multi User Database

May 24, 2007

There are between 10 - 15 users at one time. It is a shared network, the front_end is on individual hardrives and the tables are located on the server. We just converted to Access 2003, our data file size is 47kb.

Users who are not active in the database get disk or network error message and have to close out. Is idle time a possible factor? Some users maybe entering information sporadically through out the day, but need to have the database open, they may need to refer to a member record upon receiving a phone call.

:confused:

View 4 Replies View Related

General :: Multi User Database With No Network And Without Server?

Sep 19, 2012

I am developing a database for a company with about 10 users of the DB each using the DB on their own PC/Mac.

The workplace does not have a network. All work is done and stored on their own computers. They do not have a server either.

They do have a BT Business Hub providing broadband both wired and wirelessly.

The database is built using Access 2010.

I need to set up user groups/permissions on the database so certain staff can only see certain forms/tables etc...

What are my options here?

There is money available to buy a server or whatever. But ideally if there is another way of storing it and doing it, then I would like to give that a try.

I was reading somewhere you can use the Hub to create a small network, is this possible? And if so, whats the set up process for this?

View 14 Replies View Related

Record Locking - Multi User Worklist Type Database

Mar 9, 2006

All,

Bottom line I'm in bit of a pickle, work has moved forward the migration of Office97/NT4 to Office2003/XP by 2 months (clever lot) and was hoping not have to cram for this question until at least 3-5 weeks.

I'm looking for pointers/suggestions because I now have to test in Access2003 Runtime on MONDAY!!!!

What it is, is:

I have a query which is a list of items that need to be worked out of 65,000.
Of that 65,000, 20,000 end up in the query (Actually do need looking at after an Automated process)
(it's adapting the query/process I think I need)

Query:

EntID - UniqueID for a household
Applicant1 - Number lookup value for Applicant 1
Applicant2 - Number lookup value for Applicant 2
Qualifies - 1 = Yes, 2 = No, Null = Not worked.

That's basic building block of the Query which is Drives the main Form.

What I would like is a scenario similar to this:

Person A opens record 1

Person B opens record 2

Person C opens record 3

Person C finishes record 3

Person B finishes record 2

Person C opens record 4

Person B opens record 5 (he/she took a little break)

Now that's the way I would like it to work, but there will be other factors and this is where I'm all ears for anyone who is used to this type of system.

The problem I can't figure out is that the Main Form has several subforms, but none of the data is to be edited, it is there for visual purposes only.
The users will be creating records via the Main Form through code, but not directly into any tables/queries with which I can use conventional record locking, that I can see.

My thoughts are that Person A calls up a record based on Min EntID and somehow locks it so the Person B looks for Min EntID Where not locked.

--------------------------------------------------
Question Time:

Please, please can someone point me in the direction of how to do it and more importantly the correct order of events?
I have tried doing the Min EntID and locking the record, but while Person A is running the Min Query, Person B is running it also so they end up with the same record as B has the record on screen while A is locking it.

Also,
In the real world Person B might open record 2 and think, nah I can't be bothered.
I would like a proffessional opnion on whether C opens record 2 or should B be made to deal with it.

I think not given the huge time constrants landed square on my lap, I would get there with smaller questions, but I've spent the last 10hrs writing a Function, to get it ready for the testing lab, where the owner has changed the requirements 7 times and my head isn't working.

All or some help given will be GREATLY received.
Any further information needed, just ask.

Hope you can help.

Cheers,

Ian Mac

View 4 Replies View Related

General :: Cannot Share Back End Database Under Multi User Environment

Apr 2, 2015

I have a Access data base (2007) which i splitted and store the back end database in a file server where all users have full control and the individual copies of front end put in the users computers. Unfortunately when one user is using the programme, others can not use. Following error msg appears. Both back end and front end are running under shared mode ( not exclusive ).

"Could not use xxxxxx_Be.accdb; file already in use."

View 5 Replies View Related

Multi User Access

Sep 5, 2005

Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.

They need to each be able to use the database when they need to and read or add data, reports etc.

I am using access 2003.

Thanks

Dave

View 14 Replies View Related

Multi User Problem In Access 97

Aug 20, 2007

hi..

i have used one globle variable ...which gives me a new batch refrence numbers.. but when two users are working same time then ...it gives same number to both of them...i want different number as a result to both of them..
like it will give 37679...to both of them as new batch refrence numbr but i want 37679 and next number 37680 .....

plese help me how i can do this.... i really appreciate your help..
if need more information please let me know...

many thanks...

Nitesha

View 14 Replies View Related

Please Help- Need ACCESS Multi User Info

Sep 2, 2004

Hello,

Great forum

I am a virtual assistant and I have a client that wants to "share" their ACCESS database with me so that I can do data entry. How do we go about doing this? Is there a program that allows me to use the same database as my client and their office people? I would be working from a remote location.

Thanks in advance!

View 3 Replies View Related

MS Access Multi-user Limitations

Sep 25, 2006

We are planning a database application for a client that will need to be accessed remotely by their consultants. We will initially host this application on one of our servers for a few months, and then the client will take it over and host it. The problem we are facing is that this client wants to use ms access as the database, and doesnt want the interface to be web based. The plan was to use data access pages, and let their consultants use a remote desktop connection to access these pages. I don't use access, but I was under the impression that access couldn't really support multiple users hitting the database in this format. Is this correct?

Thanks,
Greg

View 5 Replies View Related

Multi User Appliction Design Using Access

Nov 30, 2005

Hello Experts,

Pl. help me in designing a small application..This app. is to be used by 12 users. We need an application to log time spent by the team in office.so this is a time sheet system. I know how to design a table, a form etc..My question is how can many users share the same database?

Let us say that on my computer I have created the database as db1.mdb. (it has all the tables , forms etc) Now for other users to use this what do I have to do?

Also can MS Access be used to make an application which supports simultaneous use by 12 persons?I mean can it support such an app?

Will be most thankful for your inputs..This is urgent.

N.

View 4 Replies View Related

Access 2000 Multi User Problems

Jan 8, 2008

Hi

I have an access 2000 database which is networked on a 2003server. I'm having problems with multi user access, as some users can't access the dbase unless it is not being used. Other users on the other hand, have no problem at all.

I'm guessing it has something to do with the machine that is trying to access the db. Although, it is not a permissions issue because as I said earlier, they can get access when no one else is using it.

We are all using XP pro SP2.

Any advice would be great as this is driving me mad!! lol

View 9 Replies View Related

Performance Penalty Of Supporting End-user Debugging/verbose Mode?

Dec 8, 2007

For those who work with *nix programs, you can specify -v to get program to tell you more about what it is doing while it's processing which can be useful for end users trying to figure out possible causes for failures/errors/unexpected results. We both already know that there *will* be a performance hit if we were to leave debugging code, so that's not the question. The question is how much performance hit will a VBA module suffer if it has to check whether it should be verbose or not. Suppose we have a complex set of procedures where several routines will be called or maybe several events may occur, so logically, every routine would need to check whether the user has asked for verbosity or not. So,Private Verbose As BooleanPrivate Sub1Do AIf Verbose Then Msgbox "A worked!"End IfDo BIf Verbose Then Msgbox "B worked!"End IfEnd SubPrivate Sub2Do CIf Verbose Then MsgBox "C worked!"End IfEnd SubThat's a lot of If statements, and assuming every routine was executed, that means the VBA had to test for condition Verbose three times for single iteration.Is there any way to reduce the number of checks and hopefully have a final product that performs just as fast with verbose mode off than one without such mode at all?

View 3 Replies View Related

Multi-User - Can You Assign Which User Created/amended A Record?

Aug 4, 2007

Hi guys,

I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...

We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...

Best ideas anyone?

dazza61

View 6 Replies View Related

General :: Multi Users Access Database Gets Inactive

Nov 13, 2013

I have a multiuser data entry form which on using somtimes gets inactive, means the button stop working and we have to close the form and open again to avoid.

View 3 Replies View Related

Database Performance

Sep 27, 2007

I'd like to know whether other users have had performance problems with different versions of Access in a single environment.

In my office, two users are on A2007, and the rest of us are on A2003 or earlier. After some nasty conflicts in the (un-split) database when A2007 and A2003 users were in the same file, I split the database. Now the A2007 and A2003 people have individual frontends. Other than having a garbled LDB file, I haven't had any other conflicts between the two programs.

However, I have had some massively irritating problems ever since I split the database.

1)The Design View on my Front End runs very, very slow (like, five beats after every action to process).
2) If I try to edit one particular, very simple form, it will not return to form view... it is stuck in Design view. (That sounds like the form has been corrupted.)
3) The auto-save doesn't seem to be working... Access (2003) crashed on me yesterday and I lost an hour's work on a new form.

I've tried some of the database construction suggestions to speed performance in other posts - forms based on queries, record locking, short paths, etc., and have seen some improvement in overall performance, but none of these should affect design view. USING the database tends to be speedy-quick.

So, did our dalliance with A2007 mess up my database? Does any one else have experience with this? Or are these symptoms common with a slow network connection (the back end is on a server, front ends are on individual desktops)?

Thanks!

View 4 Replies View Related