Is it possible to increase the size of the DB on the fly without messing anything up?

I actually wondered if that would work because I had deleted the dsn file and was still able to access the back end. I pushed the front end to...

Gotcha, thanks. Unfortunately I can't figure out how to get the connection to the backend so I think I'm stuck with a DSN connection on each workstation. Bloooows.

Thanks! Whether I can get this to work or not, I really appreciate all your help. I'm trying to learn this as I go, and somethings are easier...

Nope, that's what I want to do. I guess I'm not understanding how the module is called to make the connection to the back end when the front end...

gotcha. I guess I need to find out how to make the connection to the back end when the front end is first opened.

I try to launch the module from the On Open event of a form and get the following error:

The expression On Open you entered as the event property setting produced...

Okay. Did that, but still can't connect to the tables. Not even sure how to access the module once it's saved.

I'm not sure where I'm supposed to type that into. I've got a VB window open and all the code cut and pasted from the link you provided, but...

Uhhhh....in the code where am I supposed to put the server name and database name? Am I supposed to uncomment the input lines and add the info there or...

Thanks again. I'll give it a shot this week and let you know how I make out.

Thanks for the replies and advice. I looked at the link you provided Chrissy and kind of get what's going on, but where does that code need to be...

J Livingston SQL (2/6/2012)

---

pls confirm are the the FE tables now linking to SQL or the "old" BE (.after you made the table deletions) ?

out of interest...what are your "many...