what is better Access or foxpro

There are kinda two aspects to your question. Access and Foxpro are "database formats" as well as "development environments". In other words, you could use either type of database through Visual Basic or you might use either of these as your development platform. If you are using VB to access the database, they are both fairly similar because the methods you'll use within VB will be nearly identical for either database format. For this, I prefer the Access format because all tables and indexes are contained in a single file, whereas the Foxpro database has a separate file for each table and index, making it a little bit more difficult to work with.

Now, as far as a development environment, Foxpro is more sophisticated than Access. With Access, you create procedure code and event handlers much like you would in VB. In fact, the underlying language for Access is VBA (Visual Basic for Applications). With Foxpro, all programming is done in a different language similar to the old dBase commands. However, I think the development tools in Foxpro are more flexible and powerful than what is provided by Access.

For most VB programmers, Access is probably a little bit easier to use, but it is really only feasible for fairly small databases. Foxpro is more difficult, but will handle larger databases.