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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|