Front end help

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

Anyone have information or a website that can help me make a front end
for my program?

Ryan
 
Yes, sorry, I have an access database.

?Front-end for my program?

What program?  You posted in an MS Access-related newsgroup.  Are youusing
MS Access?

MS Access works quite well as a front-end.

More info, please...

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/
Click to expand...
 
Yes, I have an access database. There are several people who will use
my database, I was reading that I need to split the database, so I
went to tools and split the database. I have the same file with _be at
the end. What do I do now, I was under the impression that the front
end version didn't' have the tables in it, but they are both the same
size in terms of megabytes. After I have the front end I email it to
everyone who wants to use it? Also, I have an export to excel feature
will it save to their desktop and not mine on the front end? Also how
do I update their front ends?
 
The BE mdb needs to be placed in a shared file on the server. All
users will need to have Read/Write/Delete priveleges on this file. You
should use UNC path naming, as opposed to drive letter path naming, for
the link to the BE file. So the path would look like;

\\TheServer\SomeFile\YourBE.mdb

instead of;

P:\SomeFile\YourBE.mdb

Next, each user should have their own copy of the FE, preferrably on their
local drive if possible. If not, then in that users network folder. I suppose
you could e-mail the FE to each user if you think they are all competent
enough to copy it to an appropriate location. In my experience that is
probably not the case. As far as updating, if there are only a few users
and they are all at your location, you can just update each station
individually when needed. If that won't work for you, you might have a
look at Tony Toews Auto FE Updater at;

http://www.granite.ab.ca/access/autofe.htm

In regards to your export to Excel function, it's impossible to say whether
or not it will work correctly without knowing how the procedure is written.
 
Back
Top