Upgrading Access project to Intranet based one

FAQ

Profile

Upgrading Access project to Intranet based one

Database Help (Home) -> Programming

Next: dimension fact table question

Author

Message

Jay

External

Since: Nov 14, 2006
Posts: 17

(Msg. 1) Posted: Wed Nov 15, 2006 10:16 am Post subject: Upgrading Access project to Intranet based one Archived from groups: microsoft>public>sqlserver>programming (more info?)

Thanks in Advance MY aceess (MDB) project (Emp.mdb) is a stand-alone application. It gets data from SQL Server 2000. Here is what I need to do. I want to upgrade my Access project so that company users log in and run my access project in company Intranet. Should I redo everything to fit into SQL/Visual .Net project? And How can I? New to this field! I have SQL 2000 Client SQL 2000 Reporting Service MSDE 2000 Visual Studio 2003 >> Stay informed about: Upgrading Access project to Intranet based one

punjab_tom

External

Since: Mar 07, 2007
Posts: 26

(Msg. 2) Posted: Wed Nov 15, 2006 11:11 am Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

don't call it an Access Project you wannabe your Access APPLICATION? MDB is retarded and it shouldn't be used by anyone for any reason. NEVER. Spit on anyone that still uses MDB format. -Tom David Browne wrote: > "Jay" wrote in message > > > Thanks in Advance > > MY aceess (MDB) project (Emp.mdb) is a stand-alone application. > > It gets data from SQL Server 2000. > > . . . > > Does it use local access tables, or linked tables to SQL Server 2000? > > David >> Stay informed about: Upgrading Access project to Intranet based one

David Browne

External

Since: Sep 18, 2003
Posts: 126

(Msg. 3) Posted: Wed Nov 15, 2006 12:40 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

"Jay" wrote in message > Thanks in Advance > MY aceess (MDB) project (Emp.mdb) is a stand-alone application. > It gets data from SQL Server 2000. > . . . Does it use local access tables, or linked tables to SQL Server 2000? David >> Stay informed about: Upgrading Access project to Intranet based one

David Browne

External

Since: Sep 18, 2003
Posts: 126

(Msg. 4) Posted: Wed Nov 15, 2006 1:45 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

"Jay" wrote in message > Thanks, David. > Linked tables! > Then you won't have to change anything (unless you want to). Just point the linked tables to a remote SQL Server and the application should run from anywhere on the intranet. David >> Stay informed about: Upgrading Access project to Intranet based one

David Browne

External

Since: Sep 18, 2003
Posts: 126

(Msg. 5) Posted: Wed Nov 15, 2006 1:46 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

"punjab_tom" wrote in message > don't call it an Access Project you wannabe > > your Access APPLICATION? > > MDB is retarded and it shouldn't be used by anyone for any reason. > NEVER. > > Spit on anyone that still uses MDB format. > > -Tom > > David >> Stay informed about: Upgrading Access project to Intranet based one

punjab_tom

External

Since: Mar 07, 2007
Posts: 26

(Msg. 6) Posted: Fri Nov 17, 2006 11:40 am Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

MDB doesn't work across the internet! ADP works flawlessly -Tom David Browne wrote: > "Jay" wrote in message > > > Thanks, David. > > Linked tables! > > > > Then you won't have to change anything (unless you want to). Just point the > linked tables to a remote SQL Server and the application should run from > anywhere on the intranet. > > David >> Stay informed about: Upgrading Access project to Intranet based one

David Browne

External

Since: Sep 18, 2003
Posts: 126

(Msg. 7) Posted: Fri Nov 17, 2006 3:09 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

MDB's with linked tables (what we're talking about here) connect over ODBC, just like ADP's. David "punjab_tom" wrote in message > MDB doesn't work across the internet! > > ADP works flawlessly > > -Tom > > > > > David Browne wrote: >> "Jay" wrote in message >> >> > Thanks, David. >> > Linked tables! >> > >> >> Then you won't have to change anything (unless you want to). Just point >> the >> linked tables to a remote SQL Server and the application should run from >> anywhere on the intranet. >> >> David > >> Stay informed about: Upgrading Access project to Intranet based one

punjab_tom

External

Since: Mar 07, 2007
Posts: 26

(Msg. 8) Posted: Wed Nov 22, 2006 1:39 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

ADPs don't use ODBC, jackass and neither do linked tables in MDB they both use 'OLE DB' -Tom David Browne wrote: > MDB's with linked tables (what we're talking about here) connect over ODBC, > just like ADP's. > > David > > "punjab_tom" wrote in message > > > MDB doesn't work across the internet! > > > > ADP works flawlessly > > > > -Tom > > > > > > > > > > David Browne wrote: > >> "Jay" wrote in message > >> > >> > Thanks, David. > >> > Linked tables! > >> > > >> > >> Then you won't have to change anything (unless you want to). Just point > >> the > >> linked tables to a remote SQL Server and the application should run from > >> anywhere on the intranet. > >> > >> David > > >> Stay informed about: Upgrading Access project to Intranet based one

Roger Wolter[MSFT]

External

Since: Mar 07, 2007
Posts: 77

(Msg. 9) Posted: Wed Nov 22, 2006 2:30 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Such an authoritative statement with included expletives must surely be true. Given that, it seems odd to me that when adding a linked table to Access you must supply an ODBC DSN. How does that work? -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "punjab_tom" wrote in message > ADPs don't use ODBC, jackass > > and neither do linked tables in MDB > > they both use 'OLE DB' > > -Tom > > > David Browne wrote: >> MDB's with linked tables (what we're talking about here) connect over >> ODBC, >> just like ADP's. >> >> David >> >> "punjab_tom" wrote in message >> >> > MDB doesn't work across the internet! >> > >> > ADP works flawlessly >> > >> > -Tom >> > >> > >> > >> > >> > David Browne wrote: >> >> "Jay" wrote in message >> >> >> >> > Thanks, David. >> >> > Linked tables! >> >> > >> >> >> >> Then you won't have to change anything (unless you want to). Just >> >> point >> >> the >> >> linked tables to a remote SQL Server and the application should run >> >> from >> >> anywhere on the intranet. >> >> >> >> David >> > > >> Stay informed about: Upgrading Access project to Intranet based one

Roger Wolter[MSFT]

External

Since: Mar 07, 2007
Posts: 77

(Msg. 10) Posted: Wed Nov 22, 2006 2:32 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

While that may be true, what does that have to do with Jay running his application in his company's intranet? -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "punjab_tom" wrote in message > MDB doesn't work across the internet! > > ADP works flawlessly > > -Tom > > > > > David Browne wrote: >> "Jay" wrote in message >> >> > Thanks, David. >> > Linked tables! >> > >> >> Then you won't have to change anything (unless you want to). Just point >> the >> linked tables to a remote SQL Server and the application should run from >> anywhere on the intranet. >> >> David > >> Stay informed about: Upgrading Access project to Intranet based one

punjab_tom

External

Since: Mar 07, 2007
Posts: 26

(Msg. 11) Posted: Wed Nov 22, 2006 2:35 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

you tell me WHY you think that linked tables use ODBC and then I'll show you the PROOF. ok? I mean, even out here in India; we know how to 'read the manual' -Tom David Browne wrote: > So what exactly is your objection to linked tables in an MDB (which > certianly do use ODBC)? > > David > > "punjab_tom" wrote in message > > > ADPs don't use ODBC, jackass > > > > and neither do linked tables in MDB > > > > they both use 'OLE DB' > > > > -Tom > > > > > > David Browne wrote: > >> MDB's with linked tables (what we're talking about here) connect over > >> ODBC, > >> just like ADP's. > >> > >> David > >> > >> "punjab_tom" wrote in message > >> > >> > MDB doesn't work across the internet! > >> > > >> > ADP works flawlessly > >> > > >> > -Tom > >> > > >> > > >> > > >> > > >> > David Browne wrote: > >> >> "Jay" wrote in message > >> >> > >> >> > Thanks, David. > >> >> > Linked tables! > >> >> > > >> >> > >> >> Then you won't have to change anything (unless you want to). Just > >> >> point > >> >> the > >> >> linked tables to a remote SQL Server and the application should run > >> >> from > >> >> anywhere on the intranet. > >> >> > >> >> David > >> > > > >> Stay informed about: Upgrading Access project to Intranet based one

punjab_tom

External

Since: Mar 07, 2007
Posts: 26

(Msg. 12) Posted: Wed Nov 22, 2006 2:36 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Roger; not all linked tables use ODBC.. linked tables; to other Access databases use OLEDB. go ahead and make a new table and hit F1 ROFL -Tom Roger Wolter[MSFT] wrote: > Such an authoritative statement with included expletives must surely be > true. Given that, it seems odd to me that when adding a linked table to > Access you must supply an ODBC DSN. How does that work? > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > > "punjab_tom" wrote in message > > > ADPs don't use ODBC, jackass > > > > and neither do linked tables in MDB > > > > they both use 'OLE DB' > > > > -Tom > > > > > > David Browne wrote: > >> MDB's with linked tables (what we're talking about here) connect over > >> ODBC, > >> just like ADP's. > >> > >> David > >> > >> "punjab_tom" wrote in message > >> > >> > MDB doesn't work across the internet! > >> > > >> > ADP works flawlessly > >> > > >> > -Tom > >> > > >> > > >> > > >> > > >> > David Browne wrote: > >> >> "Jay" wrote in message > >> >> > >> >> > Thanks, David. > >> >> > Linked tables! > >> >> > > >> >> > >> >> Then you won't have to change anything (unless you want to). Just > >> >> point > >> >> the > >> >> linked tables to a remote SQL Server and the application should run > >> >> from > >> >> anywhere on the intranet. > >> >> > >> >> David > >> > > > >> Stay informed about: Upgrading Access project to Intranet based one

Roger Wolter[MSFT]

External

Since: Mar 07, 2007
Posts: 77

(Msg. 13) Posted: Wed Nov 22, 2006 2:55 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Yes but Jay is making linked tables to SQL Server. -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "punjab_tom" wrote in message > Roger; > > not all linked tables use ODBC.. > > linked tables; to other Access databases use OLEDB. > > go ahead and make a new table and hit F1 ROFL > > -Tom > > > > Roger Wolter[MSFT] wrote: >> Such an authoritative statement with included expletives must surely be >> true. Given that, it seems odd to me that when adding a linked table to >> Access you must supply an ODBC DSN. How does that work? >> >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> Use of included script samples are subject to the terms specified at >> http://www.microsoft.com/info/cpyright.htm >> >> "punjab_tom" wrote in message >> >> > ADPs don't use ODBC, jackass >> > >> > and neither do linked tables in MDB >> > >> > they both use 'OLE DB' >> > >> > -Tom >> > >> > >> > David Browne wrote: >> >> MDB's with linked tables (what we're talking about here) connect over >> >> ODBC, >> >> just like ADP's. >> >> >> >> David >> >> >> >> "punjab_tom" wrote in message >> >> >> >> > MDB doesn't work across the internet! >> >> > >> >> > ADP works flawlessly >> >> > >> >> > -Tom >> >> > >> >> > >> >> > >> >> > >> >> > David Browne wrote: >> >> >> "Jay" wrote in message >> >> >> >> >> >> > Thanks, David. >> >> >> > Linked tables! >> >> >> > >> >> >> >> >> >> Then you won't have to change anything (unless you want to). Just >> >> >> point >> >> >> the >> >> >> linked tables to a remote SQL Server and the application should run >> >> >> from >> >> >> anywhere on the intranet. >> >> >> >> >> >> David >> >> > >> > > >> Stay informed about: Upgrading Access project to Intranet based one

David Browne

External

Since: Sep 18, 2003
Posts: 126

(Msg. 14) Posted: Wed Nov 22, 2006 4:04 pm Post subject: Re: Upgrading Access project to Intranet based one [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

So what exactly is your objection to linked tables in an MDB (which certianly do use ODBC)? David "punjab_tom" wrote in message > ADPs don't use ODBC, jackass > > and neither do linked tables in MDB > > they both use 'OLE DB' > > -Tom > > > David Browne wrote: >> MDB's with linked tables (what we're talking about here) connect over >> ODBC, >> just like ADP's. >> >> David >> >> "punjab_tom" wrote in message >> >> > MDB doesn't work across the internet! >> > >> > ADP works flawlessly >> > >> > -Tom >> > >> > >> > >> > >> > David Browne wrote: >> >> "Jay" wrote in message >> >> >> >> > Thanks, David. >> >> > Linked tables! >> >> > >> >> >> >> Then you won't have to change anything (unless you want to). Just >> >> point >> >> the >> >> linked tables to a remote SQL Server and the application should run >> >> from >> >> anywhere on the intranet. >> >> >> >> David >> > > >> Stay informed about: Upgrading Access project to Intranet based one

Display posts from previous:

Related Topics:

Upgrading backend from Access 97 to sql server - Hi I have a typical access app with both front and back ends in access 97. The database is running slow due to number of users approaching 20. I would ideally like to upgrade the backend to sql server if that would improve performance. My questions..

Upgrading From SQL 2000 A few questions. - Hi All, Not sure if this is the most appropriate group to ask this, so appologies if its in the wrong place, anyhow! Currently, we are running VS2003, SQL Server 2003 and have implemented a number of reports using the embedded Crystal Reports Version...

Upgrading from standard to Enterprise edition of sql svr20.. - Good morning, I just want to know if I can just run setup for sql server 2000 Enterprise to upgrade a standard edition install? Or would I have to uninstall SE and then load the enterprise version? I have replication running on a couple of DB's. ...

Easy Project Outsourcing - Get Access to Specialized Services Hire Top Professionals on Elance http://jobs4-all.synthasite.com/

VB6 project with SQL2000 and SQL2005 - I asked my question in VB groups and was suggested to ask here. My question: I have VB6 project working with SQL2000 database. I use ADO. Is it going to work without any change with the same database attached to SQL2005? If NO, then what kind of changes...

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum