back end database

P

Pammy

How do you remove a back end database table and put it back to the beginning
when it was created?
 
B

Beetle

Your question is a liitle unclear. Do you want to delete (remove) the table
itself from your db, or just delete all the records in the table?
 
B

Beetle

First, make backups of your FE and BE before you do any of the following.

Open the FE and go to File\Get External Data\Import. Navigate to the BE file
and click Import. Select all the tables you want imported. You will now have
both the linked tables and the local tables in your FE. The imported tables
will probably have a 1 appended to the end of the name. Delete all the linked
tables, and remove the 1 from the local table names.
 
A

a a r o n . k e m p f

you don't really need to do this.

You just got bad advice earlier.

Backend / FrontEnd-- All it does is make development harder.
If you just upsized to SQL Server, you could work on queries (stored
procedures) _WHILE_ people were working on the database.. and it
wouldn't give you _ANY_ trouble.

Question your premise-- why did you get stuck down the 'backend
deadend' earlier?

listening to Access chipmunks, when you should be aiming for the moon
instead?

-Aaron
 
T

Tony Toews [MVP]

Pammy said:
How do you remove a back end database table and put it back to the beginning
when it was created?
Click to expand...

Why are you trying to do this? Performance problems? Access
Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Please ignore Aaron. He is rather monomaniacal.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top