I have a small VB program that displays a form,users enter the data and it stores the data in an ACCESS db. What I would like to do is to put this program either on the server or on INTRANET so users can access and fill out the form. I do not want to INSTALL the VB program on every user's PC...
I have a database on a remote computer and I am able to LINK my ACCESS db using ODBC to this remote db. I would like to import these tables instead of LINKing, I know how to import via FILE/Get External Data\Import. I have a VB procedure to loop through the table and write out to my ACCESS db...
While I was importing a table using DSL/VPN ODBC I lost the connections. Now I am at work (I did this remotly from home) and each time I try to open the ACCESS DB I get this error message: "MICROSFOT JET DATABASE ENGINE STOPPED THE PROCESS BECASUE YOU AND ANOTHER USER ARE ATTEMPTING TO...
I would like to be able to capture user ID and then use it in a select query (ACCESS) to filter data for just that user? i.e. select all records from a table for sales agent John. This application has many users retrieving data at the same time.
I have 3 modules in an Access DB all 3 open Excel workbook and either write to it ot read from it. Two of these modules open/read the same excel workbook. I use MSscheduler to start Access DB. After one module is finish I close and quit workbook, but if I check TASK MANAGER I see EXCEL is...
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.