HELP!! With reports...

[Chay]

I have a 3 user db. The problem is I created a report which is manipulated by
vba code to serve me as many reports in one. Problem is when 1 user is
connected he can use the reports like they were designed for, but when 2 or
more log in they see not what they asked. I need to find out how to create a
new instance of the report and open it with code so that everyone can use the
report. Tried DoCmd.OpenForm with the name of the new instance but it doesn't
work!!! HELP!!!!!

 

[JamesDeckert]

The "normal" way for a networked database to be configured is for each
computer to have its own copy of the forms/reports/queries/code (the front
end) and for the data (the back end) to be on the shared computer. This
allows each user his own copy of the report.

If there is another way, you'll have to wait for another response as I don't
know.

James

 

[Chay]

Thank you for your quick response JamesDeckert!! And.. How could I make the
front-end part which I need? Thanks, Chay

 

[JamesDeckert]

Back up everything first.

Then, (if I remember right) you'll make a copy of your mdb file.
From one of the .mdb's you'll delete everything but the tables.
From the other you'll delete all the tables (unless there are any tables
which should be computer specific). The tables are the back end. The
forms/reports/modules are the front end. You'll then need to create a link
File>Get External Data>Link Tables to create a link from the front end to
each table on the back end. This back end would be on a shared drive across
the internet. Each computer using the application would have the front end.
Thus if the shared drive does not have the same path (including drive letter)
then the front end will need to be linked individually.

The following book has a programmatic procedure to accomplish the previous
process.
Access 2002 Enterprise Developer's Handbook
' by Litwin, Getz, and Gunderloy. (Sybex)

HTH,
James Deckert