back end database

[Pammy]

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

 

[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?

 

[Pammy]

I want to keep the tables, just remove the link of the back end.

 

[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 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

 

[Tony Toews [MVP]]

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

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/