How do I make Access runtime packages connect to my back end data.

B

Bob Scullen

I used the new Package Wizard to create run time packages to distribute.
When I try to use them on my local area network, they return an error saying
that 'C:\folder\file' (which is the back end database on my PC) is not a
valid path. What am I missing in getting this connection made?
 
T

Tom

C:\Folder\file is only applicable to your pc. would suggest that you reset
the path statement to a UNC statement e.g. \\<your pc's ip address\< shared
folder name>\filename

Tom
 
P

Paradigm

I use the following code to delete the tables and then reattach them, simply
repeat the code for each table

DoCmd.DeleteObject acTable, "MYTABLENAME"
Set tbl = CURRENTDB.CreateTableDef("MYTABLENAME")
tbl.Connect = ";Database=" &
PathandFileNameofMDBfileContainingMYTABLENAME
tbl.SourceTableName = "MYTABLENAME"
CURRENTDB.TableDefs.Append tbl

You can store the location of the backend as a field in a local table and
then reset it if the backend moves.
Alex
 
Top