473,406 Members | 2,390 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,406 software developers and data experts.

Unrecognized database format

I have a split database where the data file is located on the server and the program is located on individual workstations. We are getting the following error message on all machines when we try to open the program

"Unrecognized database format '\\RWT-FILESERVER\Public\Documents\RWT\Documents\Company Database\Company Data.mdb'

We cannot open it on the server itself either. Can anyone offer suggestions as to how to fix this? This is main database for our company.

Thanks
Sep 19 '18 #1
4 1759
twinnyfo
3,653 Expert Mod 2GB
Have you recently had a software upgrade? the .mdb files are for a very much older version of MS Access. There should hav ebeen some form of upgrade performed along the way....

Are you able to copy the file to a local machine and try to open it locally?
Sep 19 '18 #2
NeoPa
32,556 Expert Mod 16PB
If you aren't doing regular backups then you should be. Any commercial enterprise that doesn't nowadays is not being run by professionals. That's a given.

If you are, then the obvious answer, if Compact & Repair fails, is to revert to your latest working backup.

If you haven't been taking regular backups until now then you'll probably be going through a painful learning curve right now. Make sure you never experience any such situation ever again.

If you really haven't got a usable backup and C&R actually doesn't work to recover your database then there are commercial (paid for) services that you can find that *may* be able to recover some or all of your data.

Good luck.

PS. For anyone else who may be tempted to post links to commercial software in here, please be warned your account will be banned as soon as this is noticed by the first of our moderators who sees it.
Sep 21 '18 #3
Seth Schrock
2,965 Expert 2GB
I recently had this happen and I just had to open the backend database and it said that it was in an inconsistent state and needed to do something to fix it. When I clicked OK, it did its thing (including a backup) and then it worked fine from the front end.
Sep 21 '18 #4
NeoPa
32,556 Expert Mod 16PB
Hi Seth.

"It's thing" included a Compact & Repair. In most cases that does the trick. You don't need to try to open it first, but that's certainly one way of getting the C&R to run.
Sep 21 '18 #5

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

Similar topics

7
by: qbsu21th | last post by:
Dear Sir/Madam, I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecognized database format 'xxx/xx/*.mdb' " error....
14
by: L Mehl | last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE...
1
by: Rabbit | last post by:
Can anyone tell me why my web developed in .net 2.0, using Access database (.mdb). working fine at my development machines, but when I deploy it onto new Windows Server 2003, the web returns...
6
by: James12345 | last post by:
i have created a database for our advisors to log their call types. It is being run on about 10 different machines. Every couple of weeks, when someone tries to open it, the error Unrecognized...
1
by: syed_razi | last post by:
I have a VB 6.0 application using Access as backend. It is being used on a local area network. The backend database is password protected. The problem is that the database gives me a run time...
4
by: HeislerKurt | last post by:
I'm having trouble opening a database a client has sent me. I keep getting an "unrecognized database format" error. The database was created in Access 2003. I'm trying to open it with Access...
4
by: Hepburn08 | last post by:
Hi, I need some help opening a corrupt Microsoft Access database file. I get an error message that says "unrecognized database format". Since I can't open it, I can't export the data to another new...
6
by: MISASIA | last post by:
I really hope someone can help me... My office is using a Menu which running VB. There got many button in that Menu and one of the button which name as "GMR" hit error. Its prompt a message box...
1
by: vinayreddy | last post by:
unrecognized database format error vinay.mdb file size its showing has 1kb. so can you please provide me the solution for solving the problem.
1
by: wassimdaccache | last post by:
Dear friends I have an access file (*.mdb) working on office 2003 sp2 when i am opening the file i am getting the bellow : unrecognized database format I've tried to compact and repair...
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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

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.