Search results

Nice and simple. Thanks Wazz!

Is there a way to remove the Form navigation buttons at the bottom left corner when the Form window opens up?

I'm still grappling with ldb file and it's need for users to have FULL permissions to the folder where it resides. It seems to me that you can lock down the database using Access Security, but because users require full permissions to the folder where the db resides so the ldb file can work...

I will check with the network folks to confirm the delete permission. The default record locking is set to Edited Record.

Thanks Rabbie. I was under the impression that Modify access allowed them to delete, make changes, or rename the file.

I’ve made several changes to my database based on suggestions from this Forum. As someone just getting their feet wet with Access, you guys are an invaluable resource. The experience and knowledge displayed in reading these different threads is impressive. But more importantly, the...

I've found some places on this forum to start my research on this. Thanks for your help, Len!

Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database? Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database? Thanks! Michael

Thinking about this a little more..... So, if a user creates a bunch of queries within his MDE and the DB administrator decides to...let's say...change the color of a form. He creates a new MDE and distributes that form change via the new MDE to all the users. The new MDE each user receives...

Thanks Rabbie...Thanks Paul... I sort of figured I'd have to do that. And yes, I have made use of Bob's utility, so distribution won't be an issue. Thanks again for your help!

I have split my database and have the BE on a network server. Users were each given a copy of the MDE file to enter data from using a Form. When I bring up my copy of the MDE and create a query or edit an existing one and give it a new name... only I can see this new query. Is this the way...

Thanks Bob. That seems simple enough. I'm not sure how savvy these users are, but what's to prevent them from going to the Table and editing the record from the Table itself?

I'm not sure if this is a Table question or a Form question... After a user enters data into all the fields on my form (ticket #, date, time, etc) and submits that form, I want to prevent them from going back to that record (or any record, for that matter) and make a change to it. Currently...

Thanks Doc. Where do I find the Form's update mode?

I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so...

Bob, Thanks for your help. Your instructions worked perfectly!

OK, I deleted the links and reestablished them using the UNC path. Do I now have to create a new MDE file and distribute that to my users?

Sorry Bob, I looked at the Help file, and it says I'd just be deleting the link. I get worried when I see the word Delete!

Pardon my ignorance, but if I do as you say, wouldn't that be deleting each table? And don't those tables contain all my data?

I'm sorry Bob, but how do you delete the current linked tables or can I just follow your steps?