Split Database

[Ruben Granados]

Hi, I'm pretty new in Access and VBA

I finished a Database, then I split it. Now I'am facing
the problem of relinking tables (I want to make sure that
no matter the path the user can always find the links, if
I'm bad in computer stuff they are worse.. so I don't want
to leave this to them)

I found a code in a book. For me it's to complex. until
now I don't know if it doesn't run.
This Error occurs when compiling:
"User defined type not defined"
and this declaration is highlighted
Dim oDBInfo As dbInfo
It's exactly as it is in the book, what's going wrong?
Pls any help will be appreciated. Also if someone knows a
better way for relinking (by code) it will help me tons.
thx.

 

[James Goodman]

That error means the UDT, "dbInfo" is not defined. Somewhere in the book it
should have the code required to declare it...

 

[Susan]

Hi.

When I make changes to my system and then move the
application to each users pc (I have a split database). I
need to 're-link' the tables. I believe this is what you
are trying to do.

Go to database window (where tables, forms, reports,etc)
is. At the main menu, click on Tools, DB Utilities,
Linked Table Manager. Then click the box 'always prompt
for new location'. Then click on Select All. From there
you will search for the location of your database, click
on it and click OK. This should do it.