Move report to another PC with Access?

[Susan]

I created a report now how would you copy the file which creates a report to
another machine?

 

[Jeff Boyce]

Susan

Access does not keep separate "files" for each object. Instead, everything
is stored within the .mdb file.

So you might not actually want to copy (only) the report to another PC (and
you couldn't!) ... do you need to run the application from more than one PC?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Susan]

What I did was create database on a website and then with the ODBC option, I
can create an Access file. I then created a report. But there are others
in the organization that would like to create the report. I was wondering
how I could get the necessary information on their pcs? I do not want to
have to individually set up the report again. What do I need to do?

Thank you very much for information.
Susan

 

[Larry Linson]

Interesting. I don't understand what you mean by "create a database on a
website and then with the ODBC option, I can create an Access file". As far
as I know, you cannot use ODBC from Access to access another Access
database -- was this a server DB you created, and are you using it,
in-place, via ODBC?

In any case, if the other users can access the database in a similar manner,
and have Access and ODBC installed, you could copy and send to them the
database containing the report. They will, likely, have to delete the table
and re-access it via ODBC. Or, if you want them to have the report but not
the rest of the database application, create a new Access database and use
Get External Data to import the Report and any necessary "structure" (like
Forms to enter parameters, and such) and give them that abbreviated
database.

Larry Linson
Microsoft Access MVP

 

[Susan]

Interesting. I don't understand what you mean by "create a database on a
website and then with the ODBC option, I can create an Access file". As far
as I know, you cannot use ODBC from Access to access another Access
database -- was this a server DB you created, and are you using it,
in-place, via ODBC?

On the website, I used MySql, PHP, and HTML to create a form which person
can fill out and the information is posted to a database (MySQL). Then with
the ODBC the information can be imported and an Access file is created.
----------------------------------------------------------------------------------------------
How to access the CPF database from the website.

The data base on website is created using MySQL which is an free, open
source database application. Microsoft Access can connect to it using the
OBDC feature.

To connect to the database, you need to have MS Access installed on your
computer. MS Access is an application that is part of MS Office.

You need to download and install the MySQL Connector from the following:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

You will probably need to use the Windows and not the Windows64 (unless you
have the newest Windows Vista that uses 64 bit technology).

For Setup Type:

Select the Typical

Please ensure that a DSN mapping for the database has been set up correctly.
To do this on Windows 2000, instructions are given and the user is also
given the database host, server, password, etc.

---------------------------------------------------------------

But anyway, it works very nicely. I have the report set up and can save it
as PDF and email it but it would be nice for others to be able to obtain
report on their own and not be totally dependent upon me!

So the database mdb file contains the table, report and everything? When
you create a report or more than one report for one database, it is all
contained in that mdb file?

-----------------------------------------------------------------

 

[Larry Linson]

So the database mdb file contains the table, report
and everything? When you create a report or more
than one report for one database, it is all
contained in that mdb file?

Yes, the .mdb can contain tables, queries, forms, reports, macros, modules
(and relationships).

In your case, the table linked to the MySQL table on the server is only
"structure" to connect it -- the data resides on the server. So you can
give the users a copy of your database, they can relink the ODBC (MySQL)
tables; or you can cut the database down to the functions you want them to
have and give them that.

Larry Linson
Microsoft Access MVP