Linked table - column order has changed

[jeanluc]

Hi,

I have a DB which contains my application : myApp.mdb
I have a DB which contains my data : myData.mdb, containing one table :
myTable (column C1, C2, C3, C4, C5)
Within myApp.mdb I have a link to myTable.
This configuration is installed on some PC.

Weekly, myTable (within myData.mdb) is updated (centrally) with an external
VB tool (deleting and adding records) and copied on each PC where it is
installed, in order to have a common update.

This worked without any problems since years.

Recently, it happened that myApp.mdb couldn't retrieve the data.
The problem was, within myApp.mdb, when opening the linked table myTable,
the columns had another order (meaning C3, C2, C4, C5, C1) than in the
original table (where it looks OK, when I open it directly)

The only way to correct this was to redo a Refresh Link within the myApp.mdb

Is this problem known ? And how is it possible to avoid this ? Because, it
is not always sure that users see such problems immediately.

Thanks.

Regards.

Jean-Luc

 

[Arvin Meyer [MVP]]

It is very likely that an employee with direct access to the data source
(tables and queries) moved them around to suit his/her preference. The only
2 ways to stop that are denial of direct access and training. The first
works always, but may also inhibit some workflow.

 

[jeanluc]

Sorry to bother, but this is certainly not the problem; the centrally updated
DB (myData) containing myTable is not accessible to the users. Also the myApp
is protected against changes.

Regards.

Jean-Luc

 

[Arvin Meyer [MVP]]

Jean-Luc,

Unless you have poltergeists, there's no way that columns can move around
"by themselves"

If you haven't hidden the database window in your front-end and set the
AllowByPassKey to prevent someone from unhiding it, it is possible for
anyone who can open the app to get access to the columns in tables and
queries.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[a a r o n . k e m p f]

wow.. I think that you guys are both wrong.

I'm not positive-- that MS respects silly things like 'column order'..

I've been asking for improvements in 'fixing column order' and
'displaying columns alphabetically' for a long time.

MS just doesn't care about 'column order'.

Seriously
I'm just not positive-- that MS is willing to guarantee that table in
XYZ order will always stay in XYZ order.

-Aaron

 

[a a r o n . k e m p f]

Boob;

I'm not so sure that I appreciate your attacks.

-Aaron

 

[jeanluc]

Hi Arvin,
Is it possible to send screen shots, perhaps to better explain what I mean ?
Thanks.

Regards.

 

[Arvin Meyer [MVP]]

Hi Arvin,
Is it possible to send screen shots, perhaps to better explain what I mean
?
Thanks.

My email address is at the first website below. I'll temporarily put you on
my whitelist. Make sure that you label it with your name or it will be
automatically rejected.