|
| 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 |
|
#1
January 30th, 2009, 04:53 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Can't open .mdb file
HELP!
I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy 
|
|
#2
January 30th, 2009, 06:27 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
Posting 7 minutes to your deadline is very hopeful on your part.
Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy
|
|
#3
February 1st, 2009, 06:39 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
On Jan 30, 12:27*pm, Joan Wild wrote:
Posting 7 minutes to your deadline is very hopeful on your part. Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. *This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. *When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. *The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? *I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy Or save yourself the nightmare of a corrupted database and do it sooner rather than later. It's not at all funny when your database folds up and refuses to open. but if you've got cash to spare, Peter Miller would appreciate a call, I'm sure. You're just heading for trouble not splitting your front end from the back. Been there, done that, and I do not recommend it... but it's your database and your money... do with them as you wish.
|
|
#4
February 2nd, 2009, 02:44 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
Can someone please tell me HOW to split the database to front end and back
end??? I have an access load table at work that 3 users entered data into for loading trucks. If one user had the program open and the owner (which at the time was me) closed the program it corrupts the whole database. Our IT department hasn't been able to do anything with it and unfortunately the last backup was at least 6 months old. I wasn't aware that it wasn't backed up automatically, or I would have been doing it obviously. We seriously need to be able to use the program before we get busy this summer. -- daddysgirl "Piet Linden" wrote: On Jan 30, 12:27 pm, Joan Wild wrote: Posting 7 minutes to your deadline is very hopeful on your part. Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy Or save yourself the nightmare of a corrupted database and do it sooner rather than later. It's not at all funny when your database folds up and refuses to open. but if you've got cash to spare, Peter Miller would appreciate a call, I'm sure. You're just heading for trouble not splitting your front end from the back. Been there, done that, and I do not recommend it... but it's your database and your money... do with them as you wish.
|
|
#5
February 2nd, 2009, 03:01 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
DaddysGirl,
This should help: http://www.members.shaw.ca/AlbertKal...plit/index.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "daddysgirl" wrote in message ... Can someone please tell me HOW to split the database to front end and back end??? I have an access load table at work that 3 users entered data into for loading trucks. If one user had the program open and the owner (which at the time was me) closed the program it corrupts the whole database. Our IT department hasn't been able to do anything with it and unfortunately the last backup was at least 6 months old. I wasn't aware that it wasn't backed up automatically, or I would have been doing it obviously. We seriously need to be able to use the program before we get busy this summer. -- daddysgirl "Piet Linden" wrote: On Jan 30, 12:27 pm, Joan Wild wrote: Posting 7 minutes to your deadline is very hopeful on your part. Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy Or save yourself the nightmare of a corrupted database and do it sooner rather than later. It's not at all funny when your database folds up and refuses to open. but if you've got cash to spare, Peter Miller would appreciate a call, I'm sure. You're just heading for trouble not splitting your front end from the back. Been there, done that, and I do not recommend it... but it's your database and your money... do with them as you wish.
|
|
#6
February 2nd, 2009, 04:03 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
it sure did!! I will try this tomorrow, thanks a bunch!! I have been reading
the forums and have done all the training available on ms-office's site and nothing even came close to explaining my problem, thanks again!! -- daddysgirl "Gina Whipp" wrote: DaddysGirl, This should help: http://www.members.shaw.ca/AlbertKal...plit/index.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "daddysgirl" wrote in message ... Can someone please tell me HOW to split the database to front end and back end??? I have an access load table at work that 3 users entered data into for loading trucks. If one user had the program open and the owner (which at the time was me) closed the program it corrupts the whole database. Our IT department hasn't been able to do anything with it and unfortunately the last backup was at least 6 months old. I wasn't aware that it wasn't backed up automatically, or I would have been doing it obviously. We seriously need to be able to use the program before we get busy this summer. -- daddysgirl "Piet Linden" wrote: On Jan 30, 12:27 pm, Joan Wild wrote: Posting 7 minutes to your deadline is very hopeful on your part. Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy Or save yourself the nightmare of a corrupted database and do it sooner rather than later. It's not at all funny when your database folds up and refuses to open. but if you've got cash to spare, Peter Miller would appreciate a call, I'm sure. You're just heading for trouble not splitting your front end from the back. Been there, done that, and I do not recommend it... but it's your database and your money... do with them as you wish.
|
|
#7
February 2nd, 2009, 04:12 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Can't open .mdb file
You're welcome...
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "daddysgirl" wrote in message ... it sure did!! I will try this tomorrow, thanks a bunch!! I have been reading the forums and have done all the training available on ms-office's site and nothing even came close to explaining my problem, thanks again!! -- daddysgirl "Gina Whipp" wrote: DaddysGirl, This should help: http://www.members.shaw.ca/AlbertKal...plit/index.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "daddysgirl" wrote in message ... Can someone please tell me HOW to split the database to front end and back end??? I have an access load table at work that 3 users entered data into for loading trucks. If one user had the program open and the owner (which at the time was me) closed the program it corrupts the whole database. Our IT department hasn't been able to do anything with it and unfortunately the last backup was at least 6 months old. I wasn't aware that it wasn't backed up automatically, or I would have been doing it obviously. We seriously need to be able to use the program before we get busy this summer. -- daddysgirl "Piet Linden" wrote: On Jan 30, 12:27 pm, Joan Wild wrote: Posting 7 minutes to your deadline is very hopeful on your part. Check the windows permissions on the folder where the mdb is located. Ensure all users have full permissions to the folder. (and sorry, but you really should split; feel free to post back when you experience the consequences) Joan Wild MS Access MVP Judy Ward wrote: HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't advise me to split the db into a front end and back end. For some reason only one person can open this file at a time. When the next person double-clicks on the file to open it, nothing happens--no error message, nothing. The file just doesn't open. I do have a frmWelcome that opens automatically when the database opens, but I can't imagine that is the reason. Does anyone know what can be causing this??? I am panicking (manager expecting multiple people to enter status by noon) and could sure use some help! Thank you, Judy Or save yourself the nightmare of a corrupted database and do it sooner rather than later. It's not at all funny when your database folds up and refuses to open. but if you've got cash to spare, Peter Miller would appreciate a call, I'm sure. You're just heading for trouble not splitting your front end from the back. Been there, done that, and I do not recommend it... but it's your database and your money... do with them as you wish.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
