HA!  I figured it out!  Thank you for all the wonderful words of wisdom!  The answer was really dumb...as all IT answers usually are.  The name of the odb connector on...

Try bracketing [ ]  like [Dataname-1]

-Sharon

Thanks...you guys are being extremely helpful.  I know I sould like a complete dolt, but where in the text do I put my connector info in?  I'm thinking in:

  tbl.Connect...

The tables are connected to SQL, but the forms, reports and queries my users need remain in Access.  The problem is that the SQL connection, keeps disconnecting when multiple users...

Thanks for your help Jeff...another question though..

When I put it in the form to run, am I using the expression builder, macro builder or code builder or another way?  Sorry...

Thanks!!!  I am totally going to try this....now for a really dumb question:  Where do I put this?

-Sharon

Jeff, how can i re-create the pop-up you are talking about???

Sharon

Richie,

Initially, that is how the database was linked, but when I need different users to access the database through MS Access, the connector needs to be made for each inidividual. ...