Search results

Hi. Kind of newbie on the whole Access on the web sharing. I am building an application in VBS. my plan is to use a small centralized Access DB as my data repository. I need this file to be on a server which each one can connect and share. what would be my cheapest way to do this (if...

Hi. I know this question has been around for quite some time but I don't seem to find the correct syntax for my query. I have a table with 3 fields: Bucket, Vendors, Docs. I want to run a query that tells me how many unique vendors and docs are in each Bucket Bucket Vendor# Doc#...

Hi. Thanks to all that have contribute to helping on my project. Almost done! I have some issues with the navigation pane and ribbons I when to Access Options and unchecked the nav. pane and ribbons. 1. when the form loads 3 ribbon tabs exists (home, add-ins,acrobat). how can i remove...

Hi, I think problem is this is kind common but I can't seem to find an easy solutions. I have a TEXT file linked as a table (SOURCE) to my DB. I have a Query (SOURCE_WLU) that uses the TEXT file plus is linked to several others tables in the DB. i am trying to get a 5 random values out...

Hi, I have some subrutines that are time extensive. It is Ok due to the large amount of data they process. my problem is that while they are running Access says (not responding) until the code finishes. Some users think Access has crashed and tries to stop the code or restart the PC. is...

Been working with Access for a long time, but it's the first time I have seen Access bloat so much. I have a 700MB CSV file, all text columns. This file contains about 2 million rows and 30 columns. After I import the file (using the Wizard) the final size of the DB, after compact and...