(Rookie Access user) When I try to create a ACCDE from my database, I get an error that says Microsoft Access cannot create the file.
Reading through the forums, it appears that the most common problem is with bad VBA code.
I have no self written VBA code. Everything I have is done by the built in wizards.
I suspect that I may have a link somewhere to a table or query on a form or report that did not get updated when I made some change in the past. Will that cause that error? And is there any way to help locate the offending link/form/report? All of my forms and reports appear to be working. They open and display the expected information just fine just fine.
Does it matter if I create the ACCDE before or after I split the database? And does the save location matter? I am working with a copy of the database on my machine. I will split and ACCDE the actual database once I get the bugs figured out.
Thanks
Reading through the forums, it appears that the most common problem is with bad VBA code.
I have no self written VBA code. Everything I have is done by the built in wizards.
I suspect that I may have a link somewhere to a table or query on a form or report that did not get updated when I made some change in the past. Will that cause that error? And is there any way to help locate the offending link/form/report? All of my forms and reports appear to be working. They open and display the expected information just fine just fine.
Does it matter if I create the ACCDE before or after I split the database? And does the save location matter? I am working with a copy of the database on my machine. I will split and ACCDE the actual database once I get the bugs figured out.
Thanks