Remind Me Again Why I Am Using Access....

[dbrooks]

I just worked for the past 48 hours on one copy of the database. Stupid...Yes of course it was.

I went through and commented all of my VBA, and was thinking wow this is really good. I had well over 100 pages of code, not one line was not commented. Then I went and imported everything into the existing database which is being used by 10-15 people, and got the famous Error Accessing Network File.

I have gone through every possible solution to fix this problem, with the exception of starting from scratch on the VBA. I tried the famous fix of importing my text to notepad, but there is one small problem.....I cannot even see my code. When I try to get into any form (35) or my main module it gives me this error message.

PPPPPPPLLLLLLLEEEEEAAAASSSSEEE Does anyone have any hidden fix, I can use to look at my code module to copy everything out to notepad so I do not have to spend another 48 hours on this code?

Please let me know your help is greatly appreciated.

 

[WayneRyan]

dbrooks,

I don't know what your app is doing or whether its a problem
with Access or the network.

You might try starting the db with the shift key depressed,
in case something in your Startup is dying.

Or try creating a new blank database and importing everything
into it.

let me know,
Wayne

 

[dbrooks]

Good idea, but unfortunetly that is one of 50 fixes I have tried. My database opens fine, but anytime it runs any code, it fails because it does not know where it is.

 

[WayneRyan]

dbrooks,

I don't understand.

"opens fine, but anytime it runs any code, it fails"

Why can't you just open the database window and look at
forms or modules in design view and extract your code?

And if it opens fine, why can't you import the forms etc. into
another database?

Maybe, you have just lost the links to your tables?

I suppose that its too big to post here.

Wayne

 

[dbrooks]

Wayne,
Thanks for the response. The database window opens however when you goto design view and view the code, it says "A Network Error Has Occured" and it opens up a blank module which has no code.

When I goto Extract the forms, reports, or modules (Anything with code behind them), it extracts the physical form, report, ext. however the code does not go because of the error message "A network error has occurred".

Thanks. -d

 

[WayneRyan]

d,

Are you physically on the machine where the db resides?

Can you copy the database to someplace else?

I've never heard of anything like this.

Wayne

 

[dbrooks]

The database currently resides on my PC. I would send it to you so you could see it but it has confidential information within.

-db

 

[Freddy]

DBrooks,

Did you make any progress with this problem? I am getting the same error messages. My module has one small function in it.

The db resides on my desktop where I have full rights. All tables are links an SQL server. I also tried refreshed the linkks.

 

[WayneRyan]

Freddy,

Can you post your db here?

Wayne

 

[Freddy]

I even made a backup and removed all queries, forms, tables and reports - There is literally nothing in the db except a date conversion function, pass one date is, it passes back Friday's date - I compacted and repaired and still get the error when I try to open the module.

Db's attached. Thanks for the help!

 

[chewy]

I cant see it I need it in 97. Is this a FE and BE?

 

[Freddy]

Oh...I'm using Access2k on a Win2k workstation.

 

[WayneRyan]

Freddy,

Wow, that sure is messed up!

I can't do anything with it.

I did write a little s/w to read the db in binary mode to get
your code, but there's no code in there.

Sorry,
Wayne