Software

Ask something
Question Locked

Access 2003 Entering Data in Forms

0 helpful
4 replies

by jacob.mcleod

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I created a form with a subform comprised of data from several linked tables in several other access databases (there is too much information being managed for one or two databases with the 2 gig limit) . The neither the form or subform will not allow new entries, even though the AllowAdditions, AllowEdits, and AllowDeletions properties are all set to "Yes." Even the toolbar commands for add or deleting entries are not selectable. How do I get this form to allow new entries?

4 replies

by tony hopkinson

you are logged on as?
Also if you are using joins to put up the data, this may mean they can't be edited, all depends that one.

PS, why don't you use SQL Server and then just write the front end in access, it's going to run like an absolute dog with that much data.

by jacob.mcleod

I thought about that earlier but didn't want to wade through the process of getting the network permissions. How difficult would it be to move all the data I have so far into an SQL server? (once said permissions are obtained)

by tony hopkinson

the built in tools will take about a minute to fill in the dialogs.
MSDE or express you don't get as much support, but if you have a full copy somewhere, use the tools on that, back it up and restore it it your system.

This discussion is closed to new replies.