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.
At work we have a terminal services setup for most of the staff which is being configured now. We have hit a snag with access security settings basically we need macros to run for relinking odbc databases and various vba functions (some run overnight so we don't want to deal with the security dialogs). We though the best way to do this would be setup trusted locations. We did this logged in to terminal server as admin hoping this would be a machine level setting but it seems to be on a per user basis.
Is there a way to set a trusted location for all users of a machine I have google and come up with nothing. The other option is enable all macros which I don't want to do.
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.
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?
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?
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."
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?
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.
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!
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"
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?
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.
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.
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.
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.
I've been given the task of combining data from three locations into one database in Access, something that is relatively new to me. I'm trying to decide whether to have the locations enter data into an Access database or into an Excel spreadsheet at each location. Regardless of the program used to enter data, I would probably like to link each of the files to my main Access file and combine the three into one database there. I do not want the locations to add data directly to the main database if possible.
My question is, would this be done by an append query? If so, how? Also, my thought is that the data at each location would be added to every day. I would need to be able to add the NEW data only to the database without duplicating the previous day's data.
I am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right?
just to complicate things i want a system in place. where the end user and use forms to add/remove or modify wine racks.
assuming that all racks are rectangular i would like to be able to add a rack and call it rack 1. rack 1 has 4 shelves all able to hold 5 bottles. the database would then say that bottle X is in rack 1 shelf 1 position 1.
if possible there will aslo be a screen that is auto generated by the database showing a simple grid with grrn and red squares denoting if the position if full or empty. the ability to click on a position to see what is in there or to add a bottle there would be amasing but not fussed if that can't be done.
I have a database with company locations which I want to have on a map. Is there any possibility to embed a map (Goolge Maps or Bing Maps) where it points all the locations of the companies which exist in my database?
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.
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.
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 developed a database in Microsoft Access 2013. I wish to install and run that database on another machine on which I have already installed the MS Access Runtime.
In order to allow the database to run correctly on the target machine, I need to add two Trusted Locations - one for the front-end database and another for the back-end database.
The folder paths on the runtime machine are different to those on the development machine, so how do I add Trusted Locations (on my development machine) which remain valid when the database is copied to the target machine?
Must I trick it by simply creating an identical, dummy folder structure on the development machine (would this even work?), or is there a more elegant way?
I would really like to have a better understanding of the secrurity that comes with access. I would like my DAP to be able to log in with the previleges given for each user. I would also like these previledges to work when someones opens the database with access, however, whenever I set the secureity stuff, copy the database to the fileserver, I can then open it with another computer without any problems. Why is this? Thanks guys, I'n new here.
