Passthrough ...maybe?!

[frustratedwthis]

I am not sure what I will need to do, but here is my dilemma.
I have a HUGE Database that pulls information from a PeopleSoft Server. The
original database is kept on a network drive, however, a copy is placed on
each employees desktop. The problem is, the database is so big that it runs
extremely slow, even locking up alot of the time. How do I get this database
to run from a Server rather than the actual database?

Hope this makes sense and tyvm in advance

 

[Dennis]

Just create a front-end with LINKED TABLES to the server-side database. Then
distribute that front-end.

BUT - if it's really huge, you need to set it up as a SQL database (or
Oracle if that's what your company uses). Note that Access has a TWO GIGABYTE
size limitation. Once that limit is exceeded, your application will crash,
and ususally in a way that's irrecoverable.

FYI

 

[Lance]

You're on the right track. Passthrough queries are MUCH faster than running
queries from linked tables, because they're run on the server instead of the
client machine.