Here I will try to explain what the problem I am facing and I am unable to solve it

Explanation

I had developed an application using VB6 and MS Access as a database.

i had made some forms and add a dataenvironment and some datareports.

i start with a module and made the following code to open the database

Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & "\Customer.mdb" & ";Persist Security Info=False" 

while make a dataenvirnment i made connection by clicking properties and

typing my path like this

I then place the folder containing project.exe and database file in other computer desktop or in c:\ or any other require location.

When i run it on another computer and click on the button which show data report report it prompt/ask me to locate/give address of

the MS Access file as show in figure and did not automatically detect the database  path 

Can you please explain the code and tell me what  I had to dot so it will automatically detect my database and don’t ask me where the database is.

 

	Post Attachments
	pic.JPG (194 views, 24.29 KB)

you can delete all path you wright excpt database name and extention becuse as you said you put them in the same folder

BaHeR hAmEd
Baher613@yahoo.com

Check security option in Access.

if you use vb code in access , you wont have any problem.

add this line:

DoCmd.SetWarnings False

_^[Arash]