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

P

Paulina

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
 
J

John W. Vinson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top