Tables linked to SQL server do not stay active... please help!!!

K

Kelvin Beaton

For testing purposes I had a local tbl_ExceptionToPolicy table.
I created the same table using Enterprise Manager so that in the working
version of the database it will be talking to SQL db..
When I first link the table, I can see there is one new record. That's fine.

After I close and reopen the database when I look at the table it has no
rows.

If I delete the and reconnect the table it's there and then goes away again.

Why???

Does this have anything to do with the user name and password I use for
Enterprise Manager?
I've been using the sa/ and password to link the table.
Should I be using the same user name and password the database uses?
Update: I did try the same user name and password that the users us, with
the same results.

I have a number of databases I have developed this way, and haven't run into
this so far with them...

What's going on here?

Any help would be appreciated
 
S

Steve C, MFS

If you've done several, this may not be the case, but if using SQL auth
rather than domain auth, did you tick the box to remember password when
linking the table? If not when you close and reopen access you have to
re-authenticate and I think the only point where you can do that is when you
add the table.

Hope that helps.
 
Top