Dear Friends i have made application and is working properly but the only problem is that i am not able to make a exe file of the project. I have stored the project and the database file in the F drive of my hard disk. The database i have used is MS Access 2007. Here is the connectivity code i have written

Set objconn = New ADODB.Connection
objconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=" & App.Path & "\" & "garage.mdb"
objconn.Open

Set rscoupon = New ADODB.Recordset
rscoupon.Open "Coupon", objconn, adOpenDynamic, adLockOptimistic

Set rsproduct = New ADODB.Recordset
rsproduct.Open "Product", objconn, adOpenDynamic, adLockOptimistic


The error i am getting file making the exe file is
Run time Error'-2147467259 (80004005)';
Couldnt find file 'C:\Documents and settings\GOLDWINGS\Destop\garage.mdb'.

Please can someone help me

Well, that is pretty clearly telling you that App.Path is C:\Documents and settings\GOLDWINGS\Destop

If that's wrong, then of course that's the problem.

**********

p.s.: Destop????? Shouldn't it AT LEAST be DesKtop ??

Somewhere you have a reference to the MDB that is incorrect. Are you using an ADO/DAO/RDO control?

An easy way to fix this is to open up your .frm file in notepad and search for that string. If you find it, change it to the correct path.

Good Luck