Here the code I use to compact and repair:
'Public Sub CompactDB()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction
' End Sub
I hope this helps
This error is usally caused by a the query in Access that you are using for the data has a user critera stated.
Example: I have a query in access that will pull the data using a date range that I am prompted for every time I run the query.
If I try to use MS Query from Excel to pull the data...
BIS,
I can't really tell you that either. I never have done DID. What I do is convert to pdf and store on a shared drive with 2 employees parsing out the faxes.
I agree with Trevoke. I was being attacked on my ssh server and since we made the change to not be pingable most of the attacks have stopped. I have gone the route in the past and reported the IP's to both my ISP and to the IP's owners. Most do not care.
BIS,
I am currently using Hylafax at 4 different locations. Great software using Fedora Core 2 with multiple Zoom external modems. When I first set up I was using USR external modems and had issues with dropped faxes. After a couple weeks of play with setting, I decided to try a driverent...
R and S are not mapped to the same share. I have other VBA code that refers to the same paths. The databases are compact every morning. I am banging my head against the wall with this issue.
This morning I ran strSQL2 first, then I ran the entire query, This time it put the data from strSQL2...
I have 3 queries from 3 different databases that I paste into 3 tables on a fourth database. In the past I was removing the data from the tables and then pasting the new data from the 3 different queries. I can not use a create table query because of links on the 3 tables.
I wrote code to do...
Thanks for the Prompt reply.
tblBHSResults has 67 records
tblBAIResults has 67 records
tblBDIResults has 50 record
When I use the suggested SQL I get 968 records returned
Here's the current SQL
SELECT *
FROM (tblBHSResults INNER JOIN tblBAIResults ON tblBHSResults.ID1 = tblBAIResults.ID1)...
I have 3 databases that have an Patient ID number that is common to all. I have been trying to join these databases together using a new database with linked tables to the main table of the exsisting 3 databases. When I try to do a join to join the patient ID numbers together, I get multiple...
I am looking for guidance on an object library issue I am having. I have both access xp and access 2003 clients loaded thru out the office. The database is a shared database on the server with many queries created.
If an Access 2003 client creates a new query and then saves the query, all of my...
Set your westell to 192.168.1.1 on the lan side. Set the Linksys to 192.168.1.2 on the wan side and set the linksys gateway to 192.168.1.1 (The westell's ip).
On the Lan side or Local ip address of the Linksys, set the IP address as 10.5.5.5. Set up DHCP or manually configure your pc's to...
Paradox,
Thank you for your reply. I will look into the Proximal and the cisco cards. You know how most companies are they try the cheapest solution first!
G0AOZ,
The FCC does not care about this band in the US unless it is affecting broadcast TV or Radio. The FCC can't even regulate 11...
We have had good luck with GPS to align the Antennas. Another option is to use a phone butt set and transmit a tone. I think the conections are pin 1 and 3 for the tone? I will see if I can find the schematic. We have used this with Cisco products.
Dave
I have a Dlink access point running WEP 64 Bit. It has been running fine up untill a month ago. The Local hospital, next door is flooding the airwaves with 8 different connections on 8 different channels (2.4 GHz using channels 3 - 11). The signals are so strong that even when I set the access...
Gentlemen,
Covad is not blocking port 135 but Level 3 their connection point provider in Dallas is!
The biggest problem is when is UUnet going to block these ports?
Dave
Also check to see if the ISP is filtering port 135. Port 135 is being used for sharing. SBC Cox and many other ISP started filtering as of noon yesterday.
Dave
Gentlemen Call your web provider. They are filtering port 135. If 135 is filter you have no access to exchange except thru pop or web access. Shared Drive will not function nor will samba.
SBC and and Cox are currently blocking the port
We have had the same issue. You can no longer share priners or drives using term services if the ISP is blocking port 135. SBC and Cox Cable started yesterday. This also stops internet access to exchange except thru pop.
Dave
We are running into issues becuase of the ISP's starting to filter port 135. If they filter 135 you no longer have access to shared drives, Exchange, Samba from the internet.
Dave
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.