access database training - Portable standalone version of linked table MS Access db

Resolved · Low Priority · Version Standard

Portable standalone version of linked table MS Access db

Frances has attended:
Access Introduction course
Access Intermediate course

by - delegate Frances [8 posts] (2007 Sep 5 Wed, 08:35) Reply

Hi there,

I have created a bid ms access database which is linked to lots of tables in oracle. This is fine and dandy while in the office.

However, there is now the need to take the database offsite in order to demonstrate its worth to a client. So, what is needed is a standalone version of the database that is fully populated. We will NOT need to add new data or amend data but WILL need to use queries and print reports.

Is there an easy way to achieve this?

Thanks
Frances

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: portable standalone version of linked table MS Access db

by - trainer David gold contributer [428 posts] (2007 Sep 5 Wed, 12:53) Reply

Hi Frances.

As far as I know this is not possible. If it was just MS access that you were using, it would be fine. You may want to look at histing your access database on a web-server, then you should be able to link the two databases together. You can then create a web based interface for your access database. This will make it accessible anywhere.

Hope this helps
David