473,387 Members | 1,771 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,387 software developers and data experts.

Can't open DB! Super Emergency Pls Help Quick!

tdw
206 100+
This just happened this morning! When anyone, from any computer, tries to open our Orders Database, we get the following error message:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)


But that's not true! Nobody is on it!
Help! How can I get this to open? We rely heavily on this database, all day long!
May 4 '07 #1
72 3691
MMcCarthy
14,534 Expert Mod 8TB
This just happened this morning! When anyone, from any computer, tries to open our Orders Database, we get the following error message:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)


But that's not true! Nobody is on it!
Help! How can I get this to open? We rely heavily on this database, all day long!
First, check to see if there is an *.ldb file anywhere and see if you can delete it.
May 4 '07 #2
tdw
206 100+
First, check to see if there is an *.ldb file anywhere and see if you can delete it.
I found one in C:\Program Files\Microsoft Office\Office11
called ACWZTOOL.ldb

Could that be it, should I delete it? The actual database file is on a server, should I search the server too before deleting this? By the way, I already tried copying the db file to my computer (which it let me do) then ran it. Same error. In case that means anything.
May 4 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
I found one in C:\Program Files\Microsoft Office\Office11
called ACWZTOOL.ldb

Could that be it, should I delete it? The actual database file is on a server, should I search the server too before deleting this? By the way, I already tried copying the db file to my computer (which it let me do) then ran it. Same error. In case that means anything.
No you are actually only looking for one with the same name as the database. I take it this is only a single unit database and not a backend/frontend system.

Try copying and renaming the database and see will it open that way. Were there any upgrades to the office suite implemented recently?
May 4 '07 #4
tdw
206 100+
No you are actually only looking for one with the same name as the database. I take it this is only a single unit database and not a backend/frontend system.

Try copying and renaming the database and see will it open that way. Were there any upgrades to the office suite implemented recently?
No upgrades that I am aware of. It was working fine last night.
But your question reminded me that when I tried to open it earlier the lower left of the window said "repairing" and had a progress bar, then my computer froze and I rebooted it. And yes, it is a single database file. I haven't educated myself yet on backend/frontend yet, so as far as I know that is not what we have.
I tried renaming the version that I just copied to my desktop, same error. However, a different copy of it that I have on my desktop (that I use for experimenting with) works fine.
May 4 '07 #5
tdw
206 100+
No upgrades that I am aware of. It was working fine last night.
But your question reminded me that when I tried to open it earlier the lower left of the window said "repairing" and had a progress bar, then my computer froze and I rebooted it. And yes, it is a single database file. I haven't educated myself yet on backend/frontend yet, so as far as I know that is not what we have.
I tried renaming the version that I just copied to my desktop, same error. However, a different copy of it that I have on my desktop (that I use for experimenting with) works fine.
I wonder if rebooting the server would work?
May 4 '07 #6
MMcCarthy
14,534 Expert Mod 8TB
I wonder if rebooting the server would work?
I'm afraid to say it sounds as if the database has been corrupted by something.

I'll see if I can get some of the other experts in here for advice.

Mary
May 4 '07 #7
tdw
206 100+
I'm afraid to say it sounds as if the database has been corrupted by something.

I'll see if I can get some of the other experts in here for advice.

Mary
Yikes! Okay, I am unable to find an .ldb...
The fact that it went into a repair automatically when I opened it this morning...is that evidence of corruption, or is the problem maybe that I had to reboot mid-repair?
May 4 '07 #8
prn
254 Expert 100+
The actual database file is on a server, should I search the server too before deleting this?
There are at least a couple of possible meanings for this: 1) "the program we run is on a server" or 2) "the program we run is on our desktop computers, but the data is on a server" or even 3) "the program we run is on a server and the data is also on a server, but possibly separate from the part we run".

You run Access but then there is a "program," let's call it MYPROG.MDB that tells Access what to do. You need to load that program and it could be on your desktop computer or on a server. Beyond that, Access stores its actual data in "tables" and, depending on how the whole thing was set up, the tables may or may not be stored in MYPROG.MDB. It is quite possible that the tables may actually be stored in something like MYDATA.MDB, which does reside on a server. (It is also possible for Access to use tables that are stored on some other kind of database server rather than tables it manages itself, but since the error message refers to the "Jet database engine" this is not likely.)

Since the error message is complaining about users trying to use the same data at the same time, if is also possible that there may be a file somewhere on the server corresponding to MYDATA.LDB.

Do you have a menu bar near the top of your Access window? Can you see a menu item "Tools"? If so, click that and you may be able to choose "Database Utilities" and then "Linked Table Manager" from that menu. If you can do that, do you get a message box saying "There are no linked tables in the current database"? Or do you get a list of tables with information in parentheses about each? If you get the first message, then the tables are part of the single database program and Mary's suggestion that it sounds corrupted is unfortunately probably right. If you get the list of linked tables, then there is likely to be a file MYDATA.LDB on the server. If so, get EVERYBODY to log off your database application and then delete whichever of MYPROG.LDB and/or MYDATA.LDB you can find on the server.

That may help. I hope it does.

Best Wishes,
Paul
May 4 '07 #9
tdw
206 100+
Yikes! Okay, I am unable to find an .ldb...
The fact that it went into a repair automatically when I opened it this morning...is that evidence of corruption, or is the problem maybe that I had to reboot mid-repair?
UPDATE!

If it helps any, I just tried to open an old backup copy from over a year ago, same error!
Yet the experimental copy on my desktop, that is only about 2 weeks old, opens fine!
May 4 '07 #10
MMcCarthy
14,534 Expert Mod 8TB
Good suggestion Paul but I gather it's a stand alone database.
May 4 '07 #11
MMcCarthy
14,534 Expert Mod 8TB
Yikes! Okay, I am unable to find an .ldb...
The fact that it went into a repair automatically when I opened it this morning...is that evidence of corruption, or is the problem maybe that I had to reboot mid-repair?
At a guess I would say this was caused because you had to reboot during a compact and repair.
May 4 '07 #12
MMcCarthy
14,534 Expert Mod 8TB
At a guess I would say this was caused because you had to reboot during a compact and repair.
Just thinking. Check to see if Access dumped your database to a copy. It would probably be called db1.mdb and be in the same folder on the server.
May 4 '07 #13
tdw
206 100+
Good suggestion Paul but I gather it's a stand alone database.
Unfortunately I cannot do anything with the file, because the error occurs open trying to open it in the first place. I did what you suggested, however, using my experimental copy on my desktop. It said there are no linked tables.
May 4 '07 #14
tdw
206 100+
Just thinking. Check to see if Access dumped your database to a copy. It would probably be called db1.mdb and be in the same folder on the server.
No, only the same files in that folder that there were before.
Should it have done a "compact and repair" without prompting for my permission first?
May 4 '07 #15
tdw
206 100+
No, only the same files in that folder that there were before.
Should it have done a "compact and repair" without prompting for my permission first?
And why would a backup copy (stored on the server) from last year not work, but a newer copy on my desktop works?
May 4 '07 #16
tdw
206 100+
There are at least a couple of possible meanings for this: 1) "the program we run is on a server" or 2) "the program we run is on our desktop computers, but the data is on a server" or even 3) "the program we run is on a server and the data is also on a server, but possibly separate from the part we run".
Sorry I keep posting after myself, but I'm kinda panicking and I want to respond to the above paragraph:
Not sure if this is what you meant, but each computer has the access software on it, the db file is stored on the server.
May 4 '07 #17
prn
254 Expert 100+
Oh Boy! If you rebooted mid-repair, that could be the problem all right. I hope that is not what happened. If you can get Access to repair the corruption you may be OK. If you can't, you may have to do something drastic like restore from last night's backups (you do back up every night, I hope) and possibly lose any work you managed to do between the backup and restore.

Don't do this lightly, though!

Losing your business data is a serious problem. If you need to restore your data from backups, then if you are not experienced in how to do that with minimal chance of losing anything, talk to someone who is. This is not a good time for "learning on the fly." And much as we all feel sympathy for you and your predicament, if is very difficult and really risky to try to talk someone through this from a distance. We can't see what you are seeing and we can't even be sure we know all the right questions to ask. Who set up your system? Can you get them to help you now?

(Holding my breath)
Paul
May 4 '07 #18
prn
254 Expert 100+
Sorry I keep posting after myself, but I'm kinda panicking and I want to respond to the above paragraph:
Not sure if this is what you meant, but each computer has the access software on it, the db file is stored on the server.
OK. I've gathered that part of the situation now. I'm just someone who writes slowly and the conversation keeps moving on.

Paul
May 4 '07 #19
prn
254 Expert 100+
And why would a backup copy (stored on the server) from last year not work, but a newer copy on my desktop works?
I think this probably indicates that you have something going on on the server. I know it's hard not to panic, but right now you have to WAIT.

Wait for the "compact and repair" operation to finish. If that does not do the job, then try to reboot the server. I don't know if that will help, but that's almost a requirement in a Microsoft environment. Do it carefully, though. Let everything finish first before you do that.

I've got some more suggestions if it doesn't help, but first things first.

Paul
May 4 '07 #20
MMcCarthy
14,534 Expert Mod 8TB
Try opening a new blank database and see if you can import the tables and other objects from the other database.

Mary
May 4 '07 #21
tdw
206 100+
Oh Boy! If you rebooted mid-repair, that could be the problem all right. I hope that is not what happened. If you can get Access to repair the corruption you may be OK. If you can't, you may have to do something drastic like restore from last night's backups (you do back up every night, I hope) and possibly lose any work you managed to do between the backup and restore.

Don't do this lightly, though!

Losing your business data is a serious problem. If you need to restore your data from backups, then if you are not experienced in how to do that with minimal chance of losing anything, talk to someone who is. This is not a good time for "learning on the fly." And much as we all feel sympathy for you and your predicament, if is very difficult and really risky to try to talk someone through this from a distance. We can't see what you are seeing and we can't even be sure we know all the right questions to ask. Who set up your system? Can you get them to help you now?

(Holding my breath)
Paul
(pulling my hair out)
Well, we have a part time IT guy who is in charge of things like setting up new computers, maintaining the server, and doing the server backups. Unfortunately, the server backs up twice per week, tonight is supposed to be the next backup. He would be the one to ask about restoring stuff, but he has almost no experience programming Access.

How can I try to get it to complete and/or start over on a compact/repair?

And lastly, any idea what might have caused it to need to repair in the first place? I have been creating new forms, etc. over the past several months. In case my boss asks, could it have been something that I did? It was working fine last night. Then suddenly not this morning, I did nothing in-between. Was it already corrupted before I had to reboot during the repair (which froze)?
May 4 '07 #22
tdw
206 100+
Try opening a new blank database and see if you can import the tables and other objects from the other database.

Mary
ok, my last response took a while to type and I missed several posts in the mean time! :-)

Not with a BLANK database, but with my still functioning experiment copy of the db, I tried to import from the real db file and got the same error message.
May 4 '07 #23
prn
254 Expert 100+
OK. I got that last post off, so while you are waiting, I'll write: :)

If rebooting after the "compact and repair" does not do the job, the first question is when was your most recent backup? If it wasn't last night, then the next thing you do after getting back whatever you can should be to start preparing nightly backups!

Take that backup copy that works on your PC, make a copy with a different name and put that onto the server. Does that work there?

Whenever your most recent backup is from, restore it to a new location and a new name on the server and try that.Let us know about the results.

Paul
May 4 '07 #24
Rabbit
12,516 Expert Mod 8TB
Did anyone happen to leave their computer on with the database opened? And by anyone I mean anyone that has access to that file on that server, not just your people.
May 4 '07 #25
MMcCarthy
14,534 Expert Mod 8TB
Compact and Repair can be set to run everytime the database closes. Open the good copy of your database. Go to Tools - Options. Under the General tab is the Compact On Close ticked? If it is I would untick it for now.
May 4 '07 #26
prn
254 Expert 100+
It could be worse than twice a week, but it could be better. Get your part-time guy to make it seven times a week! Even then, it's still possible to lose data, but the less you lose the better and it's generally hard to back up while your database is operational. (That's one of the features that distinguishes a big-time, big-business class database system from Access. :( )

See if you can get the last backup restored (without touching the current one) and see if you can test that on you PC.

Paul
May 4 '07 #27
tdw
206 100+
Compact and Repair can be set to run everytime the database closes. Open the good copy of your database. Go to Tools - Options. Under the General tab is the Compact On Close ticked? If it is I would untick it for now.
I checked and no, Compact On Close is not checked.

Nobody admits to having had the file open overnight.
May 4 '07 #28
MMcCarthy
14,534 Expert Mod 8TB
I checked and no, Compact On Close is not checked.

Nobody admits to having had the file open overnight.
If compact on close is not ticked on your computer it must be ticked on someone elses. If there are not too many users involved check each machine as this is an Access setting rather than a database one. Access shouldn't run a repair without prompting.
May 4 '07 #29
tdw
206 100+
It could be worse than twice a week, but it could be better. Get your part-time guy to make it seven times a week! Even then, it's still possible to lose data, but the less you lose the better and it's generally hard to back up while your database is operational. (That's one of the features that distinguishes a big-time, big-business class database system from Access. :( )

See if you can get the last backup restored (without touching the current one) and see if you can test that on you PC.

Paul
Okay. We have had this happen once before, last year. But that time we thought it was because an older version of Access (2000) attempted to compact and repair. We use 2003 now and this time it DID NOT PROMPT for a compact and repair. It did it on it's own when I opened the file.
Is there ANY WAY to get it to repair that file again? I know where the compact and repair option is, but I would have to get the file open first, right? and it won't open at all.
May 4 '07 #30
prn
254 Expert 100+
If compact on close is not ticked on your computer it must be ticked on someone elses. If there are not too many users involved check each machine as this is an Access setting rather than a database one. Access shouldn't run a repair without prompting.
And while you're at it, make sure that every computer that might connect to this database is NOT trying to connect to it now. Isolate the problem as much as possible.

Paul
May 4 '07 #31
tdw
206 100+
If compact on close is not ticked on your computer it must be ticked on someone elses. If there are not too many users involved check each machine as this is an Access setting rather than a database one. Access shouldn't run a repair without prompting.
That's what I thought, but it did this morning. All I did was double-click the shortcut to launch the file, it opened Access, showed "repairing" with a progress bar in the lower left corner (application task bar?), froze, and I had to reboot.
No one has compact on close checked.
May 4 '07 #32
tdw
206 100+
That's what I thought, but it did this morning. All I did was double-click the shortcut to launch the file, it opened Access, showed "repairing" with a progress bar in the lower left corner (application task bar?), froze, and I had to reboot.
No one has compact on close checked.
Could corruption have been caused by my improvements to the database, considering that it worked fine even since the last time I changed anything?
May 4 '07 #33
prn
254 Expert 100+
Okay. We have had this happen once before, last year. But that time we thought it was because an older version of Access (2000) attempted to compact and repair. We use 2003 now and this time it DID NOT PROMPT for a compact and repair. It did it on it's own when I opened the file.
Is there ANY WAY to get it to repair that file again? I know where the compact and repair option is, but I would have to get the file open first, right? and it won't open at all.
Just to make sure we all understand, you are sure that it started to compact and repair this morning when YOU opened the database, right? It could not have been that it froze while compacting when someone else closed it last night?

I'm out of my depth on why that would happen. And, for that matter, on whether you can get it to repair a database that it can't open.

Paul
May 4 '07 #34
MMcCarthy
14,534 Expert Mod 8TB
That's what I thought, but it did this morning. All I did was double-click the shortcut to launch the file, it opened Access, showed "repairing" with a progress bar in the lower left corner (application task bar?), froze, and I had to reboot.
No one has compact on close checked.
The only conclusion I can come to is that it was already corrupted and was trying to repair itself.

You said you moved from 2000 to 2003. Did you convert the database?
May 4 '07 #35
tdw
206 100+
The only conclusion I can come to is that it was already corrupted and was trying to repair itself.

You said you moved from 2000 to 2003. Did you convert the database?
Yes, it began a repair (a compact/repair I supposed, though all it said was "repairing") when I OPENED it this morning, and I was the first person today to try to open it.

We didn't MOVE from 2000 to 2003 exactly. The database was created by some other guy (who is now in jail, ironically) in, I believe, Access 2002, and did not set it up to be compatible with older versions. One of our computers last year was still running Access 2000, and we mistakenly clicked yes when it prompted us to do a compact and repair because it was corrupted. That in itself corrupted it worse because it tried to compact/repair a 2002 db using Access 2000. That time, however, it was not giving us the error message it is now. That time it was a corruption error message. All of the computers now have Access 2003, and from my understanding having a NEWER version should not hurt the 2002 file, is that right? No we never "converted the file", but I have been making improvements to it using 2003.
May 4 '07 #36
prn
254 Expert 100+
The one thing that keeps nagging at my mind is the question of how the various backup versions work or don't work. I find it extremely suspicious that an old backup does not work from the server, but a (different) old backup version does work from your PC.

I have to recommend taking (at least) those two versions and copying them to the opposite locations (i.e., the one from the server to your PC and the one that does work on your PC to the server) and trying them again from those locations. There looks to be something very fishy going on and I still think it would be worth checking. If the one that does work on your PC fails on the server, then we are definitely looking at an issue larger than just the one corrupted database (though that one is almost certainly corrupted by now even if it had not been before).
May 4 '07 #37
MMcCarthy
14,534 Expert Mod 8TB
Yes, it began a repair (a compact/repair I supposed, though all it said was "repairing") when I OPENED it this morning, and I was the first person today to try to open it.

We didn't MOVE from 2000 to 2003 exactly. The database was created by some other guy (who is now in jail, ironically) in, I believe, Access 2002, and did not set it up to be compatible with older versions. One of our computers last year was still running Access 2000, and we mistakenly clicked yes when it prompted us to do a compact and repair because it was corrupted. That in itself corrupted it worse because it tried to compact/repair a 2002 db using Access 2000. That time, however, it was not giving us the error message it is now. That time it was a corruption error message. All of the computers now have Access 2003, and from my understanding having a NEWER version should not hurt the 2002 file, is that right? No we never "converted the file", but I have been making improvements to it using 2003.
2002 to 2003 should be alright.

I think prn is right something happened last night and the database got stuck in a repair mode. You rebooting it this morning was probably the last straw.

Most of the experts aren't online at the moment. I think what's going to be required in a decompile run from outside the program. I'm no expert on this issues and would prefer to wait for better heads to intervene on this. It's a dangerous procedure and is only used as a last resort.

This essentially decompiles the application and should resolve whatever locked it up.

My advice is to wait for them to come online later and give more informed advice on this issue.

Mary
May 4 '07 #38
MMcCarthy
14,534 Expert Mod 8TB
The one thing that keeps nagging at my mind is the question of how the various backup versions work or don't work. I find it extremely suspicious that an old backup does not work from the server, but a (different) old backup version does work from your PC.

I have to recommend taking (at least) those two versions and copying them to the opposite locations (i.e., the one from the server to your PC and the one that does work on your PC to the server) and trying them again from those locations. There looks to be something very fishy going on and I still think it would be worth checking. If the one that does work on your PC fails on the server, then we are definitely looking at an issue larger than just the one corrupted database (though that one is almost certainly corrupted by now even if it had not been before).
I'm with Paul on this. It's worth trying to pin down whether there is a bigger problem with the server.
May 4 '07 #39
tdw
206 100+
The one thing that keeps nagging at my mind is the question of how the various backup versions work or don't work. I find it extremely suspicious that an old backup does not work from the server, but a (different) old backup version does work from your PC.

I have to recommend taking (at least) those two versions and copying them to the opposite locations (i.e., the one from the server to your PC and the one that does work on your PC to the server) and trying them again from those locations. There looks to be something very fishy going on and I still think it would be worth checking. If the one that does work on your PC fails on the server, then we are definitely looking at an issue larger than just the one corrupted database (though that one is almost certainly corrupted by now even if it had not been before).
I will try the swap. It seems very strange to me too that one copy works while another doesn't. Unless the corruption that occured was server specific, affecting all Access files on the server (conspiracy theory ;-) ).
Before trying anything very risky, there is one more option. I can have our IT guy come in and restore Monday's backup copy, then redo all of this weeks changes. It will be challenging to gather all of the info to do this, but it's not impossible. However, if old copies on the server are also not working, I fear that the same may be true after restoring Monday's backup of the db too. Fear unfounded? I hope so.
May 4 '07 #40
MMcCarthy
14,534 Expert Mod 8TB
I will try the swap. It seems very strange to me too that one copy works while another doesn't. Unless the corruption that occured was server specific, affecting all Access files on the server (conspiracy theory ;-) ).
Before trying anything very risky, there is one more option. I can have our IT guy come in and restore Monday's backup copy, then redo all of this weeks changes. It will be challenging to gather all of the info to do this, but it's not impossible. However, if old copies on the server are also not working, I fear that the same may be true after restoring Monday's backup of the db too. Fear unfounded? I hope so.
I don't think unfortunately we are going to get a quick fix on this issue. Let us know how you get on with the swap.
May 4 '07 #41
tdw
206 100+
I don't think unfortunately we are going to get a quick fix on this issue. Let us know how you get on with the swap.
Working on the swap now.
It's going to take about 12 minutes per file transfer apparently, although this morning I coped the db to my desktop in just a minute or two (no, I didn't copy a shortcut).

Just for the heck of it, here are the names of the three copies that I am working with.
1. Original copy (the real database): "ORDERS DATABASE.mdb"
2. Backup copy (on the server): "ORDERS DATABASE_Backup.mdb"
3. Experimental copy (on my desktop): "orders db EXPERIMENTAL COPY.mdb"
May 4 '07 #42
tdw
206 100+
Also, I have to go to the DMV, and considering it is Friday I'll be there forever. Thank you all so much for all you've done to help! I'll be back later.
May 4 '07 #43
NeoPa
32,556 Expert Mod 16PB
I checked and no, Compact On Close is not checked.

Nobody admits to having had the file open overnight.
*Edit* This was the latest post when I prepared this - wow it's moving fast *Edit*

A way to determine if the file is (currently) open elsewhere, and therefore locked, is to try to rename it.
If it works then it isn't locked and you should probably rename it back straight away.
If it is, get your IT guy to determine where it's open and by whom.

Otherwise, I would listen carefully to Paul (prn) as he sounds like he knows what he's talking about. Remember, slowly and carefully is better than quickly and (OH F*CK!)

In answer to an earlier question, Access can often get its knickers in a twist without anyone doing anything wrong. It's almost certainly responded to something you did, but probably not anything you did wrong. Don't tell the boss, but rebooting (or crashing out) during the Repair process was certainly not a good idea - but it's a lesson learned, and you probably weren't to know.

Good luck.
May 4 '07 #44
tdw
206 100+
Also, I have to go to the DMV, and considering it is Friday I'll be there forever. Thank you all so much for all you've done to help! I'll be back later.
Ok, I really leaving for the DMV after this post:

Update...
The swap didn't change anything, the version that was on my desktop runs fine from the server, the backup version from the server will not run from my desktop.
Interestingly, the backup version is duplicated in another folder on the server, and neither one will run. Also, I found another old copy called "ORDERS DATABASE old version" (which is also from last year, prior to some changes we made to it), it is also on the server and WILL run!
May 4 '07 #45
tdw
206 100+
*Edit* This was the latest post when I prepared this - wow it's moving fast *Edit*

A way to determine if the file is (currently) open elsewhere, and therefore locked, is to try to rename it.
If it works then it isn't locked and you should probably rename it back straight away.
If it is, get your IT guy to determine where it's open and by whom.

Otherwise, I would listen carefully to Paul (prn) as he sounds like he knows what he's talking about. Remember, slowly and carefully is better than quickly and (OH F*CK!)

In answer to an earlier question, Access can often get its knickers in a twist without anyone doing anything wrong. It's almost certainly responded to something you did, but probably not anything you did wrong. Don't tell the boss, but rebooting (or crashing out) during the Repair process was certainly not a good idea - but it's a lesson learned, and you probably weren't to know.

Good luck.
On renaming: it won't work no matter how I rename it, but it does let me rename it.
May 4 '07 #46
NeoPa
32,556 Expert Mod 16PB
On renaming: it won't work no matter how I rename it, but it does let me rename it.
That merely tells you that the issue is not that the file is currently locked. Good.
May 4 '07 #47
NeoPa
32,556 Expert Mod 16PB
Let's get something clear :
Access will go into Repair Mode (not compact & repair) spontaneously if, on opening a database, it detects an obvious corruption.

This dates back to when the Compact & Repair facilities were separate on the menus too.
May 4 '07 #48
NeoPa
32,556 Expert Mod 16PB
The swap idea was a good one. The results surprised me as I expected the reverse.
As it is not a server environment (could have got complex) issue, I think the best approach at this time is one I think outlined by Paul and also taken up by tdw, which is to get the latest working version and try to bring it up-to-date manually.
Depending on what changes were applied (Data; Code; Form or report design), it may be possible to import them from the latest (corrupted) version.
May 4 '07 #49
MMcCarthy
14,534 Expert Mod 8TB
The swap idea was a good one. The results surprised me as I expected the reverse.
As it is not a server environment (could have got complex) issue, I think the best approach at this time is one I think outlined by Paul and also taken up by tdw, which is to get the latest working version and try to bring it up-to-date manually.
Depending on what changes were applied (Data; Code; Form or report design), it may be possible to import them from the latest (corrupted) version.
We tried an import earlier. I gather it didn't work
May 4 '07 #50

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

Similar topics

2
by: RX | last post by:
I try to use PHP to redirect to other page and failed. Please give me a help. Thanks. The script is: if($rows_num>0) { session_start(); session_register("userid");...
9
by: Alex Martelli | last post by:
All my mailboxes have been filling up with files of about 130k to 150k, no doubt copies of some immensely popular virus. So, I've no doubt lost lots of real mail because of "mailbox full"...
4
by: Kerim Borchaev | last post by:
Hello! Always when I use "super" I create a code duplication because class used as first arg to "super" is always the class where the method containing "super" was defined in: ''' class C:...
2
by: David MacQuigg | last post by:
I think there is a documentation error in both the Library Reference section 2.1 and the Python 2.2 Quick Reference page 19. The explanation for this function is: super( type) Returns the...
0
by: Delaney, Timothy C (Timothy) | last post by:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/286195 This is a new version of super that automatically determines which method needs to be called based on the existing stack frames....
5
by: Jeff MacDonald | last post by:
Hi, WHen i run pg_dumpall as the super user it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ?...
2
by: systrader | last post by:
Our dba is out on vacation, we lost power, db2 came back up but it's mounting to wrong point. We do not know the name of the mount point it should use nor do we know how to change it. We will...
10
by: Finger.Octopus | last post by:
Hello, I have been trying to call the super constructor from my derived class but its not working as expected. See the code: class HTMLMain: def __init__(self): self.text = "<HTML><BODY>";...
1
by: nsymiakakis | last post by:
Hi everyone, I have two seperate queries that work great individually, but I need to join them together to get a combined output. Can someone look at these and help me with the code? Here are the 2...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.