RE: Links to tables are broken after I copy new frontend to clients

Tech-Archive recommends: Speed Up your PC by fixing your registry

I see this problem when the user's ODBC, or path, is different. Especially
if you are linking through a Networked drive.

Try setting your link up using My Network Places (Windows2000). This will
create the link with the true network path name. (ie.
\\ServerName\ShareName\Folder\DataDBFile)

HTH

Sharkbyte



"jsccorps" wrote:

> Have backend on server. Frontend copied to 10 clients. Worked fine until ...
>
> I copied an updated frontend to the clients. Somehow, the links to the
> backend were broken. To fix, I relinked the tables on each client to the
> backend. (Must be a better way)
>
> Is there a way to maintain the table links after I copy new frontends to the
> clients?
>
>
.

Relevant Pages

  • Re: Security not clicking
    ... I assume that DR Final06.mdb is the frontend and you have put the backend on ... I need to put this to the network. ... Go to your PC and right-click on the desktop shortcut. ...
    (microsoft.public.access.security)
  • Re: Splitting database.
    ... MyDatabase_be, like the wizard does? ... > Don't use the wizard as the backend will be unsecure. ... >> front end to each network machine and, if so, how does each copy ... > You make the changes in your copy of the frontend. ...
    (microsoft.public.access.security)
  • Re: Importing tables from one database to another - help please!
    ... You can import tables to FrontEnd2 from FrontEnd1 and then Export from FrontEnd2 to the backend. ... I have created a database and have distributed to about 50 clients but now need to issue an update to the database. ... Now that I want to issue an update I have discovered that I had left four tables in the frontend that should be in the backend and only linked from the frontend. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Links to tables are broken after I copy new frontend to clients
    ... >> Have backend on server. ... Frontend copied to 10 clients. ... > Place the Frontend on the server too. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Importing tables from one database to another - help please!
    ... This database was developed using Access 2000 developer's edition and was ... Many of my clients wouldn't ... contained a frontend and a backend. ...
    (microsoft.public.access.externaldata)