Thank U !! - Re: Access looks for a particular drive.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: billyboy2 (billyboy2_at_pcsure.com)
Date: 01/18/05 

Date: Mon, 17 Jan 2005 18:34:01 -0800

A special 'Thank U' to all the nice folks in these groups who help novices
like me. The suggestions you offered were of great and instant help.
Problem fixed! I'm sorry that I posted the problem in several boards -
guess I was desperate. Hope you help a lot more others. Thanks again.
 - Billy Boy II.

"Carl Rapson" <cr@myhouse.com> wrote in message
news:%23yXKNcK$EHA.2196@TK2MSFTNGP14.phx.gbl...
> I'm not sure I understand how you can search the vba code if you can't
> locate the .mdb file in the first place. If your database is split into a
> front-end and back-end, you might look under Tools | Database Utilities |
> Linked Table Manager and see if your data files are located in an .mdb
file
> on that drive. I'm not sure about the graphics files; maybe in the main
> form's Open event a reference is being made to something (like
> Application.Path) that indirectly points to the same location.
>
> HTH,
>
> Carl Rapson
>
> "billyboy2" <billyboy2@pcsure.com> wrote in message
> news:%2399CyBG$EHA.600@TK2MSFTNGP09.phx.gbl...
> >A colleague was programming our Access database before I was asked to
make
> >a
> > few changes on it because we changed PCs. On loading, it tries to
locate
> > the .mdb & graphic files on a particular drive - \\mdb-filesrv\goodguys.
> > "mdb-filesrv" was the network name of the former PC which is no longer
in
> > use, and "goodguys" was the name of the folder with the "goodguys.mdb"
> > file.
> > I've use the "Find" menu command to search through the vba codes for a
> > clue
> > without luck. Please, how do I make it point to the new PC whose
network
> > name is "mdb-filesrv-2": The folder is still the same - "goodguys".
> > Thanks.
> > - Billy Boy II.
> >
> >
>
>

Relevant Pages

  • Re: Build new Access database from .NET application.
    ... I was able to create the mdb file and, by using and XSD, I can create the ... Private Sub ExportData(ByVal sender As System.Object, ... the details of the data and then send those records to the Access database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem accessing Access/Jet databse: Could not lock file
    ... not lock file" when opening a connection to an Access database on a network ... shared folder. ... Since the .mdb file can be opened using Access and everything can be done, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How do I import a database from another computer?
    ... What format does the original have to be saved in so it can ... An Access Database is a complex object, ... container for multiple forms, reports, modules, queries, tables, and ... .mdb file as it can potentially contain damaging code). ...
    (microsoft.public.access.gettingstarted)
  • Re: Caching data
    ... My problem is a relatively tight deadline so I can't do too much search forehand... ... I ended up using ADO and created an Access database on the fly. ... My application just deletes the mdb file on completion. ... I used the standard ADO classes with Delphi, and an ADOX call to create the mdb in the first place. ...
    (borland.public.delphi.non-technical)
  • Re: Simple Database Connection Code
    ... MyDataBase = your Access .MDB file, give a full path of your file location, ... MyTable = your table in Access database. ... > Does anyone have some basic code and the corresponding resources needed ... > blah, blah, blah. ...
    (microsoft.public.dotnet.languages.csharp)