Basic questions

[Joe Cilinceon]

I have my DB split now but have some questions. Can you link to more than
one backend DB in different locations?

 

[Rick Brandt]

I have my DB split now but have some questions. Can you link to more
than one backend DB in different locations?

Certainly.

 

[Joe Cilinceon]

Thanks Rick wasn't sure

Certainly.

 

[Jeff Boyce]

Joe

What happens when you try it?

 

[Joe Cilinceon]

It worked fine and I was just curious if it worked. I didn't want to try it
unless someone who knew something about access thought it would work.

 

[Rick Brandt]

It worked fine and I was just curious if it worked. I didn't want to
try it unless someone who knew something about access thought it
would work.

My main app at work links to three different SQL Servers, an IBM ISeries, a
handful of Paradox tables, several Foxpro databases and some text files with
all of these being dispersed all over our LAN. The surprising thing is that
it doesn't have any permanent links to any Jet MDB files although I do use
temporary links to one for an import routine.

That is one of the great things about an MDB application. You can use lots
of data sources in lots of locations.

 

[Joe Cilinceon]

Thansks for the information Rick, it seems every day I'm learning more about
Access. g