Database interaction

T

Taylor

Hey,

So... right know the database is in a shared folder on a PC and the way we
change stock and check stock, is everyone (less than 5 people) open's the
database, open the table and do whatever they need to do. I know there is a
better way to check the data. How do I have an executible (or whatever it is)
on the users system to edit the data? Is there a wizard to create an
executible (or whatever)? Thanks for the help.
 
J

John Vinson

Hey,

So... right know the database is in a shared folder on a PC and the way we
change stock and check stock, is everyone (less than 5 people) open's the
database, open the table and do whatever they need to do. I know there is a
better way to check the data. How do I have an executible (or whatever it is)
on the users system to edit the data? Is there a wizard to create an
executible (or whatever)? Thanks for the help.
Click to expand...

Split the database, so that there are two .mdb files: a "backend"
containing only the tables, on a shared drive; and a "frontend"
distributed to each user's machine. For details see

http://www.granite.ab.ca/access/splitapp/index.htm

John W. Vinson[MVP]
 
T

Taylor

Thank you for your reply. After seeing your post and following your link, I
guess what I really want is a pretty front end to my database. I have heard
that genericdb is nice, but thier website seems to be down. any other
suggestions for front ends (web-based or whatever)?

Thank You
 
Top