Need Your Recommendation
May 21, 2007I just started to learn Access, especially query. May you recommend some practical free online learning website(s)? Thank you!
View RepliesI just started to learn Access, especially query. May you recommend some practical free online learning website(s)? Thank you!
View RepliesI maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method for making this database accessible to several users at once? My main concerns are accuracy (changes commiting in the proper order) and low chance of corruption.
View 1 Replies View RelatedHey Access people...
Does anyone know if it is better as a general rule (server performance wise anyway) to connect to a single database with many tables or multiple databases with fewer tables??
In this case I have a small calendar database and large navigation/metadata database -- both are MS Access & connected to the same ASP page.
Can anybody make a recommendation here??
Many Thanks!!
Can anyone recommend two good books which it should include the knowledge from Beginner to Advance level.
1. Microsoft Access
2. VBA to work with Access
Server OS is Windows Server 2003.
IIS version 6.0
Access version - Access 2002
We have an old CAD drawing list Access database with 54,000+ drawing descriptions in one table, with one search form and one result form. The engineers use it to keyword search the descriptions to find the CAD drawing number, then go to the drawing cabinet to pull the drawing, which may not be the one they wanted. I was asked to make their life easier, since they have a lot of the drawings in .TIFF format that can be loaded to this server. My first choice, which works for me as an administrator, was to add a button on the results form that would extract and build the file name for the .TIFF file, then use the following code to open the drawing file so they could look at it to see if it had what they wanted.
strFileName = "http://webservername/Engineering/CADdrawings/sect" & strFolder & "/" & strSection & "d_" & strNumber & ".tif"
stAppName = "C:Program FilesInternet Exploreriexplore.exe"
Call Shell(stAppName & " " & strFileName, 1)
This works okay for me, but not for the engineers who would be IUSR_servername logins, or Browsers, I think. As I've read over the last several days this is not a good way to do it, but I have had no luck using the .asp option mostly due to the new security "enhancements" on Windows 2003 and IIS 6.0, which I know little about. I can't get around the 800a1eba error when the page tries to open the database.
If the direct Internet Explorer option is not the best way, is the .asp option the way to go or is there another way that I haven't stumbled on yet? We don't have an SQL server I can bum space off of, so I am limited to this web server for any options that are open. I just need to be pointed to the proper option for this application.
Thanks,
Greg