Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Which is better .mdb or .adp?
An ADP file is a wonderful thing. If you are working on a small system, however (1-5 people) go with mdb. ADP means getting a registered version of SQL Server ($$$). Still, if you are working on a slow network and the system may be used by 10+ people, you still may want an ADP. (if you are...- morrisdev
- Post #3
- Forum: Microsoft: Access Other topics
-
Web based relational Db
Access 2k and asp....love it. moves up to SQL Server in a snap. -if you are used to perl, then try php. If you are used to VB, then use asp both can connect to access 2k via ODBC. -Dan- morrisdev
- Post #5
- Forum: Microsoft: Access Other topics
-
Need advise in designing a table
it depends on how much is being appended. Even large SQL Server Apps like CommerceOne use stageing tables and then execute the update when processer time is available and the number of users is low. Remember...you will still have to remove those existing records before the append. If the...- morrisdev
- Post #3
- Forum: Microsoft: Access Other topics
-
Problem with Replicated database and other....
lameid is correct with his first option. if you have a client/server system, never replicate the frontend. every time I have had to use (yuck) access replication, I have had issues with front end replication. With backend replication (and proper design) I have had no real problems, even doing...- morrisdev
- Post #3
- Forum: Microsoft: Access Other topics
-
Need to add new fields to Access Backend and update front-end forms
normally the updates must be seen on a main screen that isn't edited, kind of like a status screen where one would watch inventory or shipments coming in and out. I've made many apps like this that use a timer system. Each form has a timer event at the bottom of the events listed in the...- morrisdev
- Post #3
- Forum: Microsoft: Access Other topics
-
I need a Module that auto completes city and state by entering the zip
I use a table of all Zipcodes, Cities and States. I just run a lookup on the Zipcode table upon exit of the field. If you want the table, email me and I'll send it to you. -dan morris mailto:dmorris@morrisdev.com- morrisdev
- Post #8
- Forum: Microsoft: Access Other topics
-
Performance issues -- one .mdb or a several smaller ones?
Rich, with only 4 users, I doubt that you will have any need for more than one DB. Access has many limitations, but it can be designed to handle many users. In a case like yours, where the users are filling out their own reports and others are not modifying them, the risk of corruption is...- morrisdev
- Post #2
- Forum: Microsoft: Access Other topics
-
Howto hide the URL on the bottom from a printed page?
Did you guys ever find a solution? I have the same problem. Its for an internal purchase-order database and the client doesn't want his customers to see the internal site url on the printout of the invoice. There HAS to be a way!- morrisdev
- Post #13
- Forum: Javascript
