Splitting the database

[dhstein]

When I split the database, I'm specifying a back-end location of
\\server-name\sharename\MyDatabase_be.accdb. Does that UNC get stored in the
front-end copy so that when it gets deployed the users will be able to
connect to the back end? Thanks for any help on this.

 

[Tony Toews [MVP]]

When I split the database, I'm specifying a back-end location of
\\server-name\sharename\MyDatabase_be.accdb. Does that UNC get stored in the
front-end copy so that when it gets deployed the users will be able to
connect to the back end?

Yes, the UNC path is retained when you distribute the FE to the users.
You can see that in the linked table connect string and by hovering
over a linked table name while viewing the list of tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n _ k e m p f]

in other words-- all of your objects have different connection strings

sounds like the most inefficient platform in the world to me

it's much more efficient to keep everything in ADP land
then all your databases automagically talk to each other

With Jet-- you've got to write DAO (obsolete) in order to check
connection strings on all of your object; and on a lot of your sql
passthrough queries

what a waste!

 

[a a r o n . k e m p f]

you know-- if Microsoft made the LINKED TABLE MANAGER such that it
supported changing the connection strings on Sql Passthroughs-- it
really wouldn't be that bad of a product.

Of course-- if they also fixed the whole compact / repair,
performance, and stability thing-- that might help Jet to have a
future.

Until MS starts taking Access seriously-- Jet is dead and it has been
for a decade.

-Aaron

 

[Dirk Goldgar]

message

you know-- if Microsoft made the LINKED TABLE MANAGER such that it
supported changing the connection strings on Sql Passthroughs-- it really
wouldn't be that bad of a product.

That *is* an annoyance. On the other hand, the code to relink everything
including pass-through queries is trivial. But I agree that the linked
table manager is deficient, and should have this capability added to it.

 

[Tony Toews [MVP]]

When I split the database, I'm specifying a back-end location of
\\server-name\sharename\MyDatabase_be.accdb. Does that UNC get stored in the
front-end copy so that when it gets deployed the users will be able to
connect to the back end? Thanks for any help on this.

Please ignore Aaron Kempf's postings as he is monomaniacal on the
subject of SQL Server and ADPs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/