Problem in access when transfer data from one file to another file

[amrit1123]

Respected Sir..

I am working on Access Project. When I Transfer Forms of an ADP file into an .mdb database using ole function (docmd.transferdatabase( ) ) then a message occured for some forms ...( The Object was saved in an invalid format and can not be read) and after press ok button , we get another message , no current record.
i want to avoid these messages.

[NeoPa]

I don't think that you can use a form from an ADP file in an MDB file. You need to get the form from the MDB file the form was originally developed in.

[NeoPa]

Amrit, it seem you posted this same question twice. Please don't do that as it creates extra unnecessary work for the mods.
No problems this time (I'm sure it was a simple mistake) but please remember in future.

[Jim Doherty]

Respected Sir..

I am working on Access Project. When I Transfer Forms of an ADP file into an .mdb database using ole function (docmd.transferdatabase( ) ) then a message occured for some forms ...( The Object was saved in an invalid format and can not be read) and after press ok button , we get another message , no current record.
i want to avoid these messages.

Amrit,

You will have difficulties with this depending on the complexity of your system you have to remember that forms are dealing with server side data and hence you 'might' have a controlsource that references a stored procedure for instance that the mdb form version would have no idea about ie "dbo.usp_MyStoredProcedure" or a view where in an ADP file it would be editable but in an mdb file it would not be because it has no concept of the view and so on.

You 'can' import forms into an mdb file 'and' use them but you have to be mindful of the subtle differences in what a form was designed to do 'before' in an ADP environment and what it cannot do now and be prepared to adjust the differences if I am making any sense to you.

Using the wholesale transferdatabase method I wouldn't recommend either, its too wholesale to be of any real use in this scenario. Lets not forget it was written before ADP files came along. I would suggest grabbing a form at a time using 'file.... get external data....and see what impact it has for you

Hope this helps

Jim :)