I was wondering if I could use VB 6.0 as the front end of a database created in access. The Reason, I want to let users enter information into my Access 2000 DB without actually opening access. Therefor I thought I could use a VB form to have users insert this information. Is this possible? Please help I am new to all of this. Thanks
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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB as front end for access
- Thread starter balistikb
- Start date
MichaelRed
Programmer
a less simplistic response might just return another question. Why? What difference does it really make? If you don't secure the db and the app, most any user can get into the db via one method or the other and 'have their way' with the db anyway. If you are just using VB to 'hide' the db, you might just as well use MS. A.
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
Both answers so far are valid. A front end will also let you have some control as to which objects (tables) in the database the user can access and what information they can see or manipulate. Give your user some rules to ensure data integrity, etc, etc.
But that can be done with a VB front end or Access forms. The decision is yours. If you are leaning towards VB look into ADO or DAO for data Access. Thanks and Good Luck!
zemp
But that can be done with a VB front end or Access forms. The decision is yours. If you are leaning towards VB look into ADO or DAO for data Access. Thanks and Good Luck!
zemp
- Thread starter
- #5
Thank you, all of this information is great. If the access database is on a server and I create a VB front end, will they need to open Access in order to add records? That is what I am trying to avoid. I would rather the user open a VB form only to enter information. Maybe like a link on a company home page or something.
Your users will not need to open access directly but rather you rVB front end will create a connection to the database in order to add/update your data.
Bear in mimd though that users will need the correct network and database privileges to do this via your program. Gary Parker
Systems Support Analyst
Bear in mimd though that users will need the correct network and database privileges to do this via your program. Gary Parker
Systems Support Analyst
- Thread starter
- #8
Would I be able to test this on my local drive prior to putting it on a network. ANd what is the process called when using a VB front end for access? THis way I could read up on it. Is there anywhere that I might be able to see a sample Database that works this way?
Yes, you can do it all local before you place the database on the network. You will have to change your connection string when you move your database however.
You should find some good examples of how to connect in the hekp files or msdn. Look for ADO or DAO. There are also some tutorial sites that may give you some examples. is good. has an ADO tutorial. Thanks and Good Luck!
zemp
You should find some good examples of how to connect in the hekp files or msdn. Look for ADO or DAO. There are also some tutorial sites that may give you some examples. is good. has an ADO tutorial. Thanks and Good Luck!
zemp
Another easy to follow tutorial can be found at
Good luck with your project Gary Parker
Systems Support Analyst
Good luck with your project Gary Parker
Systems Support Analyst
- Thread starter
- #11
- Status
