Recent content by amudhan

How can I do this? can you give me some code samples.

yes I have written a utility which will do this. but one small thing which I couldn't achieve is that of copying forms, reports and MACROs.. some one had suggested to use access runtime to achieve this. I am just exploring this option..

Yes. also I want the code to convert outside the dB and to be on the front end. Also the option of retiring the forms is not an option since some functionalities are not available in the VB and is only in the forms and reports.

except for step 2 & 3 all are correct. I have only one version of access 2.0 dB. This has forms, report and others and also will be used by front end. A operator profile customer will use the VB front end and his technicial admin will use the forms, reports..

The front end is the new updated copy. but the backend access database data and forms are to be moved to the newer version becaues of maintenance issues. so when my new front end goes there will be a menu which tells the VB application to convert the database from access 2.0 and access 2000 and...

To 80% of the customers it will be VB front-end and the remaining customers they use these forms and reports and the worst part is that my application doesn't know whether the customer falls under 80% or under 20%.

yes. I am doing that. Also write now I am able to write a utility which uses DAO as the data access method and create a new database in 2000 format and copy all the tables with it's fields, relationships and data. Also I am able to create the indexes and also the queries the user has stored in...

hi, I think I am not clear in posting my orginal problem. I am able to convert my database by opening the access 2.0 version of my database in access 2000 and asking it to convert to access 2000. there is no problem in doing this step and hence I assume that I can convert my database. My...

Sorry to be like amateur. I don't know how to move the forms or reports or modules from one dB to another. Can I do this with DAO? or is it possible using ADO? can you give me some clues. thanks -Amudhan

Just had gone and done the same way. I was able to convert the tables, index, queries & relation. but I am unable to convert the forms, reports, macro and module. Is there a way to do it? Actually my access 2.0 database is out of the production and is in the field and my applications are using...

I have a Access 2.0 database with queries, forms, reports, macros, modules and of course tables with relationships & indexes. I want this database to convert programmatically to a higher access version(access 2000 or 2003) format. I tried compact database and it converts without errors, but when...