loosing records

R

ricardo

everytime i close or open my access database, i got a lost records, i don't
know why , is it a network problem, linked table problem,let someone help me
please
 
A

a a r o n . k e m p f

Access randomly loses records.

Don't be a newbie, stuck making $12/hour
Move to SQL Server.

-Aaron
 
P

pietlinden

Access randomly loses records.

Don't be a newbie, stuck making $12/hour
Move to SQL Server.

-Aaron
Click to expand...

Aaron,

got any good reference books on moving from Access to SQL Server? I
think I'm going to need a few of those soon...

thanks,
Pieter
 
J

Jerry Whittle

Are you getting any database corruption error messages when starting up that
database?

Are you looking at table level for the missing records?

If looking though a form, is there more than one table envolved in the query
for that form?

Are you adding the records through a form or into a table?
 
A

a a r o n . k e m p f

Jerry;

Maybe if you used a grown-ups database.. then you wouldn't have to
make your clients choose between light cheap and strong.

go play with your baby sized databases in another decade. like the
90s.

-Aaron
 
B

BruceM

You can't follow that light, cheap, strong thing, can you? Light and strong
can't be done cheaply. Light and cheap can't be done with maximum strength,
and so forth. Nothing, not even your beloved SQL Server, is the best of all
worlds in every situation. Your arguments might have some credibility if
you acknowledged limitations to SQL server, but I am not alone in being
suspicious of claims to superiority in every aspect in every situation.

message

Jerry;

Maybe if you used a grown-ups database.. then you wouldn't have to
make your clients choose between light cheap and strong.

go play with your baby sized databases in another decade. like the
90s.

-Aaron
 
A

a a r o n . k e m p f

bullshit!!!

SQL Server let's you build light cheap _AND_ strong.

Maybe you should lose the training wheels and learn SQL Server!!!

-Aaron
 
A

a a r o n . k e m p f

limitations of SQL Server?

Are you fucking kidding me?

Seriously what are these so called 'limitations' in SQL Server?

SQL Server Express runs 10000000 times better on a quad core machine
than MS Access on any machine anywhere.
Now was that a limitation?

Is running better, and being free a limitation?

-Aaron
 
A

a a r o n . k e m p f

be suspicious for all I care.

But don't think that I'm wrong just because I have a single answer to
every problem.
Just because all the old retards around here resort to mafia
violence-- does that make me wrong?

www.microsoft.com/sql it's faster, easier, better, simpler-- in every
regard.

Just keep all your tables and queries where they belong- on a single
server- and things just 'automagically link together'.

-Aaron
 
B

BruceM

It's been fun winding you up, but I have work to do. You have never
demonstrated in this group the capacity for logical thought, so trying to
address you on that level is futile. The picture of you turning red in the
face as you hammer out your sophomoric replies has been amusing for a while,
but is becoming as tedious as you are. I will steer other posters away from
your misinformation as needed, but I am through with addressing you
directly.

This is a perfect chance for you to get the last word. Go ahead, say
something predictable.


message
bullshit!!!

SQL Server let's you build light cheap _AND_ strong.

Maybe you should lose the training wheels and learn SQL Server!!!

-Aaron
 
T

Tony Toews [MVP]

ricardo said:
everytime i close or open my access database, i got a lost records, i don't
know why , is it a network problem, linked table problem,let someone help me
please
Click to expand...

Are you getting any error messages?

Try putting the following code behind the close button on forms. You
may have a record level constraint which is causing you problems.

If me.dirty = false then _
docmd.runcmd accmdsaverecord

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

a a r o n . k e m p f

good stuff.

I don't turn red.

And at least _I_ am not the idiot that is stuck making $12/hour.

-Aaron
 
J

Jerry Whittle

I'm an Oracle 10g DBA at my day job. Grown-up enough for you?

I'm grown-up enough to know that you use the right tool for the job and to
have many tools in the old toolbox. Seems that the only tool you know is SQL
Server. You sound like a broken record. A 'record' is like a CD but made out
of vinyl, kid.
 
Top