473,387 Members | 1,456 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Variables in CompactDatabase command

Dear reader,

By using the CompactDatabase command I discovered the following unpleasant
situation:

DBEngin.CompactDatabase "DB_a", "DB_b"

The above sentence works perfect, but if I will use the command with
variables from a table it fails, for instance:

DBEnging.ComandDatabase Rst1!DB_old , Rst1!DB_new

The same negative result is by using this commend with string variables as:

Dim DB_a as String

Dim DB_b as String

Dim Rst1 as DAO.Recordset

Set Rst1 = db.OpenRecordset("Tbl_Databases")

DB_a = Rst1!DB_old (fieldname from the table)

DB_b = Rst1!DB_new

DBEnging.ComandDatabase DB_a , DB_b

This instruction set is also not working.

Tanks for any help to solve this situation

Kind regards,

Simon van Beek
Nov 13 '05 #1
0 1115

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Richards Noah \(IFR LIT MET\) | last post by:
I'm trying to test some cgi php, but do not have access to a webserver (in any way, shape, or form). I've been trying to fudge testing by using the CLI php.exe in the windows distribution. I've...
1
by: Christopher Brandsdal | last post by:
Hi! I found a database tool-script that has a functin for compacting the database.... What is the point of compacting the database? Is it necessary? Anyone know the advantages of doing this??? ...
12
by: Rhino | last post by:
I am having an odd problem: the sqlj command on my system doesn't work. I am running DB2 (LUW) V8 (FP8) on WinXP. I haven't done an sqlj program since Version 6 of DB2 (LUW) so I checked the...
8
by: Owen Jenkins | last post by:
Hello. For years I've been using the DBEngine.CompactDatabase code to make backups of backend databases. But now I've struck a baffling problem where I get an Invalid Argument error. This...
1
by: S. van Beek | last post by:
Dear reader, By using the CompactDatabase command I discovered the following unpleasant situation: DBEngin.CompactDatabase "DB_a", "DB_b" The above sentence works perfect, but if I will use...
1
by: Infiliset | last post by:
Hi all! I'm trying to test some php script using the command line php.exe. Is there any way to pass the $_POST variables? I know how to pass the $_GET variables, but I don't know how to do this for...
3
by: pburling | last post by:
I have been reading the posts regarding the CompactDatabase method and would like to say Thanks to everyone, especially Mr.Steele. I have taken his advice and make a backup from the Backend before...
10
by: jimmy | last post by:
Hi again, sorry for posting two questions so close together but im working on a school project which is due in soon and running into some difficulties implementing the database parts. I have the...
5
by: Owen Jenkins | last post by:
I have Access 97, 2000 and 2003 all running on a Win XP box after having just reinstalled XP. Among other problems, I find that Access 97 will not compact a database in code ... ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.