Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export a linked workable form
- Thread starter chubby
- Start date
why don't they have access? maybe they aren't supposed to? do they not have access to the server that the db is on? if that is so then they will not be able to use it even if you do the following. all users have to have read/write/create access to the server because Access creates a locking file (.ldb) when it's accessed.
anyhow, make a small Access front-end to the database, with one form where they can enter data. link the tables from your 'real' database into this 'front-end' database.
make sure that when you link the tables into the front-end that you use the full path of the location of the database, not just the drive letter, otherwise it won't work for the users because it will be the drive letter on YOUR machine, not theirs.
another option is to write a web-based solution in ASP.
g
anyhow, make a small Access front-end to the database, with one form where they can enter data. link the tables from your 'real' database into this 'front-end' database.
make sure that when you link the tables into the front-end that you use the full path of the location of the database, not just the drive letter, otherwise it won't work for the users because it will be the drive letter on YOUR machine, not theirs.
another option is to write a web-based solution in ASP.
g
- Thread starter
- #3
Thanks but after reviewing my Access 2000 bible I came too the same answer.
Here are some answers for ya!!!
Why don't they have access? Because the Military Personnel officer don't won't them to have access. They don't have a 'NEED TO KNOW'
maybe they aren't supposed to? NO THEIR NOT... I just wanted to make it easier for the section leaders when assigning duty to over 3,000 personnel.
do they not have access to the server that the db is on? Yes they do, for e-mail and other MS programs.
if that is so then they will not be able to use it even if you do the following. NOPE!!!!
all users have to have read/write/create access to the server because Access creates a locking file (.ldb) when it's accessed. They do, but their locked out from the Military personnel database.
Thanks again!!!
Here are some answers for ya!!!
Why don't they have access? Because the Military Personnel officer don't won't them to have access. They don't have a 'NEED TO KNOW'
maybe they aren't supposed to? NO THEIR NOT... I just wanted to make it easier for the section leaders when assigning duty to over 3,000 personnel.
do they not have access to the server that the db is on? Yes they do, for e-mail and other MS programs.
if that is so then they will not be able to use it even if you do the following. NOPE!!!!
all users have to have read/write/create access to the server because Access creates a locking file (.ldb) when it's accessed. They do, but their locked out from the Military personnel database.
Thanks again!!!
wow...too bad you are not in Sql Server, that's just what it is for....but you can simulate the same kind of thing, i.e. put some place else a little db that has just the info in it that these users are allowed to see, and have them update it all day long. then at like 3:00 am every night update the real data with what they have done. if other people who DO have access to the db are making changes too, tho, it can get messy....again, too bad you dont have SQL server......
good luck-g
good luck-g
- Status
Similar threads
