Need Your Recommendation

May 21, 2007

I just started to learn Access, especially query. May you recommend some practical free online learning website(s)? Thank you!

View Replies


ADVERTISEMENT

Multi-User Recommendation

Mar 10, 2006

I 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 Related

Connecting To Multiple Databases - Performance Recommendation Please

Nov 29, 2006

Hey 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!!

View 1 Replies View Related

Book Recommendation On Access And VBA Works With Access

Aug 25, 2004

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

View 1 Replies View Related

Recommendation For Access DB Access

Apr 3, 2007

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

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved