Halp Access DB buffs

Coqui

Piccolo Pete
Oct 14, 2004
35,593
4,667
673
43
Columbus, OH
I have a tough one for you guys.

We have an access DB that when attempting to run macros off of it to execute the program, it returns an error "3274: External table is not in the expected format" So it's a formatting error right? Wrong. We have one machine that is able to run this without issue (all computers are running Office 2007) and all other machines are not able to run it.

We first though this had to do with FoxPro extensions, but this occurs on machines that have the same FoxPro setup as the one that does work. (not all clients have FoxPro installed though)

I really don't know anything about this stuff and would love if anyone could guide me somewhere to resolve this issue.
 

Coqui

Piccolo Pete
Oct 14, 2004
35,593
4,667
673
43
Columbus, OH
all macros?
what are the macros trying to do?
what program?

The macros themselves load up the SUM_HDR file and the Detail file to process. This program basically totals all amounts for benefits paid. By program I mean clicking on Run within the Access DB so that it executes and exports the data to excel.
 

Duke

. . first name's "Daisy" boys
May 12, 2008
55,859
18,143
41
Brandon, FL
Hmm. Need more info. I'm leaning, already, to a rights and permissions issue.

Is the external data source centralized. Is it local to the system that can run it, but shared to those that can't?
 

Coqui

Piccolo Pete
Oct 14, 2004
35,593
4,667
673
43
Columbus, OH
Hmm. Need more info. I'm leaning, already, to a rights and permissions issue.

Is the external data source centralized. Is it local to the system that can run it, but shared to those that can't?

It's not a permissions issue. I'm an admin on my machine (as well as domain admin) and can't run it. The files all reside locally though.
 

Duke

. . first name's "Daisy" boys
May 12, 2008
55,859
18,143
41
Brandon, FL
Just checked. I have full access to all files explicitly mentioned.

Usually enough. You can always be sure, go into props, uncheck inheritance, and copy local rights onto a recursion of the files. Thats makes sure.

Check to see what versions of .Net & Java. Java probably don't matter, but if it's some weird VB error, .Net might be involved, especially since it seems to be related to some ODBC processes.

Ah, on the machine that it works, was it there for a long time, and you just recently copied the software over to other machines. Has it never worked on the others. Was it installed at the same time on all 3?
 

Coqui

Piccolo Pete
Oct 14, 2004
35,593
4,667
673
43
Columbus, OH
Usually enough. You can always be sure, go into props, uncheck inheritance, and copy local rights onto a recursion of the files. Thats makes sure.

Check to see what versions of .Net & Java. Java probably don't matter, but if it's some weird VB error, .Net might be involved, especially since it seems to be related to some ODBC processes.

Ah, on the machine that it works, was it there for a long time, and you just recently copied the software over to other machines. Has it never worked on the others. Was it installed at the same time on all 3?

Sorry, that's what I meant by explicitly mentioned. Not inherited from a group or another folder but explicitely granted to me as full access. The timeframe between on a computer that worked and the others was minimal (less than 1 month). It has never worked on the other machines.
 

Duke

. . first name's "Daisy" boys
May 12, 2008
55,859
18,143
41
Brandon, FL
Sorry, that's what I meant by explicitly mentioned. Not inherited from a group or another folder but explicitely granted to me as full access. The timeframe between on a computer that worked and the others was minimal (less than 1 month). It has never worked on the other machines.

Did you check ODBC sources on the original machine versus the failing ones?

Is there maybe some hard coded details pointing to the data source that don't migrate? For instance maybe a static destination address or AD share or something
 
Last edited:

OzSTEEZ

¡ɟɟo ʞɔnɟ ʇunɔ 'ᴉO
Nov 11, 2008
35,329
9,393
473
40
Oz
I'd have to do some reading, but off the top of my head have you installed the VFP driver for access (can you select it in the File Type drop down)?
 

Coqui

Piccolo Pete
Oct 14, 2004
35,593
4,667
673
43
Columbus, OH
More information comparing the machine that works and the ones that don't.

Under Relationships, One table comes up empty, and it won't open up another one. (Total of three tables)