By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

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

P: 5
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.
Dec 19 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,186
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.
Dec 19 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
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.
Dec 19 '07 #3

Jim Doherty
Expert 100+
P: 897
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 :)
Dec 19 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.