I am creating a database for 70 periodic users. I will have no more than 25,000 records in the database. I have the option of setting the tables up in SQL Server on a server at a nearby, separate location. I have always created my databases with one mdb file as the data file and another mdb as the interface. I have never used ADO nor any other form of explicit connection. I have used ODBC for DB2 and other external tables. I have never created an ADP file. With those ‘givens’, I’m hoping to get some general advice on the optimal approach. I own Acc2000 Developer’s Handbook Vol2 and it provides direction but I am still hazy about what approach is favored with developers and what approach is the optimal one. I have no problem breaking out of my mdb comfort zone but I want to make sure I am making the right jump.
As always…thanks!!
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
ADP – Yea or Nay? (Access2000)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » ADP – Yea or Nay? (Access2000)
- This topic has 8 replies, 3 voices, and was last updated 23 years, 1 month ago.
AuthorTopicWSdashiell
AskWoody LoungerApril 13, 2002 at 4:07 am #369569Viewing 0 reply threadsAuthorReplies-
WScharlotte
AskWoody LoungerApril 13, 2002 at 4:43 am #582191If you aren’t comfortable with ADO, then avoid the ADP. I tend to avoid ADPs anyhow if I’m turning the database over to users. I’m just not comfortable with letting them get that close to the SQL Server back end without a LOT of protections. You can compile it into an ADE, of course, but I like the distance that an MDB offers to keep my users from shooting themselves (and me) in the foot.
There’s no reason you can’t use an ODBC connection with linked SQL Server tables and an Access mdb as a front end if that’s what you want to do. The big question is how many of those 70 “periodic” users would be in the database at any one time. With only 25,000 records in the database, there isn’t any overwhelming need to move to SQL Server unless the number of simultaneous users requires it or unless the size of the database will grow *much* larger than that in short order.
There’s also the question of who would administer the SQL Server database. Although the upsizing wizard makes it look simple, it isn’t. There are some things you simply have to do from SQL Server (like creating stored procedures, creating new SQL Server tables, changing table designs etc.), and those are not always as straightforward as they might first appear.
-
WSdashiell
AskWoody LoungerApril 16, 2002 at 3:37 am #582630Thank You Charlotte. I just want to make sure I’m not forcing an MDB to do something that would be better served by an ADP…your notes make it clear I am on the right path using an MDB. It seems like ADP’s throw a lot of extra steps itno the formula. I just wish I had a better grasp of when I should upgrade.
There will be maybe 20 simultaneous users. My client will be using the database on another client’s server. He is afraid of storing the front-end and back-end on his client’s server. Hence the reason for SQL…to keep the data remote so his client can’t take the database and squeeze him out. Someone already started work so I’ve been trying to persuade him to move everything to his client’s server. I plan on locking everything down (MDE) to alleviate his concerns. If you have any recommendations on this issue, I would apprecite reading them. Also, is there a way to lock tables down so someone can’t import them into another table? On MDE files I can still go in and import the data.
Once again…Thanks! -
WScharlotte
AskWoody LoungerApril 16, 2002 at 4:28 am #582643ADPs are wonderful tools, but if you aren’t familiar with them and with SQL Server, the learning curve can be very steep. If you’re using a SQL Server back end, security on the tables is handled through SQL Server roles, not through Access at all; and if you have 20 simultaneous users, you’d better have a SQL Server backend. I’m not sure what you mean by locking them down so someone “can’t import them into another table”, so I don’t know how to answer the question.
-
WSdashiell
AskWoody Lounger -
WSFrancois
AskWoody LoungerApril 16, 2002 at 1:43 pm #582737MDE protect your code and forms and reports design.
To protect data, you will have to use User Security.
You can use the User-Level Security Wizard to protect your mdb or mde.
Have a look at Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000
to learn how to use User Security. -
WSdashiell
AskWoody Lounger -
WScharlotte
AskWoody Lounger -
WSdashiell
AskWoody Lounger
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
43 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
1 hour, 50 minutes ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
2 hours, 2 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
2 hours, 14 minutes ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
2 hours, 19 minutes ago -
Lumma malware takedown
by
EyesOnWindows
9 hours, 33 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
11 hours, 7 minutes ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
11 hours, 1 minute ago -
Meet Gemini in Chrome
by
Alex5723
15 hours, 7 minutes ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
15 hours, 15 minutes ago -
Trump signs Take It Down Act
by
Alex5723
23 hours, 14 minutes ago -
Do you have a maintenance window?
by
Susan Bradley
10 hours, 23 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
1 hour, 26 minutes ago -
Cox Communications and Charter Communications to merge
by
not so anon
1 day, 2 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
1 day, 7 hours ago -
hibernate activation
by
e_belmont
1 day, 11 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
1 day, 15 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
1 day, 18 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
1 day, 18 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
14 hours, 27 minutes ago -
Out of band for Windows 10
by
Susan Bradley
1 day, 23 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
2 days, 6 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
2 days, 13 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
9 hours, 27 minutes ago -
Auto Time Zone Adjustment
by
wadeer
2 days, 18 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
2 days, 15 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
15 hours, 18 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
1 day, 8 hours ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
8 hours, 56 minutes ago -
Apps included with macOS
by
Will Fastie
1 day, 13 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.