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.

 

[Pat Hartman]

Did you check the data? Use a find unmatched query.

Make sure that you have established RI on ALL relationships. If you don't, the upload will orphan records as SharePoint assigns NEW autonumbers. @GPGeorge has written several articles on the subject that you might want to read.

 

[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?

 

[Pat Hartman]

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.

 

[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

 

[Pat Hartman]

1. ALWAYS Use Option Explicit in your procedure headers. You MUST add this manually as the second line in ALL existing modules. You can have Access handle this going forward by checking the option to declare all variables.
2. Are you not getting the prompt when you open the form? Or is the code not working once you select an option?
3. And finally, checking for "Not" is always risky if there is the possibility of the value being null. Better to make the positive text of = "xxxxx". If you had posted your code as a string, I would have fixed it. Please do not post "pictures" of code. Copy the code from the module and paste it using the code tool so the alignment remains. That makes it much easier for us to help you with trivial syntax.