W
WEB
I should state up front I am a novice with creating access applications. I
am not a programmer; I barely passed my VBA programming class 8 years ago; I
don’t really understand how macros work; all I really understand is SQL
language. Using the Access 2007 Inventory template as a starting point, I
created a database to track consumable items used in our work. Many false
starts and hours and hours of searching the kb and forums for answers, I got
it to work on my computer. Then I decided to share it. More time on the
forums and help files provided the answer on how to accomplish that.
I split the database using the built-in wizard and put the back-end in a
network folder along with the front-end. I then packaged the front-end using
the developer extension to create a msi install file. There have been many
problems getting this to run, but now multiple users can open the database,
search for parts, determine the quantity, view reports – in short they can
accomplish any of the functions that only require read access.
The problem does not happen on my machine using the same installed version
as is on all the user’s machines. All have Access 2007 with SP1 installed,
so that is no longer an issue. However, on the user’s machine I get an error
“You cannot access that record. You may already be at the last file†when
attempting to create a New Transaction.
When I click OK I get error #2950 in this format:
Action Failed
Macro Name:
MacroName
Condition:
Condition
Macro Name:
RunCode
Arguments:
Arguments
Error Number:
2950
Unfortunately I do not have the exact wording of the error as I am not at
work. I did not create the macro, it came with the template.
I found the kb article #931407 and made sure the location where the back-end
is located is trusted and the location where the installed front-end is
trusted. The user has modify privileges for the folder and the database
creates a locking file when the user opens the database. The database uses
record locking and all the other settings recommended to share a database.
Users just cannot create a new transaction. Any ideas? If you need the
exact error code, I will get it at work and post it.
Thanks in advance.
am not a programmer; I barely passed my VBA programming class 8 years ago; I
don’t really understand how macros work; all I really understand is SQL
language. Using the Access 2007 Inventory template as a starting point, I
created a database to track consumable items used in our work. Many false
starts and hours and hours of searching the kb and forums for answers, I got
it to work on my computer. Then I decided to share it. More time on the
forums and help files provided the answer on how to accomplish that.
I split the database using the built-in wizard and put the back-end in a
network folder along with the front-end. I then packaged the front-end using
the developer extension to create a msi install file. There have been many
problems getting this to run, but now multiple users can open the database,
search for parts, determine the quantity, view reports – in short they can
accomplish any of the functions that only require read access.
The problem does not happen on my machine using the same installed version
as is on all the user’s machines. All have Access 2007 with SP1 installed,
so that is no longer an issue. However, on the user’s machine I get an error
“You cannot access that record. You may already be at the last file†when
attempting to create a New Transaction.
When I click OK I get error #2950 in this format:
Action Failed
Macro Name:
MacroName
Condition:
Condition
Macro Name:
RunCode
Arguments:
Arguments
Error Number:
2950
Unfortunately I do not have the exact wording of the error as I am not at
work. I did not create the macro, it came with the template.
I found the kb article #931407 and made sure the location where the back-end
is located is trusted and the location where the installed front-end is
trusted. The user has modify privileges for the folder and the database
creates a locking file when the user opens the database. The database uses
record locking and all the other settings recommended to share a database.
Users just cannot create a new transaction. Any ideas? If you need the
exact error code, I will get it at work and post it.
Thanks in advance.