Importing table

  • Thread starter Thread starter ram
  • Start date Start date
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
 
" ... 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
 
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
Click to expand...
 
Back
Top