Hi, Roelaux-

If your tables and DBC are in the same directory as your EXE you can in your main program do *something* like this

SET DEFAULT TO SYS(2003)

. Then, whenever you

USE myDBF

the table (and its memo and indices) will be found and opened.

If you are using the DBC, you don't have to separately open the DBC, but if you want to, the command is

OPEN DATABASE myDBC

.

Note, this is a bit more complicated if your data is not in the same path as your exe. Then you can use SET PATH to tell your EXE where to look for files. That's a start. It can be just about as complicated as you need it to be, so please repost a follow up to your thread if this doesn't make sense or doesn't fit your situation.

HTH

>In the FP examples they are constantly use the home()command + \test\data\ my data is not in this directory.(I really fell dumb asking this) Please give me some examples of how to point to and open my database container programmaticly so that I can call the program to ensure that I'm pointing to my data set before I run a program.