link to two mdb speed issue

G

Guest

I have a two front end databases originally linked to one large backend
(mdb.) I split the backend into two and linked to all tables in one but only
a few tables in the other. I assumed this would speed performance but it
actually slowed dramatically, even causing one of my VBA procedures to hang
and crash Access. This is Access 2003. I previously linked a front end to 3
backends in Accesss 97 with no speed problems. Any thoughts?
 
S

strive4peace

Hi Chip,

try this:

make a form whose RecordSource is any linked table. since you have 2
BE's, do this for each BE.

when you open Access, open these two forms in their hidden state


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
S

strive4peace

you're welcome, Chip ;)

another thing you can do is open a recordset (or two <smile>) with code...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

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

Similar Threads

1 front end, multiple back end mdb databases on server 5
SQL Server Backend: linked tables or no more bound forms ? 4
Split .mdb back-end 4
Ghost references to deleted tables in a back end database (Access2000 XP) 5
2 gb limit and linked tables 2
XP problem. Linking tables to more than one mdb. HELP 1
Prevent odbc connection to the backend mdb 5
Linking Data Tables 14

Top