469,916 Members | 2,371 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,916 developers. It's quick & easy.

Duplicate a corrupt MSAccess DB?

weve gotn an access database running our intranet and its gone down. the in
build trpair function doesnt work but we can still access the data through
ASP, just not through the Access interface?

it says theres a jet error as someone else has the DB open (but they dont)

is there anyway we can duplicate the tables, data and relationships in an
other db? ive tried some of the large scripts available for access that are
supposed to do this, only no success yet!

mark
Jul 19 '05 #1
2 1585
Stop the intranet web service, (and unload it).
Kill / delete the .ldb file that will be alongside the AccessDB.
Now try and do a repair - it shouldn't complain about it being open now.

Hope this helps.

Chris.

"mark | r" <ma*******@SPAMMEnmd.freeuk.com> wrote in message
news:3f**********************@news.dial.pipex.com. ..
weve gotn an access database running our intranet and its gone down. the in
build trpair function doesnt work but we can still access the data through
ASP, just not through the Access interface?

it says theres a jet error as someone else has the DB open (but they dont)

is there anyway we can duplicate the tables, data and relationships in an
other db? ive tried some of the large scripts available for access that are
supposed to do this, only no success yet!

mark

Jul 19 '05 #2
Try:

http://www.granite.ab.ca/access/corruptmdbs.htm

Best Access trouble-shooting site I've ever seen. Describes a bunch of ways
to fix the problem you're having.

Mike
"mark | r" <ma*******@SPAMMEnmd.freeuk.com> wrote in message
news:3f**********************@news.dial.pipex.com. ..
weve gotn an access database running our intranet and its gone down. the in build trpair function doesnt work but we can still access the data through
ASP, just not through the Access interface?

it says theres a jet error as someone else has the DB open (but they dont)

is there anyway we can duplicate the tables, data and relationships in an
other db? ive tried some of the large scripts available for access that are supposed to do this, only no success yet!

mark

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Baldur Norddahl | last post: by
21 posts views Thread by Dan | last post: by
reply views Thread by Frank Thiel | last post: by
reply views Thread by bbrewder | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.