Need suggestion to set up development environment

[Mr. Smith]

Hi.
Not quite sure if it's the right group but I'll try.

I am redesigning an Access application for a client (from 03->07). The
application is linked to several SQL tables on a Microsoft SQL server which
stand on the clients domain.

I need to do the redesign of the application working locally on my own
computer, but then I have no access to the external data. If I bulk up the
data on a local version it works allright during the development, but I can
not copy the redesigned application into the client domain, without
relinking all tables.

I need a framwork where I can develope offline locally and redesign all the
forms/modules, and publish everything but the table part to the new client
version of the application.

If you understand my needs, is there a smoothe way to do this? What's the
"best-practise" when developing against a datasource which is not "live"
during development?

Kind regards
Mr. Smith

 

[Guest]

Yes, you need to re-link when you give the application to
the client. Most people include special code in the application
to relink, either automatically if the application is not linked,
or by a special command.

There are many examples of relink code available, have a look
around on the web - google for relink access.

(david)

 

[Mr. Smith]

Thanks David....

Yes, you need to re-link when you give the application to
the client. Most people include special code in the application
to relink, either automatically if the application is not linked,
or by a special command.

There are many examples of relink code available, have a look
around on the web - google for relink access.

(david)