Best method....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at creating a database whereby we can load a series of reports
which are then emailed to managers to self-certify, who then enter comments,
tick boxes etc and I want to be able to reincorporate this data into our
database again.

How is the best way to achieve this? Would I be better off using linked
tables or can I use importing/exporting data? Will data over-write itself
where necessary? I have already tried exporting but I keep gettin errors when
I re-import it.
 
best method = Access Data Projects

linked tables are obsolete and unmanageable and unpredictable
 
I use linked tables all the time, and although they may be a little slower
than local tables, they tend to work fine. You may end up with a bit of
slowness, but Access projects require SQL Server which most people do not
have.

It is more difficult to try to incorporate 2 local copies of a database than
to use linked tables, so I would suggest starting with that over importing
and exporting the data many times. If it is too slow, then you can think
about what would change in the database and how to make it work best together.

Please let me know if I can provide more assistance.
 
FILE, NEW, PROJECT (Existing Data)

They're a much much much simpler architecture for building Access
applications

for example; in MDB it takes about a dozen lines of code to call a sproc
with arguments-- even then, the recordset is not updateable

in ADP it's a lot easier
I'd reccomed finding some books.. MS Press just came out with an ADP book a
couple of years back
 
Back
Top