Front end options

[yhgtbfk]

What are the best front end application options I should investigate?

I have heard that many choose asp or asp.net.

What do other people use?

 

[yhgtbfk]

Front end for what? The best front end for Jet tables is Access. I would never use Jet with anything else unless I didn't have any alternative.

If there are 20 or more users using your access file, problems can start.
Also, if you want to update your front end, then you must lock all users out of the database.

For this reason, alot of people use asp, asp.net, or even visual studio (I think).

That way when the application needs upgrading, the application can be modified, and all the data and tables within the access database remain safe.

ASP pages also allow your database to go online.

I was just curious as to what front end programs people have started using for their databases.

Oh, and we all love access!

 

[yhgtbfk]

- Your forms/reports/queries, etc should be in one db and the tables in another so the data will always remain "safe". This has nothing to do with whether your front end is Access, VB, or COBOL and also has nothing to do with whether your back end is Jet, Oracle, or DB2. The fe and be should be separate to minimize corruption problems and allow for easier application upgrades.

OK, this is when I become a total noob....

Um, how do you create forms, queries, reports etc... for tables that arent in the same database?