| | |
|
|
|
Exporting multiple objects |
|---|
| message from Noel on 8 May 2004 |
Hi, further to my earlier post (Occasional Lock Up
Problem), Ive been reading some old posts and links that
sometimes recommend creating a new blank mdb, then
copying all the objects from a suspect corrupt one into
it. Im wondering whether I should try this but is there
an easy way of exporting/importing multiple objects? My
mdb has a fair number of objects and it will take a long
time to export them one at a time. Thanks, Noel
|
| Albert D. Kallal replied to Noel on 8 May 2004 |
Do a "import" while in the new blank mdb.
File->get external data
|
| Noel replied to Albert D. Kallal on 8 May 2004 |
Thanks Albert. Any ideas on my other post? I suppose a
mass import of objects from a suspected corrupt database
is only likely to be effective if you know which object is
faulty and so must be left behind? In my case the problem
arises when I try to delete an object and it happens
randomly, so if my db is corrupt, I dont know where the
problem lies exactly. Thanks again, Noel
|
| Albert D. Kallal replied to Noel on 8 May 2004 |
Well, I would try the import........often a import will stop on the bad
form, report or whatever. Then, so when it stops..you can then skip, or
un-check that bad form when you try the import again.
So, give the import thing a try...if you don't encounter any problems...then
it is possible that you have some other problem..and corruption is not a
issue. If you are experience random problems with no particular form in
mind..then corrupting is likely NOT your problem.
If you code can compile fine..and you can edit forms in design mode..then I
don't think corruption is your problem.
|
| Noel replied to Albert D. Kallal on 8 May 2004 |
Thank you Albert. Ill consider trying what you suggest
although I agree that the random nature of my problem
points to a non corruption problem. Perhaps a network
issue. I appreciate your help. Cheers, Noel
stop on the bad
then skip, or
any problems...then
corruption is not a
particular form in
design mode..then I
|
|
Archived message: Exporting multiple objects (Microsoft Access Database)
