acNewRecord error

[hockeylvr]

I have split my db with the back end on our network server and have installed the front end copies to everyone's machines. I have one user so far that it will not work for. There are no missing references and all of the ones needed seem to be checked. My form has a tab control with 4 subforms. The main form has a drop down for the user to select their name, then the subform populates with their data. I currently have in the Form_Load event
DoCmd.GoToRecord,,acNewRecord.

When trying to open the db on this users system, the form flashes for a second then it's just a blank access screen. If I go through the db window (Shift F11) and open the main form, I get the error "Cannot go to specified record" and the VBA screen has the acNewRecord line hightlighted.

This is an Access 2000 db running mostly on 2003 now.

I would appreciate any help in figuring one out.

Toni

 

[Melagan]

Check to make sure the user has write access on the folder in which your back-end resides. Also, if you've implemented Access's user level security, make sure this user has appropriate priviliges. Additionally, if you have user-level security implemented, have the user try running the DB on another known working machine, that way you'll know if it's the user's computer or the user's account.


~Melagan
______
"It's never too late to become what you might have been.

 

[hockeylvr]

I did get him write access to it yesterday and I don't have security on this db. It's got to have something to do with permission and perhapps IT really didn't give it to him as I requested.

Thanks for the help and I'll start investigating!

Toni

 

[Melagan]

It makes sense -- he can open the database, look at queries, but can not do anything that would "change" the database, i.e. adding new records or editing existing records. It has to be read/write permissions on the network.

~Melagan
______
"It's never too late to become what you might have been.

 

[hockeylvr]

So even if he did not have "write" permissions to the drive, he would still be able to create the .ldb file when I open the db with Shift-F11?

Toni