distribute Access application with ODBC links

M

Michel Bernard

I have purchased MS Office ACCess 2003 Developer Extensions in order to
distribute my small application on 10 computers.
My application seems good but I have some troubles with ODBC links to
the tables. How to process to build again the link on each computer ?
As developper, I can link the tables but the others computers have only
run-time :-(
Is there a tip ?
thanks for your answers
 
B

Brendan Reynolds

There is code to do this at the following URL ...

http://www.mvps.org/access/tables/tbl0010.htm

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
A

Arvin Meyer

I've not used the runtime with ODBC, but I've used plenty of ODBC
connections. You should be able to put everything in the same place on each
computer so that you can find everything. When you create the DSN on each
computer, make sure you give it the same. One thing that I found yesterday
is that DSNs do not seem to like Roaming Profiles on some computers.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top