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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Security Help
- Thread starter ange71
- Start date
- Thread starter
- #3
Hi
Yes the database is on a network. It is a swtic neywork [i.e. no file server]. No its not split.
I used the Users and Groups wizzard to set up the acounts - which resulted in a shortcut link being placed on my desktop. I copied this link to the desktop of a user in the group [the same way I have previuosly provided access to a database stored on my machine] but when she trys to load the Database she gets a message that the file cannot be found.
is that any clearer??
ange
Yes the database is on a network. It is a swtic neywork [i.e. no file server]. No its not split.
I used the Users and Groups wizzard to set up the acounts - which resulted in a shortcut link being placed on my desktop. I copied this link to the desktop of a user in the group [the same way I have previuosly provided access to a database stored on my machine] but when she trys to load the Database she gets a message that the file cannot be found.
is that any clearer??
ange
When you look in the file you put on the user's computer are the tables linked? (ie have a black arrow beside them?) If so is the link valid? I usually have to map a network drive on all user's computers to the data file so that everyone has the same path to the data (ie: M:\Example.mdb)
Sameal's on the right track, I think. Open the shortcut properties and see exactly what it points to. If the target begins with a drive letter, then this could be your problem:
I've seen problems before with network drives mapped to different drive letters on different computers.
For example, if your database is on some network folder and you have that folder mapped to your F: drive, then your shortcut could point to "F:\MyDatabase.mdb". However, the same shortcut will not work on another computer that does not have their F: drive mapped to the exact same network location.
The way to get around this is either make sure all your users' F: drives are mapped the same as yours, or rewrite your shortcut to point to an absolute network location rather than a mapped drive. (e.g. "\\Server1\Database\MyDatabase.mdb" instead of "F:\MyDatabase.mdb"
Hope this helps.
--Ryan
I've seen problems before with network drives mapped to different drive letters on different computers.
For example, if your database is on some network folder and you have that folder mapped to your F: drive, then your shortcut could point to "F:\MyDatabase.mdb". However, the same shortcut will not work on another computer that does not have their F: drive mapped to the exact same network location.
The way to get around this is either make sure all your users' F: drives are mapped the same as yours, or rewrite your shortcut to point to an absolute network location rather than a mapped drive. (e.g. "\\Server1\Database\MyDatabase.mdb" instead of "F:\MyDatabase.mdb"
Hope this helps.
--Ryan
- Thread starter
- #6
hi
thanks - i think i'm getting there...........but i did it by making the users Access join the workgroup that the wizzard set up - this isnt a very good solution - i will try the method you pointed out ryan.
as for network mapping - i've never done that before - how hard is it?
ange
thanks - i think i'm getting there...........but i did it by making the users Access join the workgroup that the wizzard set up - this isnt a very good solution - i will try the method you pointed out ryan.
as for network mapping - i've never done that before - how hard is it?
ange
Network Mapping:
Right-click on My Computer
Choose Map Network Drive
In Dialog Box that Pops Up
Choose a Drive Letter from Combobox
Enter a Path (ie: \\Fileserver\ExampleData\)
Check Box Marked "Restore Connection on Startup"
Click OK
Your Done...=Þ That wasn't too hard was it?
Sameal
Right-click on My Computer
Choose Map Network Drive
In Dialog Box that Pops Up
Choose a Drive Letter from Combobox
Enter a Path (ie: \\Fileserver\ExampleData\)
Check Box Marked "Restore Connection on Startup"
Click OK
Your Done...=Þ That wasn't too hard was it?
Sameal
- Thread starter
- #8
Yes it is a way to create a new drive. But not a real drive, it is actually more like a virtual drive. Your basically setting up a shortcut to a place on your network and assigning it to an unused drive letter. Such as Z:.
The drives that show up in the box are the available drives. If you already have A:, B:, C:, D: drives, then your only going to be able to choose from E: and up.
This is a way to set up Virtual Drives. They behave identically to having a real drive, but they are more like shortcuts to data.
Say the computer your back-end database is on goes by the name of Backend. (Can find this out by right-clicking on network neighborhood and choosing properties.) The database on that computer is sitting in a directory off of C: by the name of ReceptionData. Now you want to install a copy of the front-end system onto a computer by the name of Reception. So you could map a network drive to Z: and give it the path '\\Backend\ReceptionData\'. Of course you'd also have to share the ReceptionData directory to the correct network users as well.
Hope this helps you figure out how to map the network drives.
The drives that show up in the box are the available drives. If you already have A:, B:, C:, D: drives, then your only going to be able to choose from E: and up.
This is a way to set up Virtual Drives. They behave identically to having a real drive, but they are more like shortcuts to data.
Say the computer your back-end database is on goes by the name of Backend. (Can find this out by right-clicking on network neighborhood and choosing properties.) The database on that computer is sitting in a directory off of C: by the name of ReceptionData. Now you want to install a copy of the front-end system onto a computer by the name of Reception. So you could map a network drive to Z: and give it the path '\\Backend\ReceptionData\'. Of course you'd also have to share the ReceptionData directory to the correct network users as well.
Hope this helps you figure out how to map the network drives.
The shortcut itself might be the problem. When you create a database using Microsoft Access security, you have to use the shortcut it creates for it. This is because it links to threee different files, front end, back end, and security. Create the shortcut in the folder and have the users drag the shortcut onto their desktop.
Linda Adams
Visit my web site for writing and Microsoft Word tips:
Linda Adams
Visit my web site for writing and Microsoft Word tips:
- Thread starter
- #11
- Status
Similar threads
- Locked
- Question
- Locked
- Question
