If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Allan,
I THINK this applies to Access 2000, I forget when this started. To check the Macro Settings, which is via Access not via the network, follow these steps... 1. Open any database 2. Go to Tools... Macro... click Security... 3. On the machine that works check the setting but it sounds like it's set to Low. Insure all the other machines are set the same way. Yep, you get a message about being unsafe... just say Yes or OK. Let's see if that's the problem. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ALLAN_ASHFORD via AccessMonster.com" u56735@uwe wrote in message news:a066b80b970e3@uwe... Hi Gina Access 2000 Being self-taught I'm not sure what you mean by "macro settings at in each front end or at each location?". However the database from which the problem database was derived runs in parallel presumeably under the same configuration (local & network) without any problem as the one that is giving the problem so the macro settings (whatever they are) should be the same. Can you please give me some pointers to check? Sorry I can't be of more help, but having used Access for 15 years this is the first time I have come across a problem I haven't managed to solve. Allan Gina Whipp wrote: Allan, Forgot to ask Access version? And if I am understanding you... running the query appends the records BUT running it from the macro does not work. Since the query appears fine. What are the macro settings at in each front end or at each location? Hi Gina [quoted text clipped - 35 lines] Allan Ashford -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#12
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Macro Security is only avialable in 2003 and 2007. For 2000 there's no
security for macros. What Gina is refering to is the end users PC, what version are they using? If it is 2003 or 2007, you might want to ask them to to disable macros for this test. If they are using 2007, make sure the database is in Trusted locations. You might want to check for WorkGroup Security just in case even the owner/user or the Admin user setting was incorrect where the user might not be able to execute the database macro. You can go to the security - user and group permissions - object type - select the your macro name and make sure they have the neccessary permission. They are open/run, read design, modify design, administer. I doubt it, as it is very unlikely that someone might change this, but than again who knows? (even if you don't use workgroup security, it still worthwhile to check just in case someone setup user security accidentaly). 2007 format databse(accdb) does not support workgroup security. ALLAN_ASHFORD wrote: Hi Gina Access 2000 Being self-taught I'm not sure what you mean by "macro settings at in each front end or at each location?". However the database from which the problem database was derived runs in parallel presumeably under the same configuration (local & network) without any problem as the one that is giving the problem so the macro settings (whatever they are) should be the same. Can you please give me some pointers to check? Sorry I can't be of more help, but having used Access for 15 years this is the first time I have come across a problem I haven't managed to solve. Allan -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#13
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
AccessVandal,
Thanks, I wasn't sure if that was available in 2000. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "AccessVandal via AccessMonster.com" u18947@uwe wrote in message news:a067a0b8d850a@uwe... Macro Security is only avialable in 2003 and 2007. For 2000 there's no security for macros. What Gina is refering to is the end users PC, what version are they using? If it is 2003 or 2007, you might want to ask them to to disable macros for this test. If they are using 2007, make sure the database is in Trusted locations. You might want to check for WorkGroup Security just in case even the owner/user or the Admin user setting was incorrect where the user might not be able to execute the database macro. You can go to the security - user and group permissions - object type - select the your macro name and make sure they have the neccessary permission. They are open/run, read design, modify design, administer. I doubt it, as it is very unlikely that someone might change this, but than again who knows? (even if you don't use workgroup security, it still worthwhile to check just in case someone setup user security accidentaly). 2007 format databse(accdb) does not support workgroup security. ALLAN_ASHFORD wrote: Hi Gina Access 2000 Being self-taught I'm not sure what you mean by "macro settings at in each front end or at each location?". However the database from which the problem database was derived runs in parallel presumeably under the same configuration (local & network) without any problem as the one that is giving the problem so the macro settings (whatever they are) should be the same. Can you please give me some pointers to check? Sorry I can't be of more help, but having used Access for 15 years this is the first time I have come across a problem I haven't managed to solve. Allan -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#14
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Hi Gina
I'll check security out in the morning (I'm UK based nand it's now 2.15 am). But I'm running both databases on the same PC under Access 2000 and both with linked tables onto the same other PC across my own network, i.e. I'm still at the testing stage, so none of the modifications have been loaded onto the clients's PCs. Allan Gina Whipp wrote: AccessVandal, Thanks, I wasn't sure if that was available in 2000. Macro Security is only avialable in 2003 and 2007. For 2000 there's no security for macros. What Gina is refering to is the end users PC, what [quoted text clipped - 36 lines] Allan -- Message posted via http://www.accessmonster.com |
#15
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Allan,
Then the Macro Security is not an option if using Access 2000. How is the macro run? Is it a button on a form? What is the code? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ALLAN_ASHFORD via AccessMonster.com" u56735@uwe wrote in message news:a0682ab3954ac@uwe... Hi Gina I'll check security out in the morning (I'm UK based nand it's now 2.15 am). But I'm running both databases on the same PC under Access 2000 and both with linked tables onto the same other PC across my own network, i.e. I'm still at the testing stage, so none of the modifications have been loaded onto the clients's PCs. Allan Gina Whipp wrote: AccessVandal, Thanks, I wasn't sure if that was available in 2000. Macro Security is only avialable in 2003 and 2007. For 2000 there's no security for macros. What Gina is refering to is the end users PC, what [quoted text clipped - 36 lines] Allan -- Message posted via http://www.accessmonster.com |
#16
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Hi Gina
The macro that has the problem runs from within another macro which is activated by clicking a button on a form. The problem macro has a Repeat Count of 200 and a Repeat Expression in the form of a Form that shows the difference between 2 numbers and runs whilst this difference is 0. Gina Whipp wrote: Allan, Then the Macro Security is not an option if using Access 2000. How is the macro run? Is it a button on a form? What is the code? Hi Gina [quoted text clipped - 18 lines] Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#17
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Allan,
Have you you tried *Stepping* thru the macro? Also can you post the Actions of the Macro here? Since both databases are connected to the same back-end, are you running them at the same time? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ALLAN_ASHFORD via AccessMonster.com" u56735@uwe wrote in message news:a06eca20f244e@uwe... Hi Gina The macro that has the problem runs from within another macro which is activated by clicking a button on a form. The problem macro has a Repeat Count of 200 and a Repeat Expression in the form of a Form that shows the difference between 2 numbers and runs whilst this difference is 0. Gina Whipp wrote: Allan, Then the Macro Security is not an option if using Access 2000. How is the macro run? Is it a button on a form? What is the code? Hi Gina [quoted text clipped - 18 lines] Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#18
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Hi Gina
Have tried stepping but still no success. Sorry to seem so dim, but how do I post the Macro Actions? I am not running the 2 databases simultaneously, they merely sit alongside each other on the local hard drive and the 2 back-ends likewise on the other PC. Gina Whipp wrote: Allan, Have you you tried *Stepping* thru the macro? Also can you post the Actions of the Macro here? Since both databases are connected to the same back-end, are you running them at the same time? Hi Gina [quoted text clipped - 13 lines] Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#19
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Allan,
No need to be sorry... now once you do you will have learned something new today! Unfortunately, no easy way to do this... You have to open the Macro and type each line Action blah Action Arguements blah blah etc... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ALLAN_ASHFORD via AccessMonster.com" u56735@uwe wrote in message news:a07105549fac7@uwe... Hi Gina Have tried stepping but still no success. Sorry to seem so dim, but how do I post the Macro Actions? I am not running the 2 databases simultaneously, they merely sit alongside each other on the local hard drive and the 2 back-ends likewise on the other PC. Gina Whipp wrote: Allan, Have you you tried *Stepping* thru the macro? Also can you post the Actions of the Macro here? Since both databases are connected to the same back-end, are you running them at the same time? Hi Gina [quoted text clipped - 13 lines] Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
#20
|
|||
|
|||
APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
Hi Gina
The Form contains a numeric value which is the current difference between the Lowest & Highest Unadded Lines in a table. Whilst this is 0 the macro will run, hence the reason for closing the form and then reopening so that the test can be carried out in the Repeat Expression ([Forms]![20 -FIND HIGHEST/LOWEST DIFFERENCE COUNT FORM]!{Expr1])0 in the parent macro. I have tried putting a MsgBox in the troublesome macro immediately before the OpenForm command, but to no avail. Allan Gina Whipp wrote: Allan, If the query is dependent on the form to run why does it open after the query is set to run. Might be a timing issue? Hi Gina [quoted text clipped - 78 lines] Allan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200912/1 |
Thread Tools | |
Display Modes | |
|
|