Access question

[Guest]

My company recently took over the management of a website from CompanyA and
part of the process involves an access database. Supporting Access has never
been a big part of my job so I have a basic question.

The process involves taking offline an online database and synchronizing it
with a local copy then putting the live db back online. I need to locate and
update all file path names from the offline database to a downloaded online
database so that the paths point to the new location of the db on one of my
servers. This includes tables, queries and forms.
How do I locate all link/dependencies, etc for any and all tables queries,
and forms in an Access db.
Thanks

 

[Larry Linson]

I'm not sure you understand how Access databases are constructed -- the
various objects are inside the database file, not separate files. Or, maybe
I didn't understand your question.

"Synchronize", in the Access world, usually refers to replication or
replicated databases. Just be aware that replication is not a novice-level
subject, and that it is "not for the faint of heart". My recollection is
that there are good articles on replication at http://www.trigeminal.com,
the site of Michael Kaplan, who was formerly a Microsoft MVP. IMNSHO, he
knows as much about Access and SQL Server replication as anyone. Don't
expect free consulting from him, though.

On the other hand, you may be using synchronization in a more general
manner, so it might not apply to replication.

Larry Linson
Microsoft Access MVP

 

[Douglas J. Steele]

A lot depends on how the database was constructed. Usually, you have a
front-end (containing the queries, forms, reports, macros and modules)
linked to a back-end (containing the tables). The front-end will have linked
tables: pointers to the actual tables in the back-end. All you should have
to do is change the linkage of your front-end to point to the new database.
You can do this using the Linked Table Manager, or you can use code similar
to http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[aaron.kempf]

you loop through the DAO collections like DAO.tableDef, DAO.querydef
and then you run

Docmd.TransferDatabase acLink I believe-- it's something along those
lines.. it's simple VB/VBA.. the most popular language in the world