General :: Make Changes To A Form While Other Users Are In Database?

Jan 3, 2013

I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms.

At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin.

But if another user is in the database while i am trying to change a form / report, i am unable to save.

I no the simple way to do this would be to do changes whilst no-one is in. Its just some minor tweeks need doing during the day.

View Replies


ADVERTISEMENT

General :: Do Not Want Users To Log Into Database

Aug 4, 2013

The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet that I need to be completed once a fortnight, however I would like it to auto populate the staff members logged information (I will get into that a little later).

Question 1: I do not want the users to log into the database, however I do want the database recognise who they are from their windows logon details.

View 8 Replies View Related

General :: Rolling Out A Database Across Several Users

Jun 14, 2013

I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes.

Is there any way of doing this within the database itself, or do I have have to adjust each form according to the local users PC specification?

View 4 Replies View Related

General :: Viewing Users Of A Database

Jun 1, 2015

I used to have a handy tool called LDB Viewer or something like that with which I could see who is using my database. Now I've upgraded to MS 2010 is there a way to do the same?

View 10 Replies View Related

General :: How Many Connected Users In Database

Dec 4, 2014

I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ?

Is there an easy way to know that?

View 5 Replies View Related

General :: One Database - Two Users In Different Locations

Feb 3, 2015

I'm an absolute novice at Access. I have a very simple (yet sufficient) database that lists our company's projects, tasks associated with those projects and when to invoice.

Our company consists of myself and my business partner. We both work from our (separate) homes. Our project files are stored in the cloud. This works well. We have investigated a server in the past, but found it to be cost-prohibitive and unnecessary for our business.

Is there a way that my business partner can have the Access database running at the same time as me, and make additions/modifications? I don't know how this would work in terms of updating/saving.

View 2 Replies View Related

General :: Allow Users To Access A Database

Oct 27, 2012

I am about to allow users to access a database I redesigned for others to use.I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple.6 tables each with only 4 fields or less... and none are related to one another

7 forms.
1 report.
0 queries... it's just a SKU generator.

When I attempt to save as ACCDE I get an error that reads."Microsoft Access was unable to create the .accde, .mde, or .ade file.This error is usually associated with compiling a large database into an MDE file.* Because of the method used to compile the database, a considerable number of TableID references are created for each table.* The Access database engine can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."

View 2 Replies View Related

General :: Deploying A Database Without Users Seeing Back End

Jul 30, 2013

I have created an access 07 database and split it to a back-end and a front-end with linked tables.

I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across online, the Back-end has to be located on a folder where all users have Red and Write rights!!! And I am thinking, if the users on this network can actually see the back-end since it is on a shared folder where they have all the rights, then does that not compromise the security?

Is there a way of linking to the back-end on a network WITHOUT the users being able to access the back-end?

View 4 Replies View Related

General :: Prevent Users From Modifying Database

Aug 6, 2013

Is there away in which I can protect an access 2007 database modification with a password.I'm doing this because I would like to prevent my client from modifying or having acces to the database's back end system (db), I would just like him to use forms and nothing else.

View 3 Replies View Related

General :: How To Stop Users From Ever Seeing Database Window

Feb 28, 2014

I have included some code to disable the access PassKey (holding shift down as you open the database so that the database window appears). It is password protected and it works pretty well for normal users.

However, I have realised that even in this restricted mode you can go to File-Options-Current database and enable Access Keys. This then lets you open the database window by pressing F12.

My question is, is there a way to absolutely stop anyone from ever viewing the database window at all? All my code is password protected, but I still don't want an ICT person fiddling with my tables and queries!

View 4 Replies View Related

General :: Limit Access To Database To Few Users

Aug 16, 2013

I am using Access 2007. My boss has given me a project to create a tool for our team. I'm done with most part of the project, but for the last part I want editing and updating of database restricted to a few members of our team. However others can access the database and run queries etc. through buttons on a form.

I went about creating a login form for users to get access to the database and in turn created a table with fields UserID, UserName, UserPW and a yes/no field titled IsAdmin. For those who would be limited access would log in as 'Other' user and same as password. I am then using the code to determine if the user should be treated as admin or not by looking up the IsAdmin field in the table. Following is what I have so far, but it needs correction some places and I can't figure where:

Private Sub cmdLogin_Click()
Dim xxAdmin As String
'Check to see if data is entered into the UserName combo box
If IsNull(Me.cboUser) Or Me.cboUser = "" Then
MsgBox "You must enter a User Name.", vbOKOnly, "Required Data"

[Code] ....

View 14 Replies View Related

General :: Multiple Users On Front End Database

Oct 22, 2012

I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse.

However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked'

Is there anyway to allow multiple users to use the front end database at the same time?

View 11 Replies View Related

General :: Preventing Users Accessing Database

Dec 19, 2012

If I need to take the backend of my database offline for changes, what's the best/easiest way to inform the users? Is there some code I can drop into the front end? I'm thinking a "on database open, if [available] in tblClose equals no, then open frmDatabaseOffLine". But I don't know a) if that's possible or b) how to program it.

View 5 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

General :: Split Database - Users Seeing Blank Forms

Apr 10, 2013

I have a split database consisting of an ACCDB backend helf on a shared drive, and a local ACCDR frontend distributed through email. I recently distributed a copy of the ACCDR to a user, and she says that the main menu opens fine, but when she clicks a button to open a form, the form opens but is completely blank. I've googled some possible causes for this (e.g. on Allen Brown's website) and none seem to be relevant, or would explain why this started happening all of a sudden. I can't reproduce this bug at all.

View 8 Replies View Related

General :: Car Park Record Database - Permit For Users

Sep 18, 2012

I am trying to set up a simple database to record vehicles that access our parking at work..Our Car park requires users to have permits to park here but we are continually getting vehicles that dont. We require a database that shows authorised cars and also ones that have been recorded and warned.

Each car will have 3 warnings (Green, Yellow and Red Card) once they get a red card their vehicle is clamped

the info we need is
Car Reg
Car Make
Car Model
Car Colour
Owners First Name
Owners Surname
Permit holder (Yes / No / Expired)
Permit Date issue DOES NOT APPEAR WITH "Permit No"
Permit Date Expiry (AUTOMATICALLY CALCULATED FOR 1YEAR) DOES NOT APPEAR WITH "Permit No"
Number Of Strikes

when the permit expiry date exceeds "TODAYS" date this shows up as out of date and the "PERMIT HOLDER" field automatically shows up as EXPIRED.

View 3 Replies View Related

General :: V2010 / Change Database For Multiple Users?

Mar 18, 2013

How do I change the database for multiple users?

There is no "advanced" option in the options tab.

View 3 Replies View Related

General :: Split Database With Multiple Users - Read Only Kiosk Mode

Dec 17, 2012

I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.

View 5 Replies View Related

General :: One User At A Time - Prevent Multiple Users Accessing The Database

Feb 13, 2015

Twice a year, a database of mine is accessed and put too use by various staff within a time range of 1 week. the database is on a shared drive and in a location which can be accessed by all.

The staff access the database from different workstations and in some instances at the same time.

This has only led to issues in the database being copied and then confusing staff on what database to click on thus i have 2 databases which i then have to sift through and copy/paste into the correct one.

I want to know the best way i can:

1) Prevent multiple users accessing the database at a time.
2) making a copy of the original and typing into a separate database.

View 7 Replies View Related

General :: Split Database - Multi-Users Causing Records To Lock

Apr 16, 2013

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.

The database is split.

View 6 Replies View Related

General :: How To Make Database Accessible (read Only) On Other Pc

Sep 15, 2014

how to make my database accessible (read only) on other pcs?

View 7 Replies View Related

General :: Make Warning Pop Up When User Tries To Access Database?

Feb 5, 2013

How can I make a warning pop up when a user tries to access a database that another user is already in??

View 13 Replies View Related

General :: Inventory FIFO Database - How To Make Transaction

Apr 17, 2013

I want to make inventory fifo(first in first out) db. Example:

February
1- beginning balance : 800 unit @ 6$ per unit
4- received 200 unit @ 7$ per unit
10- received 200 unit @ 8$ per unit
11- issued 800 unit
12- received 400 unit @ 8$ per unit
20- issued 500 unit
25- returned 100 unit to storeroom to be recorded as latest issued prices
28- received 600 unit @ 9$ per unit

The report must be like pic attached

I dont know how to make transaction to do this....

My database in attachment

View 3 Replies View Related

General :: Split Database - Modify Backend File And Make A New Front End

Jun 12, 2012

So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive. This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.

As far as I could tell all I had to do was modify the backend file and make a new front end. However it seems like it is not as easy as I thought it would be. How do you modify a split database without corrupting the files or using a non-split copy?

View 1 Replies View Related

General :: Cannot Open Database Error When Make Table Option Selected

Sep 28, 2012

I linked table rawdata from a database called competitor from a ODBC Database. I run a query with to make a table with a criteria where it retrieves roughly 10 columns with 719,000 rows. And it gives me this error.

(Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.

I asked the creator of the database and they said the database grows automatically and it was created with the same Access version as i am using to run the query.

Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.

View 4 Replies View Related

Access To A Database Form For More Users At The Same Time

Nov 28, 2007

Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file!
What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved