Re: SQL Code Problem
- From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 00:10:54 +1000
Close your database. Close Access. Go to the directory you store the
database and find the file (DatabaseName).LDB. If it exists, delete this
file (note: NOT the MDB file).
Open Access, open the database, delete the Table. Use the Menu View /
Refresh to make sure the Table is deleted and then run the code.
--
HTH
Van T. Dinh
MVP (Access)
"matt donker via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
message news:7d2ad2a902424dd7b7898da8370f1a69@xxxxxxxxxxxxxxxxxxxx
> This does not work as once i try to delete it it responds with an error
> saying it cannot delete the table while its open. So i wrote a close code
> before trying to delete it. Then when ran it it responding with and error
> 3211 cannot lock table because its in use by another person or process.
> Which makes no sense because this is the start up form nothing else is
open
> or using it. And the only process that uses this table is the process i
am
> trying to run.
>
> any suggestions?
>
> --
> Message posted via http://www.accessmonster.com
.
- Follow-Ups:
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: SQL Code Problem
- References:
- SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: SQL Code Problem
- From: Van T. Dinh
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- Re: SQL Code Problem
- From: Van T. Dinh
- Re: SQL Code Problem
- From: matt donker via AccessMonster.com
- SQL Code Problem
- Prev by Date: Re: CALCULATED FIELDS
- Next by Date: Re: sql problem
- Previous by thread: Re: SQL Code Problem
- Next by thread: Re: SQL Code Problem
- Index(es):
Relevant Pages
|
