Moving BackEnd Database to SharePoint

[collins_jd]

Hi All
I've finished a good basic functioning ordering etc system. have split the database, created my front end user files, trying to move database to sharepoint and getting the following error (see attachments). the table and values are there.. help would be greatly appreciated

 

[theDBguy]

Perhaps the order of migration is somehow off. Try doing it manually. Otherwise, if there's an error message, something is not right. However, the error message may be misleading.

 

[GPGeorge]

That's exactly the kind of error you can get. As we've said, SharePoint creates its own PK IDs. That lookup table shows four IDs and I'll bet your Lookup field for TendorTypeID in the other table has at least one record with a value other than one of those four because that was what you used in the original Access table.

 

[collins_jd]

Thanks so much! @Pat Hartman and @GPGeorge. You were correct and I was able to fix. I seemingly have only 1 issue now and that is that with the front end I was about to disperse to staff. Certain forms require a password to open but when i convert that front file from accdb to accde, the accde file doesnt ask for the password?

 

[GPGeorge]

Thanks so much! @Pat Hartman and @GPGeorge. You were correct and I was able to fix. I seemingly have only 1 issue now and that is that with the front end I was about to disperse to staff. Certain forms require a password to open but when i convert that front file from accdb to accde, the accde file doesnt ask for the password?

That's hard to diagnose in a vacuum.

 

[collins_jd]

We don't know anything about your security code so I'm not sure what to say. Did you secure the VBA code module? Compiling to an .accde would get rid of that because it removes the source code. But this isn't the way to secure a form so I can't envision how it was working before.

If you have tables and codes you used, you will need to post the tables and codes for us to look at.

@Pat Hartman I entered the code into the form property events before saving as accde..... Event on Open. the tables are product cost table and sf points to VendorXProductT table which pulls vendor info from vendorT and Product cost info from productcostT