I have a huge database of photographs with related info. in a table. Now it is expected to grow beyond 1 GB. I'm not able to extract the photograps from the table into normal picture files so that the database size can be reduced. Can anybody help ? If sombody has written code in VB / Access to...
I have a large ACCESS-97 database table of scanned photograps ( as OLE Field) and their names. All the photograps are embedded in the database field, resulting in a very slow response time.
Now I want all these photograps back as disk files to store them as linked files.
Can any one help ...
Hi
A new Idea came to my mind. Since U'r facing problems with Null in Paul's case, instead of using IsNull try using NZ function.
NZ is a function using which U can assign a default value to your expression in case it evaluates to null. I hope this will solve the problem.
best of luck.
Hi
U can use the Scripting object in VB to do the file handling as well as opening them to read line by line.
The Scripting object supports all types of file handling methods. U can go through the documentation about the Scripting object in MSDN and find out a solution to your self.
You can do the following
1. Cange the combobox property - Limit to listed vales = False
2. in the query criterian use the 'Like' operator.
3. Type '*' in the combo box to print the report for all employees. U can even use a wield card combination to select a group of employees also.
I had created an encrypted database in Access-97. This database has a utility in it to import data from large text files of ~ 60 MB in the database. Initially database is not populated.
The constraint is that large text files and CD-WRITER is on a standalone machine. On this machine Access-2000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.