I've gotten to a point with my database where I have split it into front and back ends, and then made a copy so that I have a test version and a live version. I have users in live who've started keying data, and I'm working on forms and tables in test that I then copy to live as they are completed. Up to now, I've been just copying the individual item in test, and then pasting it over the version that exists in live (example: I made some changes to a form in test, copied that form, and then pasted over the version of the form that was in live).
Where it gets tricky is that I am also in the process of designing and insurance underwriting feature that's going to be a part of this application. I've set up all the tables in test, and now that I'm working on setting up the relationships, I'm wondering how I'm supposed to copy the relationship setup into live. Am I supposed to be copying the entire front-end from test when I have changes, and replacing the existing "live" front end with it? And if I do that, will I have to edit it every time to keep the new live front end from sending data keyed into it to my test version (had that happen when I initially split it)?
I have a split accdb in Access 2010 with tables/data in the back end file (stored on a network drive) and the forms, queries and code in a front end file stored on each desktop. Note the front end file is common to two back end files. Both back ends will be mirrored but I need to use one for live data and the other for development and testing.
I want to be able to include vba code when the front end is launched that prompts the user to choose between one of two back end files, one 'test' and the other 'live'. But I've spent all afternoon scouring the net with no success on something simple but effective.
As I see it I just need an option on a form and depending on which is selected the following happens:
- links to current/existing tables are deleted - chosen back end file (test or live) is selected (this has a password) - links to the tables of the chosen file are created in the front end - the appropriate back end source is now working with my front end
I have attempted to create a test environment, by creating a blank database in SQL and restoring a backup of the live environment over the blank database (now called test db). I then took a copy of the Access MDB file,and renamed this to testMDB. I then created a new ODBC link to the test db and refreshed the links to the tables by the importing the tables.
Majority of the system works, but I have noticed that after doing this, the forms that access some tables appear to be 'locked', in that no additional data can be added. The page effectively looks greyed out. If data already exists on this tab, then it can be viewed, but cannot be edited. In the live environment, the form shows an additional line is so that more data can be entered if required and any existing data can be amended.
I have attached two screen shots showing the difference.
my issue is i have multilble text box in my form & based on change in one of this text box i need the code to compare between data in the form & table & returm Msg if it is not matching. attached screen FYI.
i look in the internet but i could not figuer out the VBA code since i do not know VBA. what comes to my mind to to use select case.
I have created a database that I am happy with, and I am about to receive information to populate it with. I know I am about to be asked to about security and logging of changes made to the data, which I know nothing about!!
As a result before I get into this part of my project I would like to know myself what is and what is not possible!! Currently I have 2 tables and 3 forms, one of which is a sub form........ All changes will be done via the forms, adding new records, editing existing records or even deleting obsolete records.
•Is it possible to record any changes made to the live data? oFor this to happen I presume that I need to setup users and access rights? •What type of information can be saved if any? oWhat form would this be saved in and where (a temp table?)?
While typing this a change of plan – if it is possible I am going to start building it regardless, as it will enhance my database.
Hello, Right guys, new to access but have experience with MySQL. Basically, i have one table with a few fields, ID, Customername, Rating, Customer_email, Comments, Removalcompany.
I created a query to get all of the ratings from that table, and average them. What i want to do now is put that average into a table and to have it only showing in one record. I have achieved this, but i would like to have it so that the number for the average rating is live.
I am writing reports and queries for an Access database used by a small business. I have a copy of their data and am making the report and query additions to that. Now how do I get my additions to the 'live' system?
Hi guys,I'm new to Access except using it years back but much has changed from the 2000 version to the 2007 version - it's slowly coming back to me though, as it's mostly just an interface change. Although I'm highly experienced in SQL (mySQL) and database design / structure from being a Web Programmer.I'm wanting to store a stock amount for products. Using 3 tables, for products, orders and sales. Here's a real basic layout:productsprodID | productName | productStockordersorderID | supplier | prodID | quantityBoughtsalessaleID | customer | prodID | quantitySoldThe products table is just a list of the products. Sales is where I log what I sell to customers and the orders are what I buy from my suppliers.What I'm wishing to do is use the products table to store the stock of that item so as soon as I make a sale, that quantity for that prodID is subtracted instantly from the productStock and when I make an order it's instantly added.Is this possible, or is there a good way to do this?All help appreciated! :)Thanks,Nick.
I basically want to have a live preview window of the "File Link" attachment in that current record. I have heard it's best to use a Web Browser Control when doing this, but I cannot get it to display the currently attached pdf file in that field of that record.
Is there a way to edit the link properties of the Web Browser Control so that it dynamically detects. The file location of the attached file in that field? There will only ever be one attachment in that field, as this will be a live pdf view of the drawing to which that drawing number was assigned
I've set up a product database in Access for my small business. One of its functions is to track the prices of competing products online.I'm trying to get Access to automatically update these prices en-mass, yanking the data off the websites in question without me having to manually enter hundreds of prices each week.
I have a unique record for each product instance as it appears online. For example, there are three unique records for a 4oz hand sanitizer I sell (one for each of my competitors that sells it). Each record has the price, quantity, and unique URL on which the product appears.I'm not great with HTML and don't really have any programming expertise aside from some pretty simple VBASIC.
Since you can add Calindar in access using activex so that I can select any date and pass that on to a field in a form, is there any way you can add a clock using activex so that I can select any time that I want to put in to a field? any suggestion? Thanks.
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.
Hi guys, i read about this before but it did not work.
i am trying to hide the access environment but i couldnt. i read in this forum that if i have a bmp with then same name than the db, the picture would replace the access environment. I have done this but the only thing that i achieved was to see the picter before access env. comes and then it desapears and the access env. shows up.
I was wondering if anyone would be able to help me here.
I have a database created in Access .MDB. It operates allright on my machine. However, since this database is done for my client, i have a problem i need to ask for help.
My client doesn't have microsoft office software installed on their machine. So when i passed the database onto them, they somehow can only run it in the run-time environment. Don't ask, I'm not sure about this at all. Anyway, They came back to me saying that they have got a run-time error message in the middle of running the database.
On my end, it's hard for me to debug since it works fine here. I was wondering if anyone would be able to tell me how i could have this database run in the run-time environment as my clients do. This way, i could debug the problem.
Is it possible for me to run my access database in run-time environment? how do i do that?
I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval.
Is it possible? If so, how do I configure my access database?
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.
Hi, Im working on a database that has to be shared by 3 or 4 users. In on of the actions that the database performs, it has to delete records from a table first. When sharing the database, it always asks the users (using access viewer) whether 'they are sure that the want to delete the records'. Does this always happen? And why? How can I get rid of it? Would it matter if I change it from a table to a query?
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.
I am currently using the SetValue function from within a macro to set the value of one text box to the value of another. It works fine under full version but when I use it under Runtime which is where the final application will be run from, it brings up the Halt box and will not continue the macro. Does anyone know what can/cannot be done within Runtime. Is it just the same as A full version but without Design functions or are some other functions removed. I am painstakingly having to go through all the vba code that I wrote in full version and I am having to change so many things in order for it to work with Runtime. This is a real pain the backside! Any thoughts would be huuuugely appreciated.
Can anyone give me some ammo to tell me boss what a safe number of users of an access database is. It is a well built database that runs quickly and effiecently but I need to know at what point this will be put at risk. 100 users? 200+? I am running the database a FE/BE with the client sitting on each users pc and the BE sitting on a server. The network is 10/100.
I am using MS Access 2000 in a Windows Terminal Server 2003 Environment and the performance is incredibly slower than running the same job on a Stand Alone CPU with Access 2003.
Any idea? Access 2000 is running slower on a TServer? May the Access version difference explain the difference?
I've been asked to make a 5 questions test to evaluation potential new employees' knowledge of MS-Access. Honestly, I need your input on what to ask. The goal is not to make a very hard test, but rather to see if somebody as at least basic knowledge of SQL and Ms-Access.
Some background information of what we do with MS-Access We use MS-Access as a central hub for different download from different systems. We make a lot of daily imports. We export queries in Ms-Excel. We open it from Access and format the report. We make hundreds of reports every day. We don't really use forms or reports.
What questions to ask? I was thinking of having 2 questions about SQL. One simple query with a formula, and a query with 2 tables (perhaps a left join). On what should my other questions be?
