Splitter) to dump all the tables out to another file and link them back to
your "code" database that has all your queries, forms, reports, etc.
Compact the "code" database after that to shrink it.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Brett Collings
Sent: Friday, May 12, 2006 5:28 AM
To: [email protected]
Subject: Re: [ms_access] Starting queries in other databases with a Macro
I'm guessing here but I don't see why not. You can just link tables
from one backend to another or from the frontend to two backends
Brett
mexx4fr wrote:
> Hi,
>
> I have some databases which I have to split up since they are becoming
> more than 2 gb.
>
> My Question is if it's possible to start a query in another database
> with a macro in the current database ?
>
> Thanks in advance
>
> Frank
>
>
>
>
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
