Importing table

R

ram

I have a split database; the backend is located on a server in our home
office, the front end is stored on 40 users’ local computers. When the users
try to run queries it takes a long time or times out because of the amount of
data and the linked tables. I now have unlinked the tables and use the
following process.

I created an AutoExc macro that does the following:

It first deletes tableA, tableB, tableC
Than it imports tableA, tableB, tableC from the backend database.

Now all the data is stored on the local drive which makes all the forms
queries and macro in the front end run quickly. The users are complaining
that it takes to long for the database to initially open because of the
deleting and importing of the table.

Is there a way to eliminate the step of deleting the tables?

I would like to import the tables and have them replace the current tables,
however when I import the tables without deleting the originals the table
names include a 1 at the end.


Thanks in advance for any help
 
J

Jeff Boyce

" ... in our home office ..." makes me wonder, are you trying to do this
over a LAN or over a WAN?

The Wide Area Network connection causes considerable problems, and generally
is not recommended for an Access FE/BE split.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

ram

WAN

Thanks

Jeff Boyce said:
" ... in our home office ..." makes me wonder, are you trying to do this
over a LAN or over a WAN?

The Wide Area Network connection causes considerable problems, and generally
is not recommended for an Access FE/BE split.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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