corruption after using 2010

[the_net_2.0]

all,

I had an accdb that I opened in 2010 trial version and I used a usb to transfer it over to the netbook I made changes on. Now when I come back to my desktop I see the message "db not in recognized format - accdb". is it corrupt?

anyone run into this? if so, did you find a solution? thanks!

 

[gemma-the-husky]

maybe you have saved it as an Access2010 database, and therefore its not recognizable to your A2007 laptop?

 

[Banana]

Gemma - there is no such thing as "2010 ACCDB file format". It still uses 2007 ACCDB file format even though if we add new features that are 2010-only, it may restrict the usage in 2007.

But Gemma does ask a good question - are you using 2007 on one of your computer or are both 2010?

 

[boblarson]

It still uses 2007 ACCDB file format even though if we add new features that are 2010-only, it may restrict the usage in 2007.

If 2010 features have been used, 2007 will report an unrecognized database format. I've experienced that with posters here who have uploaded a 2010 ACCDB file and I try to open it with 2007 SP2 and it fails with that error message.

 

[Banana]

Yes, unfortunately, it's not always consistent. In theory, and it does happen now & then - when you add a 2010-feature only, we should see a message that may vary from "you can't open this form in design mode", "you can't use this object in 2007", or something like that. So, a file that had one form with say, Navigation Control would be still usable in 2007 as long one didn't try to open that form. Obviously this "feature" does not always work and like you, I've seen few report "Unrecognized File Format" which should have never happened but does anyway. But then again, I really think they should have create a proper 2010 File Format to start with.

 

[the_net_2.0]

thanks you guys.

well, we may have found something then. I am of course known for not seeing the obvious sometimes, but I'm almost 100% sure I added controls/code/macro actions that can be seen in 2007 as well. Actually, all I was doing was modifying a NW database from the 2007 samples. But then again, I made a lot of modifications in the embedded macros that were already there. I believe I used the "set property" action a few times too in the macro builder. is that new to 10?

but at any rate, this brings up another question as well...I'm using a linux grid server and when I transferred this db via USB, I first tried to upload and download from my server through DOS. I did this 3 times, and everytime the upload went AND the download went, but an unzip with WinRar on my LT was impossible because the "archive was corrupted" it said. does that make sense to you guys?

godaddy says it is because of malicious content. I am still waiting to hear from them on whether or not they allow macro-driven files on these type of servers. Can you guys offer any advice on that?

thanks so much!

 

[boblarson]

godaddy says it is because of malicious content. I am still waiting to hear from them on whether or not they allow macro-driven files on these type of servers. Can you guys offer any advice on that as well?

You can't have macros or code in a database file on a web server like that. If you are using it as a backend on a web server, all you can really use are the tables (and I believe queries). But no forms, reports, macros, or code.

Why are you using Godaddy and what for? You can't use the new Web stuff in Access 2010 without SharePoint 2010 (at least that I know of).

 

[the_net_2.0]

Why are you using Godaddy and what for? You can't use the new Web stuff in Access 2010 without SharePoint 2010 (at least that I know of).

thanks bob. Did not know that. Is this specific to Linux? I have up'ed and down'ed mdb files for 3 years now on another webserver that is windows based. I have done it with them zipped and unzipped, with no problems.

I do use Access as a FE with MySql as the backend, but I do not have any access files on this server for storage use. Also, I am not involved in a setup right now to use Sharepoint, so I really have no use for those Access 2010 features.

 

[boblarson]

Just uploading/downloading the file shouldn't be a problem - however it may be that their detection doesn't like the fact that macros exist. I was thinking you were using the file itself as a backend.

So no, I don't see why uploading and downloading like that shouldn't work. However, like I said, it could be that their process in checking the files for "malicious content" happens to disable it and thereby corrupting the file. I've not had problems on a Windows based server as well but haven't had the need to use their Linux servers.

 

[Banana]

Does it make any difference if you obfuscate the file extension prior to zipping it up then obfuscate the archive file's extension as well?

I have to admit I don't really get the point of uploading/downloading? Normally, one would distribute the files via an email or via a network shared folder (which typically isn't same as the web server for security reasons) or something along those lines.

 

[the_net_2.0]

Does it make any difference if you obfuscate the file extension prior to zipping it up then obfuscate the archive file's extension as well?

I have to admit I don't really get the point of uploading/downloading? Normally, one would distribute the files via an email or via a network shared folder (which typically isn't same as the web server for security reasons) or something along those lines.

There are no security concerns here Banana. This is nothing special...just had to move to another machine because a party was taking place in my living room.

Yes, I could've emailed it, and I will do that from now on if I don't get an answer back from go daddy. I will also try what you have mentioned about the extensions when I get around to it.

thanks again guys. some good knowledge here..

 

[Mgomp]

Hi there.
I am sorry to say - I have found (almost) the same problem here.
When I copy my access 2010 app from one pc to an another pc, the forms which have queries as source goes blank. (no info, no nothing). When I tries to run the queries manually, I got a error message similar to "invallid data reference".
When opening the query for editing, then close and save (without changed anything) everything seems to work fine.

Please excuse me for dobbel posting from a another thread, but I am realy frustrated over this.

Regards.

 

[boblarson]

Hi there.
I am sorry to say - I have found (almost) the same problem here.
When I copy my access 2010 app from one pc to an another pc, the forms which have queries as source goes blank. (no info, no nothing). When I tries to run the queries manually, I got a error message similar to "invallid data reference".
When opening the query for editing, then close and save (without changed anything) everything seems to work fine.

Please excuse me for dobbel posting from a another thread, but I am realy frustrated over this.

Regards.

Probably a missing reference as something on the other machine isn't registered or even there.

 

[Mgomp]

Probably a missing reference as something on the other machine isn't registered or even there.

Well, how can it not be there when I only opens a query for editing (without actually editing), save the query and then the problem is solved?

For me it's very close to call this a bug... (very very close....)

All computers used for testing (5 pcs) where all running with win 7 and Access 2010. I only copying my app from one pc to an another, and the problem occur on the target computer.
I havent told it before, but the app is split app, and I have re-establish all the link on all computers. When reopening after relink, the problem occurs. For the test, both files ("client" and "common data") exist on all computers.

Regards