MS Access Deployment

[FrankP]

I ma trying to create a installllationj cd which includes a small dtabase. I hve been using ADO connections.
Whan I test this on another machine it doesnt find the database.
THe database is on the new machine and i have also copied across the datasource file.

Any idea what I might be mssing - I cant seem to find a simple guide to database distriibution with VB anywhere.

Any help gratefully recieved.


Frank

[RobDog888]

What are you using to create your installation package?

Is the dsn file machine specific? Can you post your connection code?

[FrankP]

I ma using the deployment wizard
I have been using the connection string wizrad - not sure how to post the connection code. I could pots the connection string?

Frank

[RobDog888]

Are yoiu using the ADO Data control or manually creating the connection via code?

[FrankP]

just using the build wizard.

[RobDog888]

So you get the record selector buttons like back forward etc.

Then you probably are using the ADO Data control and you will need to change the connection code to a relative db path in your apps form_load or sub main procedure.