Work offline with Linked tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

enigmasolution@gmail.com - 25 Jan 2008 20:15 GMT

Hello,
I have an Access application with linked tables. I am looking for a
way to run the application whithout being connected to the linked
database i.e. when I will run the Access application I will not be
connected to our company network so access will give me an error.

Can I create an 'offline' version of my access database?? I am leaving
the company where I work and I would like to be able to support them
with that application. But with no access to the live system, it will
be impossible. So If I can find a way to create an 'offline' version
of the system with a copy of the data, I will be able at least to help
them.

Thanks in advance !!

Nancy

Reply to this Message

F1stman - 25 Jan 2008 20:25 GMT

Nancy,
The big question is if you need theur current data over time. If not, just
take a copy of both the user file and the back-end, with or without all data.
That is what I have done with the firm I work for. I even make changes and
send them new .mdb from time to time. If it is more complicated someone much
more advanced will have to help.
Good Luck, Adam

> Hello,
> I have an Access application with linked tables. I am looking for a
[quoted text clipped - 12 lines]
>
> Nancy

Reply to this Message

enigmasolution@gmail.com - 29 Jan 2008 03:44 GMT

> Nancy,
> The big question is if you need theur current data over time. If not, just
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Hello Adam,
no I do not need the current data, just a copy of all data is enough.
I am not sure I understand what you recommend me ... I make a copy of
the Access Database (which include my linked server and forms and
reports). But when I will click on the table, the system will look for
the the linked table. Am I suppose to delete every table to recreate
it locally inside that new copy??? It will take a lot of time to do
that. I might not know or understanding something. Your help will be
appreciaged Adam, Looks like you had to do the exact same thing than
me.

Thanks in advance
Nancy

Reply to this Message

Pat Hartman - 25 Jan 2008 20:32 GMT

Copy the back end database if it is an .mdb and just relink your copy of the
FE to the copy for testing purposes. If the BE is SQL server, create a
backup and then install the BE on your home PC. Alternatively, import the
SQL tables into an Access .mdb. PKs and relationships do not get imported
so you will need to set these up manually and of course, if you are using
any pass-through queries or stored procedures they will not work. Just
remember, that you will never have current data with this setup. I support
my small remote users using Terminal Services (free with the pro versions of
XP and Vista) and larger companies with Citrix (this requires a special
network server which is why only large companies use the technology). With
either method, you dial into the client's network and take over a PC or
establish a virtual session on a server and you can work as if you were
local.

> Hello,
> I have an Access application with linked tables. I am looking for a
[quoted text clipped - 12 lines]
>
> Nancy

Reply to this Message