473,320 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1632
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Baldur Norddahl | last post by:
Hi, I just noticed something bad in our database: webshop=# select oid,* from content_loc where id=20488; oid | id | locale | name ---------+-------+--------+-------------- 9781056...
2
by: En | last post by:
Any ideas what to do for the best? I have a table that records some transaction data. Each entry in the table has an auto gen primary key / ID. Somewhere along the way there are 1000's of...
21
by: Dan | last post by:
Hi, just ran into my first instance of a backend Access97 database not compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on compact. I've narrowed it down to the largest...
2
by: John | last post by:
I am using the INPUT statement in VBA to read files off of CDROMs and DVDs. Normally everything works fine. However, sometimes portions of a file are unreadable, and this will lockup the Access...
0
by: Frank Thiel | last post by:
Hello, we write into an MSACCESS 2.0 DB. These files are on a server. We get crashes and when I try to repair the corrupt DB I get messages like : one or more entries in MSysObjects (...
4
by: Harris | last post by:
Can anyone please help? I have read the postings on the error "The Visual Basic for Applications Project in the database is corrupt" but none report the particular problem I am experiencing, i.e.,...
2
by: Simon | last post by:
Dear reader, I can't repair this with Tools>>Database utilities>>Compact and repair database.... And another way around: after creating a new database and start import all
0
by: martin | last post by:
I've just been handed an old project (written in VC6 or possibly an earlier version) which I need to compile in Visual Studio Express. I went through the normal solution coversion process but the...
0
by: bbrewder | last post by:
I am struggling with some MSAccess automation issues. Basically, we have a .Net application that uses MSAccess for reporting (legacy code). We are able to launch MSAccess fine and even work with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.