A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Open existing database - 1 Front-end & 2 Back-end databases



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2009, 04:59 AM posted to microsoft.public.access.gettingstarted
Paulina
external usenet poster
 
Posts: 4
Default Open existing database - 1 Front-end & 2 Back-end databases

How do I open an existing database (Access 2003 on CD) in Access 2007 that
has one Front-end & 2 Back-end databases? I saw how to connect a Front-end
database to one Back-end database... but not 2 Back-end databases. (I've
removed "read-only" from all files.) Also, existing database has 10 sample
reports & 6 sample documents (all pdf files) - do I import these into Access
2007 or... ? Any help would be greatly appreciated - thank you so much!!
Paulina
  #2  
Old February 16th, 2009, 07:10 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Open existing database - 1 Front-end & 2 Back-end databases

On Sun, 15 Feb 2009 20:59:01 -0800, Paulina
wrote:

How do I open an existing database (Access 2003 on CD) in Access 2007 that
has one Front-end & 2 Back-end databases? I saw how to connect a Front-end
database to one Back-end database... but not 2 Back-end databases. (I've
removed "read-only" from all files.)


The Linked Table Manager can relink multiple backends, but if you're changing
versions I'd really suggest deleting all the table links and using Get
External Data... Link to create new, clean links. Do so twice, once to each
backend.

Also, existing database has 10 sample
reports & 6 sample documents (all pdf files) - do I import these into Access
2007 or... ? Any help would be greatly appreciated - thank you so much!!
Paulina


An Access Report is an object in an Access database which can print output (to
a printer or to a file, even a .pdf file); but an Access report is NOT itself
a pdf file, nor does an Access database contain documents, unless you've
imported them into an OLE object (which would bloat the database badly if you
did). Not sure what you're saying here!
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.