Mark,
You can create an empty database file in Access. The use link tables
under the FILE > GET EXTERNAL DATA > LINK TABLES menu option to link the
blank database with your database in question. Then select whatever
tables you need to be linked.
Next in your CFAdmin point the ODBC Connection to the blank Access
table. This will be a bit slower than directly accessing your database
but it allows you to change tables etc, without having to worry about
..ldb files etc.
That would work if you can get access to the database.
The only other way would be to break the database connection. One was is
to use the undocumented CFUSION_DBCONNECTIONS_FLUSH() function but that
hoses all database connections on the server. Alternatively run a bogus
query on the database, as in
<CFQUERY DATASOURCE="#request.dsn#" DBTYPE="ODBC" NAME="Whatever">
select garbage from BS
</CFQUERY>
that should break the connection.
hth,
larry
--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work here is done.
--
Mark Smeets wrote:
>
> So, here is my question and basically it's a problem.
>
> Now when you open any Access file you get that little annoying ldb file with
> it, it closes no problem if you're working with Access directly however what
> if the Access file is on a server and you don't have access to it directly?
>
> What if I need to replace that database with a new one (and that stupid ldb
> file won't go away)?
>
> Any ideas would greatly help.
>
> Mark Smeets/stranger0/ICQ #1062196
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
