Search results

Guys, Thanks for the support. With the file I uploaded isolated I can get it to open. I have since found a more recent backup which I cannot for the life of me get to open under any circumstance. Would one of you be kind enough to give it a spin...

Hi, Thanks for the support guys. @copper: Ive had a look at the file you send and it appears that DataNumen has just pulled what it could from the tables. There is none of the code from any of the forms in there :( @Kevlray: I think you might have the key! Please could you run a compact and...

That's great news!! I've no idea why it doesn't work on any of the machines I've tried it on! Is there any chance you could run a compact and repair on it and uploaded it again somewhere for me to try again this end?

Hi, I've uploaded one of the corrupted accdb files I recovered to google drive here https://drive.google.com/open?id=0B3yL2Bu9HM0qU3FWV2JTNkRsREU&authuser=0 TIA

Does anyone else want to chime in see if they can help me on this? I'm at my wits end!!

Hi Guus thanks for your reply. I just tried putting a clean Access 2013 on a vanilla test rig then tried to import the objects from the old accdb file, but my favourite error still comes up when I point Get External Data wizard at the accdb. I can share the file with you if you would try it your...

I have a problem with a DB I started work on a couple of years ago in Access 2010. I fired it up last week and now I'm getting an "unrecognized database format" error when I try and open the front end. I left this project sat after the company lost interest in finishing it. Since then I worked...

Re: Back to work on an old project and greeted with "unrecognized database format" Im now back in the office after a fun few days with food poisoning. Anyway, it looks like the files are all actually corrupt :mad: Its just very strange as they weren't automatic backups. They were copies I made...

Re: Back to work on an old project and greeted with "unrecognized database format" I did create a new blank DB today with some basic forms and tables just to test out the installation of Access on the dev box, and it worked fine. Its just dawned on me as well that the machine with the 32bit...

Re: Back to work on an old project and greeted with "unrecognized database format" Hi CJ, Sorry for the confusion. I have a plethora of daily backups and they all give the same error, which to me makes me think the files are OK. I also managed to find a VHD backup from the original file server...

Re: Back to work on an old project and greeted with "unrecognized database format" Hi CJ, I tried using the decompile command with a view to recompiling the VBA, but I get hit with the same error. Is there another method of doing this? With regards to the references, this dev machine is a...

Back to work on an old project and greeted with "unrecognized database format" Today I fired up a front end which I started developing almost two years ago, as we now have a need to finish the project. I wasn't expecting it to be all plain sailing as since I last worked on it, my development...

bump to the top

I have the following query, which is producing the results I need in my overview report, but it is EXTREMELY slow! It takes almost 12 seconds to execute on the local machine with is a very high spec brand new quad core machine with 8GB of RAM. This database will be running across a network, with...

Figured it out. I needed a sub-query which I didnt even know was possible. Heres the SQL for anyone who want to achieve something like this in the future. +1 thanks to me.... SELECT tblLotes.Sector, tblLotes.Manzana, tblLotes.Lote_No, tblClientes.Nombre & " " & tblClientes.Apellido AS...

OK. So Ive figured out what I was doing wrong with the Client information lookup, and that was that I was adding the ClientID field from both tables and hiding them (I thought this would be required for the cross-refrencing of the data, but the relationship seems to take care of this for me). I...

With regards to the overdue status being set calculated programatically, it is. I wrote a function in VB to do this, so that it can be called automatically at midnight (if the DB has been left open overnight) or once when the DB first starts. I loop round all the plots in the table when I do...

Hi, Thanks for the prompt reply. As far as I am aware I havent used any reserved words, as my field names are all in Spanish! I translated them above as so you could easily see what I am trying to achieve. The actual field names can be seen in the SQL below what I have so far: SELECT...

I have a database where I have have (correctly I think) normalised out my data, however now Im trying to create some queries which pull data from four different related tables and Im really struggling. My database is built around a Plots table (tblPlots) which has the following fields PlotID -...