Back end, pictures, and more?

agehoops

Registered User.
Local time
Today, 21:33
Joined
Feb 11, 2006
Messages
351
I've looked on the forum and can't find exactly what I'm after so thought I'd post instead.

Couple of things:

1. I have a front end back end set-up, and it is to be deployed over a network. When it comes to installing, I'm currently going to have to manually re-link the tables to the location of the back end which is a bit of a pain. What I'm basically looking for is some code which will check the current back end set-up (if there is one) If there isn't, ask the user to find the mdb back end, if there is one, check to see if it still exists, and if it doesn't, again ask the user to find it. How do I go about doing this?

2. On my main form, there is a picture field and a file browser box to allow the user to choose a picture for that member of staff. There are a couple of things to do with the picture that are causing minor problems.

Firstly, when a picture is selected from the file browser, the picture is placed in which is fine, and the file location of that picture is stored in the table, which is also fine, however it is a local directory (i.e. C:/....) which is fine for that machine, however when the system is opened anywhere else, this file no longer exists and it fails. Is there a way of it storing the network address from the file browser instead?

Also, when a user presses the button to skip to the next record, it obviously has to go and find the new image and show it, which is fine but it takes time. If the user presses the button more than twice quite quickly, access simply hangs and forces the user to shut it due to it being unable to calculate it fast enough. Is there a way that when the button is pressed to skip a record, the entire form is completely locked, and then unlocked when the image has successfully been loaded? This would stop it freezing and be perfect for what I'm after?

3. Security on the back end? I can apply a password to it which is fine, and I can apply an autoexec macro to shut it the moment it is opened, but what is the best way of really securing it?
Also, if I do password protect it, how do I then access it from the front end as it would need the password right?

Thanks in advanced
 
Someone else will have to talk to you about the fe/be actions you want regarding auto-locate.

Regarding the security, you can search this forum for "Workgroup Security" and "Securing a Database" to see a myriad of threads on the subject.

If the drive mapping differs from machine A to machine B, that impinges both on your fe/be table setup and on your image locating stuff.

Perhaps you should be using the URS format rather than the drive-letter format for file references. The former does not depend on which letter is mapped to which drive. Like.. \\MySharedServer\Databases\Picture.MDB for the link to the BE, and \\MySharedServer\Databases\Pix\fred.jpg for a file reference. As opposed to S:\databases\Picture.MDB etc etc
 
Well that is how i want it to return the location of the picture, so that the pictures don't all have to be stored in the same place. I'd rather they were a network address like //server/Documents ... but i just couldn't figure out how to make the file browser return that rather than the local directory :(
 
Yea. I had a look into it the once but it just confused the hell out of me as how to actually implement it? :confused:
 
Maybe this will help:


01UNC.png


02UNC.png


Or you can just navigate to it but through NETWORK in the dialog.
 
Thing is, I don't want it to ask for a new back end location every time the database is run, only when it can't find the one that is set at current. Also I want that UNC to be on the file browser for the picture?
 

Users who are viewing this thread

Back
Top Bottom