Run Access In Run-time Environment
Aug 17, 2006
Hi,
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?
Thank you in advance
View Replies
ADVERTISEMENT
May 30, 2006
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.
any suggestion?
thx max
View 4 Replies
View Related
Nov 17, 2004
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.
View 1 Replies
View Related
Jan 3, 2006
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?
Jak
View 3 Replies
View Related
Jun 7, 2007
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?
Any idea would be appreciated.
Thanks!
View 4 Replies
View Related
Dec 8, 2014
I am developing a small database for use in a multi-user environment: I have split the tables off and am testing with two copies of the front-end on different machines. All seems to work well except on one form.
On this form, the value of a bound control (exposed as a number of radio buttons) is used to make related controls on the form visible or invisible. I use the AfterUpdate event to trigger appropriate VBA code to accomplish this; it works well.
However if two users have the same form open at the same record (unlikely, but not impossible), and User A changes the value of the control via the radio buttons, Access will eventually propagate the change to User B's copy of the form but the AfterUpdate event will not be triggered and the form becomes inconsistent. I understand that events are only triggered when a user makes a change to a control; how can I be alerted when Access makes a change?
View 4 Replies
View Related
Oct 26, 2005
I have just been told that we shouldn't be using Access to build databases for sharing information. Instead it should only be used to build single user databases.
Please, give me some ammunition to show what a stupid statement this is!! :eek:
View 14 Replies
View Related
May 6, 2015
how to be able to enter time in access form the same way as if would be an access table (1p = 1:00 PM; 1.25 = 1:25 AM etc)
View 1 Replies
View Related
Oct 5, 2005
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.
View 14 Replies
View Related
Mar 17, 2006
When 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?
View 4 Replies
View Related
May 22, 2007
Hi,
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?
Please help.
Thanks!!!
View 13 Replies
View Related
Jul 10, 2007
Just updated to Access 2007 from 2003 and my app does not pull in any environment variables. =environ("variablename")
Anyone else have this problem?
View 5 Replies
View Related
Mar 14, 2008
1) I develop my application(Ms-Access 2k) and put into company network directory.
2) The problem here is only 1 user allow to access per time.
3) Is there any setting I miss out?
View 4 Replies
View Related
Oct 4, 2005
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?
Thanx,
Stacey
View 5 Replies
View Related
Jun 3, 2006
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.
Any help is appreciated.
Prodigy.
View 3 Replies
View Related
Nov 15, 2006
Hello all,
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.
Thanks all!
Gareth
View 1 Replies
View Related
Jan 10, 2008
Hi
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.
Thanks folks.
View 8 Replies
View Related
Jul 2, 2015
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)?
View 3 Replies
View Related
Jul 28, 2005
I'm in the process of rolling out a new database that will require some data entry from approximately 35 users.
I have been told that database corruption WILL (not might) occur if more than one user is in the database at a time, which I find hard to believe. I was told that if multiple users who have different permissions levels are in the DB at the same time, this will cause corruption.
Has anyone heard anything like this?
Also, there will only be one or two forms that my users will be using for data entry. The rest is report running. If I set the value Record Locks on the form to EDITED RECORD, will this prevent corruption?
Any input you could provide is very much appreciated. I haven't been able to find any info specific to this issue.
View 1 Replies
View Related
Mar 21, 2005
I have multiple users entering data on bound forms. I have three required fields, all in the first 3 fields of the form. My question is, can I program something to where Access will update the record, after the 3rd required field, so that other users are not having to wait to enter there new record?
View 1 Replies
View Related
Mar 21, 2005
I have multiple users entering data on bound forms. I have three required fields, all in the first 3 fields of the form. My question is, can I program something to where Access will update the record, after the 3rd required field, so that other users are not having to wait to enter there new record?
View 14 Replies
View Related
Mar 18, 2013
I copied Students application in Access 2007 and modified it to fit needs of a school for students with disabilities. I know absolutely nothing about macros, so where needed I substituted VBA. It is now a mix of macros and VBA. But now I cannot post values from a combo drop-down list on the second tab. I get a "boink" sound when I try to post the selection. I have adjusted the properties of each combo field to match where it was successful before and tried again. No results.
The fields are located on the second tab which lists contacts for the student. The proper values show up in the drop-down list. It is just that the value chosen will not populate the field.
I have used combo boxes extensively before, but never in a macro environment.
View 4 Replies
View Related
Jul 23, 2012
I would like to know in what type of working environment everyone works. i.e. an office with a closed door, a cubicle with high walls, shared cubicle, low-walled cubicle.
View 2 Replies
View Related
Jun 20, 2013
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.
View 1 Replies
View Related
Feb 15, 2015
I have an Access database (.accdb) that has table, form and report. The field in all are the same. The user interacts with the Form only and enters data to it. Table is a back-end thing and no-one goes to it. However, in Form there is a button that when pressed, prints the report for that relevant form/record which we then give to customers.
Now, I have a field in report (like a signature field) that mentions the name of the user who printed that report. Lets say, Mr X did the data entry and then printed the report and gave it to the customer. After that customer loses the report and comes back for a copy of the report, but now Mr Y is at the desk and issues the report. Obviously Mr Y doesn't have to do the data entry again because record is there and Mr Y has the access to it, so he just presses the print report button and prints the report. What I would like is that the signature field should update itself if anyone else (in this case Mr Y) accesses the database and prints the report for that specific record.
View 2 Replies
View Related
Apr 30, 2014
I am close to finishing a new database. In this database I have some VBA code that does a bunch of stuff, one of those things is to check if a temp table exists, and if yes then it will delete it.
Once finished this database will be made available to a range of people via Access Runtime 2010. I'm just wondering will the VBA code that deletes a table work in a Runtime environment?
I guess I should also ask if a save import process will also run via Runtime.just need to make sure that the users that need to do this code have full access if its required.
View 4 Replies
View Related
