2003 vs. 2007 issues

[larochy]

Hi,

I have a client who uses Access 2007 and the database I built for them is in
2003. When the client requests changes, I usually make the changes on my
front-end copy of the 2003 database and send it over to them after the
updates are made. For whatever reason, when the client receives it, opens
the database and updates the Linked Table Manager, they can’t see any of the
new queries, forms, reports, etc that I built for them. Has anyone heard of
this happening or have any ideas as to what could be going on?? I even
checked to make sure the database works in my copy of 2007 before I sent it
over to them.

I haven’t converted the database to 2007 because it seems to corrupt the
code quite often so I’ve been hesitating to fully convert their DB over to
2007.

Let me know if anyone has any suggestions.

 

[larochy]

PLEASE DISREGARD, THE CLIENT JUST RESPONDED AND IT WAS USER ERROR ON THEIR
PART.

 

[Peter Hibbs]

It would probably be a lot more 'user friendly' if you added some code
to re-link the tables to the back-end automatically, rather than
relying on the client to do it every time.

There are several schemes around the Internet to do that, see the BE
Relink.mdb code at :-
http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
for one method.

Peter Hibbs.

 

[larochy]

Good suggestion....thanks!

It would probably be a lot more 'user friendly' if you added some code
to re-link the tables to the back-end automatically, rather than
relying on the client to do it every time.

There are several schemes around the Internet to do that, see the BE
Relink.mdb code at :-
http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
for one method.

Peter Hibbs.