Split DB - FE changes

[Roaftech]

I'm developing a database for a charity which has been advised to update its
paper records. IT will be a single machine applicatiuon with maybe three
users so there's no network or web implications. I won't be around to
maintain it and sooner or later someone will foul it up so I thought I would
split it FE/BE. They can then email me the tables for repair or I can email a
new FE with revised forms etc.
However, having tried this, the changed controls on the front end won't work
properly. Existing unmodified controls work fine, but edited bits seem to be
- for want of a better word - impotent. For example, a combo will read the
table options but won't act on the selection, whereas the same code in an
unmodified copy of the form works as it should.
Replies elsewhere suggest that a modified fe can be just copied over the
original, but it seems that isn't sufficient.
A] -Is there a need to relink the modified forms to the BE tables somehow?
B] - Is there a way to copy modified forms, reports from one DB to another
without having to do it one at a time through the DB Window?

Many thanks for your assistance,

 

[Mr. B]

If the path to the backend file is not the same on the user's machine as it
is on your development machine, then you would need to relink the tables.

If the file structure, including all folders and sub folders is the same on
both machines, then you should not have to relink the tables.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Peter Hibbs]

To relink the tables in the customer database after you have sent them
a new front-end file, have a look at the BE_Relink code at :-

http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

If you want to be able to make changes to the back-end tables without
having to visit the customer, you should also have a look at the Back
End Update Utility code on the same site.

HTH

Peter Hibbs.

 

[Tony Toews [MVP]]

If you want to be able to make changes to the back-end tables without
having to visit the customer, you should also have a look at the Back
End Update Utility code on the same site.

Also see Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm
which painlessly generates the VBA DAO code for the differences
between two BE MDBs.

Tony