Split database loses information

[Tal]

I have encountered a strange and bizarre phenomenon whereby I have added a
form and several queries, including append and update queries and changed one
existing query in a database and split it.
It works fine until I try and re-link the tables to my existing networked
database. At this point a bunch of the fields in the queries turn into
expressions and I get a whole wad of runtime errors.
I would hate to have to repair the queries every time I want to issue a new
build.
Has anyone encountered this before?
Any advice, information or best guesses are much appreciated.

Tal.

 

[Clifford Bass]

Hi Tal,

Usually the turning of columns into expressions in a query is the
result of missing columns in the source tables. Basic questions: Did you
rename any fields in your local copy that did not get renamed in the network
copy? Or did you add some fields to the local copy that have not yet been
added to the network copy?

Clifford Bass

 

[a a r o n . k e m p f]

MS Access (Jet) requently loses data.

If you care enough to build a database, do it right-- use SQL Server.

-Aaron

 

[Clifford Bass]

Hi Aaron,

SQL Server as the answer to all database problems is not a constructive
way to help those in need. It bothers me that you are "attacking" people due
to their use of Access. Access is a very good product and IS THE answer, or
at least a very good answer for a lot of the tasks that people do. And there
also are a lot of tasks for which Access is not the answer. In my opinion
SQL Server is actually a clunkly designed system when it comes to database
security and some other administrate tasks; and as such it is not the answer
to most of what I do that requires a true client-server back-end. So, please
stop your attacks. All it does is reflect badly on you.

Clifford Bass

 

[Tom Wickerath]

Disable Name Autocorrect (Name Autocorrupt), if you have not already done so.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tal]

Hi everyone,
Thank you for your suggestions. I will try them all. I am pretty sure that I
added the 2 fields to the main database that I had added to the working copy,
but I will double-check.

Aaron, SQL Server is not a viable option for my organization. We are a small
charity and we don't have money to spend on either software or development,
which is why I am building this myself and learning as I go.

So far, it is going well. My database does things I never thought I could
manage, which is why this kind of unpredictability has me so flummoxed.

Tal

 

[Tal]

I have checked off the name autocorrect and double-checked that my table
structure is the same, but I am still getting same errors.
Any other thoughts?
Tal

 

[Clifford Bass]

Hi Tal,

Not that I particularly think it will help, but does your version of
Office have the latest service pack applied along with any other patches?
How about your version of Windows?

If that does not help, and you have tried the compact and repair on
both (make backups first just to be paranoid); there could be corruption that
that does not fix; you might try this with each database: Create a new
database and import all of the objects from one of the databases. Recompile
any code you have.

Clifford Bass