after publish the program, if i wanna change the data from Access database, where i can edit it?

after publish the program, if i wanna change the data from Access database, where i can edit it?

• Haroonm

  Review -

  http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx

  Eg. Where db is published to sub directory data.

  Dim MyDBPath As String = Application.StartupPath & "\data\mydb.mdb"

  rgds,

  Martin.

  
  

• lord_8

  Hi,

  Could you please elaborate on this a little more Do you mean you want to edit your database's structure If so, you can just open your Access File and change your structure.

  cheers,

  Paul June A. Domag

  
  
  

• dn8

  actually i just wanna change some data from database

  normally from VB6, i can just open the access database under program files

  but now, i don't know where i can open the access database (after i publish the program)

  thx for your attention

  many thx

  hunb

  
  
  

• Frank the Tank

  yes

  access database has been installed already

  after installation, where will the database be located

  thx for your help

  
  
  

• M. Houy

  Hi,

  Normally it is accompanied with your exe. But since you are the one who created the program then you must know where you are placing your database. Just check your connectionstring. It contains the path of your database.

  cheers,

  Paul June A. Domag

  
  
  

• yongsan

  Hi,

  I guess your target computer doesn't contain an Access program. You must install Microsoft Access to be able to open and change data in your database.

  cheers,

  Paul June A. Domag

  
  
  

• A fish

  hunb wrote:

  so can i hard code the application path (ie c:\program files\...) thx hidy

  Hi,

  No, its not advisable to hardcode the applicaiton path since application paths varies per computer. Say, a user might install your program in D:\program files instead in C:\. Hardcoded application paths would generate an error.

  I suggest implementing what mokeefe posted or you can just place it in the same file as your exe and refer to it straightly by using its filename rather that providing paths...

  cheers,

  Paul June A. Domag

  
  
  

• Malik Faisal

  so can i hard code the application path

  (ie c:\program files\...)

  thx

  hidy

  
  
  

• Mr Cai

  I'm guessing, but my guess, for whatever it may be worth, is that perhaps the problem is the difference between the absolute path on the development system and the absolute path on the server Possibly what the original poster is looking for may be the MapPath method If so, perhaps the following link to an MSDN search result might help ... http://search.msdn.microsoft.com/search/default.aspx query=mappath -- Brendan Reynolds wrote in message news:974fac26-b312-4540-891f-a88f4087ce77@discussions.microsoft.com... > Hi, > > Normally it is accompanied with your exe. But since you are the one who > created the program then you must know where you are placing your > database. Just check your connectionstring. It contains the path of your > database. > > > > cheers, > > Paul June A. Domag > >
  
• after publish the program, if i wanna change the data from Access database, where i can edit it?