Help!! Database Corrupted!!!

Aug 13, 2006

Hope you can help guys. Here's what happened.

I saved a form as a different name so that I could work on it. I made some changes to the new saved form then tried to save it to the name of the old form, to overwrite it. It came up with an overwrite warning, i said yes and suddenly the database went crazy and had to shut down.

When I restarted, the form I tried to overwrite was gone from the list, but the one I had worked on was still there, so I thought, "thats ok, I'll just rename it".

Well, it won't let me rename it either, and comes up with error messages all the time now saying that the form that was overwritten no longer exists. What have I done!!!!

View Replies


ADVERTISEMENT

Corrupted Database?

Feb 5, 2008

Hi,

I have just got back from leave and found out my contacts db has corrupted whilst i have been away. Unfortunately during this time the automated backup has copied the corrupted file so that is now useless as well.

When i try to open the file it says 'Error cannot find object 'Database'. I have tried doing a compact and repair on it but get the same message. Is there anyway i can get this back?

Thanks

View 2 Replies View Related

Corrupted Mdb

Oct 27, 2005

Hi i have a small issue with a few databases a friend has asked me to help with. let me explain then you will know all that has happened.


4 days ago my friends server crashed .. hard drive failure .. so he thought

he brought the machine to me to see if i can get it fixed .. turns out the raid firemware on his dell server was flakey and needed updating over a year ago which he hasnt done. anyway it crashed same day his tape back up system his tapes he had to wipe clean and start a fresh so he has no backups ... and the raid on his server failed so now he has no data.

i used easy recovery professional to pull all the files back which it has i have repaired all the exel files but when i have tryed to do repaires on the mdb files it just says failed so for the last 2 days i have been hunting the internet for access repair tools and everything i have tryed has failed.
Some of these mdb files are over 1gb in size is there anyway to view the raw data like some other databases allowing me to pull all the tables and back?

when i try to open the files in access it comes up with an error saying unable to open un recognised formate. i have used advanced access repair tool i found on the net and that after spending an hour analizing the file said it failed.

this has been a real evil favour i did for a friend and i wish i never did it but i need to finish it can any one help im not a software guy as you may have noticed im a hardware guy myself so my knowledge on access is very limited.

View 1 Replies View Related

Corrupted Data

Oct 23, 2007

Hello,

I'm relatively new at Access and not quite sure where to post this problem. Anyway, I have a complaint database with multi-users. Twice now, I've had the data in two of my records change to what looks like a foreign language. I'm wondering if this has happened when a user tries to filter records within the database. Has anyone had similar problems such as this? If so, is there anyway to correct the text, or to prevent this from reoccuring?

Thanks!

View 3 Replies View Related

How Can I Tell If FE Is Corrupted? Error With JET Utility.

Apr 12, 2006

The FE of my database has been crashing during the last week and there have been a few other problems. I got errors saying that the BE was an 'unrecognised format'. I remember getting a 'not a valid bookmark' error also.

Another odd thing that was happening - when I put breakpoints in my code it was not breaking and stepping through it. It was like they weren't there. I realise now that editing the code while it was in break mode may have caused problems.

I didn't realise these issues were signs of corruption (until I started reading up on the subject and searching this forum) so have no idea when it started or what could be corrupt.

I used the compact and repair facility and it seemed to work fine. I can open all the forms and reports. I also decompiled the FE and it hasn't crashed since but I don't know if the problem is completly solved. From what I've read the problem could get much worse if I don't deal with it now.

The reason that I think that there may still be a problem is teh fact that the JEt compact utility will not work. I just get an error saying 'Error compacting database' straight away.

Is there a way to tell if something is corrupt or am I worring unnecessarily?

View 5 Replies View Related

Corrupted Records After Linking Table

Dec 3, 2004

Attempted to link to a table on an SQL Server, which included customer records & various contact dates, after the importing the records became corrupted in that they repeated the initial date over & over e.g.

Customer Date
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04

...as opposed to listing same account number but with 4 different contact dates...also when the Access database was opened on a different PC (also Office 2K) the table was displayed correctly?

Has anyone else come accross the same issue, any advice/guidance much appreciated. :rolleyes:

View 1 Replies View Related

Tables :: Corrupted Auto Number

Feb 17, 2015

As part of a larger multi-user system there is a time recording part with a simple table called tblTime with an autonumber field. Today at 11:45 users started reporting receiving a 3022 error. On looking at the table I noticed that if I tried to manually add a record then the ID field number inserted automatically was not the next number in sequence, but one that already existed, hence the error.

View 2 Replies View Related

JetComp Won't Work - Have Corrupted Table That I Cannot Delete

Aug 29, 2005

Hi.
Have a multiuser front and back end database.
Apparently 2 records (without memo fields) got corrupted. I could not delete the records so I tried compact and reair without being able to do either. I tried JetComp but it said it could not fix it. I cannot even delete the offending table.

Help! I have major reports due.

Russ

View 2 Replies View Related

Tables :: Recover Data From Corrupted Table?

Dec 5, 2012

recovering data from a corrupted database. I have a huge table with almost 600K rows and 140 columns. I went to Database Tools, Visual Basic, Tools, References. There was a broken utility file. I removed it by unchecking the box and closed and returned to my db. I did make table query from the corrupted table and then imported it into a fresh db.... but still I cannot run an append or update query successfully.

View 1 Replies View Related

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Forms Count Of Other Database Without Opening That Database Physically

Oct 7, 2005

Hello All...

Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..

Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject

Set frm1 = AcProj.AllForms

intCount = frm1.Count

But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..

Thanks in advance..!!

View 4 Replies View Related

Modules & VBA :: Open Database / Run A Query / Close Database

Aug 22, 2014

i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.

View 4 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

General :: Database For Metal Market Prices To Be Used In Another Database

Jun 24, 2015

I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.

There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?

View 14 Replies View Related

Jet Database Engine Error On Non-shared Database

Jul 7, 2005

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an 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." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

View 3 Replies View Related

Best Way To Import SQL Database To Local Access Database?

Dec 25, 2005

I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.

Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.

View 3 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related

Accessing A Table In Database A From Database B

Aug 29, 2005

Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.

View 2 Replies View Related

Create EXE From Database And Have Several Project Using Same Database

Oct 24, 2013

I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.

the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.

Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?

I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.

Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.

This way we can have several txt file for several project and use always the same exe database.

View 4 Replies View Related

Linking To Another Database From On Database

Nov 20, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch :eek:

View 4 Replies View Related

How Can I Save My Database As A MDE Database.

Oct 2, 2007

The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp

Jabez

View 6 Replies View Related

Launching Another Database From Within A Database?

Dec 21, 2013

I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.

View 3 Replies View Related

Car Database Help!

May 24, 2005

I have a car dealership database and have a servicing section.

I want to create a form to service these vehicles.

The only vehicles which will be displayed on the from are the sold ones (because you cannot service a vehcile which hasnt been sold) which i have a query for.

I also want the form to display the customer who owns the car the service details (eg what they need), the parts availiable and the parts required for the service.

The calculations i need to make in this form are as follows

quantity needed (parts required table) - quantity in stock (purchasing customer parts table)

quantity needed (parts required table) * price (Parts Table) + labour (servicing table) = part/labour costs (servicing table)

http://pic18.picturetrail.com/VOL885/3178839/6480291/97832270.jpg

any suggestions on how to do this would be fantastic

View 2 Replies View Related

I Really Need Help With My Database

Jan 4, 2006

i havent been able to figure out how to get my subform to work properly....
i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 )

it is really important that i figure this out so that i can keep my job..

how else can i obtain help? even if i have to pay for it?

what do you guys suggest?

View 4 Replies View Related

Can't Log On To Database

Feb 13, 2006

Hi all,

I was playing with passwords for one of my access db.

I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?

I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.

Please help

Thanks!

View 3 Replies View Related

Database

Apr 3, 2006

Hello Here is my question I have a datbase with 4 tables
I have one of the table related to the other 3 by agent name.

I Have a page with the agents and all thier info. NO problem
I want to create a link from each agent to thier listings..

Do I need to have a seprate page for each agent or can one page
create the info I need with that agent..??

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved