VB.NET connecting to databases

VB.NET connecting to databases

• canadian_coder

  Thanks for replying.

  There is one access database which update when new users are added.

  I need to be able to "see" the contents of this database from another project. Then I want to be able to edit the database and for it to be updated for both projects.

  I added the login form to the same project and coded it to open the admin form if the "admin" username is used and the other form for every other user.

  This means admin have to log in to the "system". This is not a major problem as this is not for a professional use.

  If there is a way of solving the initial problem then I will be grateful.

  Thanks ahmedilyas.

  
  

• danadanny

  well, what do you mean by the admin form database needs to be updated when new users are added

  this "login" system, are all the users stored in a table in the MS Access file Or is this what you are trying to do

  
  
  

• programmer01

  "I want to create a new application for Admin purposes which needs to connect to the same access database. I know how to connect to this database but when new users are added to the login form, the admin form database needs to be updated as well."

  There should be just one database, right So after a new user account has been created and persisted, the admin form needs to be updated to reflect the current state of the date base

  
  
  

• Devin

  Thanks for replying to my question.

  Yes there is just one database (access) and you are right when you say that the admin form needs to be updated to reflect the state of the database.

  I have just tried something else which seems to work. I have just added the admin form to the same project and if the "admin" user logs in then it will open the admin form and if anyone else logs in, the other form will be opened.

  That is all it needs to be. For the admin to be able to do tasks e.g. reset passwords they will have to login. This is not a major problem.

  If there is a way of solving the initial problem then I will be grateful.

  Thanks ReneeC for your help.

  
  

• jcarlos.net

  "I have just tried something else which seems to work. I have just added the admin form to the same project and if the "admin" user logs in then it will open the admin form and if anyone else logs in, the other form will be opened"

  Why

  To start a new project in the same solution, goto the solution explorer up at the solution name, right and add a new project.

  Then using exlorer take the YourFormname.Vb and the other two files with the same name from the original project and drop them into the new project directory.

  Goto the solution explorer, select the new project for Admins, right click select Add Existing and select YourFormname.Vb and add that to the project. You should have no difficulty.

  But here is a trick to be aware of of.... create a new directory called DATABASE... and put your database in there. Have both project open that common database. (I hope you are using a connection string instead of that datadesigner.)

  
  
  
• VB.NET connecting to databases