-
MS Access Deployment
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
-
Re: MS Access Deployment
What are you using to create your installation package?
Is the dsn file machine specific? Can you post your connection code?
-
Re: MS Access Deployment
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
-
Re: MS Access Deployment
Are yoiu using the ADO Data control or manually creating the connection via code?
-
Re: MS Access Deployment
just using the build wizard.
-
Re: MS Access Deployment
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.