Hi. I'm coming from a background of developing mdbs and am trying to migrate
our databases to adps running atop MSDE 2000. However, I've encountered a
problem while trying to do analogous things to what I've done before with
mdbs...for example:
-Linking to a csv file on another machine: I am able to establish a link
uning the 'Link Table Wizard' that shows up as a new view. However, upon
openning the view I see only a single column (left-most).
Get a filestream download link with only access to read and with folder navigation
I need a link with the path to get the file stream blob, that path could be used to download a document using any windows app like windows explorer, etc. the requirement is that path does not allow customer to navigate in filesstream share folders or see other files and only can read the file of the path,
Checking :
[file_stream].GetFileNamespacePath(2)
Allow you navigate in folders.
NON_TRANSACTED_ACCESS read_only, resolve the requirement to disable the save in file table, but allow you navigate and see other files.
When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning.
The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().
The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source.
Observations: This function has worked normally in the recent past and works on other computers running Access 2003. One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).
Has anyone experienced anything like this? What's going on?
Is it possible to link MSDE to another server through ODBC? I want to do this like you can in Access, where you get external data by linking tables. Any ideas? Thanks!
How to use Microsoft Data Link(Udl) type file to connect with SQL Server using SQL Native Client,If i use OLDEDB Connection i can make connection using UDL file with Database ,but how can i use a file for a connection using SQL Native Client.Is there any other data link file that can be used to connect with SQL server using SQL Native Client.
I am working from within an SQL database trying to get data from an MS Access Database as a linked server. I can "successfully" add the linked server, but when I try to open it from SQL EM I get "Error 7399. . . " from Microsoft Jet. When I try to query it from QA I get "Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Not a valid account name or password.]"
I tried both Access 2000 databases and '97. Same results for each. Big project pending . . . any help is appreciated!
I work extensively with Access; I have a new project with very large tables (as many as 15 million records). Is it worth my while to link Access to SQL Express if both are on the same machine?
I've downloaded SQL Express and installed it, but it won't let me link to Access 2003. Is there an update or patch to Access 2003 that will make this work?
If I do make the link successfully, will it be transparent - that is, can I work in Access as I always have, or would I have to learn how to create databases and queries in SQL? (I do know that I can make tables in Access and migrate them to SQL Server).
Where would I find simple step-by-step instructions to do this - my interest is more in the substance of my data analysis than in programming per se.
hello. I have a windows 2003 server with sql server 2000 and a public IP address and domain name
when i am on the same network as the server I can link to the sql server with just the dowmain name www.omghelp.com but when I take that same access adp file or mdb file home it says "database can not be found " what do i need to get it to work...help please
I think I may be going a little bit mad. Last week I created a database on SQL Server. I then created an access database on a different windows server, and set up an ODBC connection on that windows server to my database on SQL Server. I then set up linked tables within Access to point to my tables on the SQL Server. I'm fairly sure that I opened those links at the time and managed to display and update the data from Access. However I have come to this today and when I go into the Access database and attempt to open one of the links I get a connection failed message. When I check the ODBC connection on the windows server it is fine. Does anyone have any ideas on this? I really need this to be working by tomorrow to do a demo, and I'm so convinced it worked last week I am a little bemused!
Many many thanks in advance of your wonderful and prompt replies!!! :)
I have a problem that I want to solve by linking MS Access to SQL Server 2000 or 2005.
The problem is a 3 party MS Access '97 application that is no longer supported so a new system is currently being built in SQL Server. The Access database has a UI for small amounts of input and viewing but most of the work is done through a WaveLink application. The Wavelink application allows users on the shop floor via wireless devices to pick and count product which then updates Access. There has always been record locking issues that caused some delays at the wireless devices but nothing dramatic. Until now. The wireless network and wireless devices have been upgraded and now record locking (I presume that whats causing the problems) is now causing large productivity delays requiring constant intervention. The Wavelink application is also being updated from VB6 to VB.Net to work with the new SQL Server application. One of the requests from the client is that the Wavelink upgrade somehow fix the problem with the Access database.
My idea was to link the Access database to a SQL Server so that the wireless devices go through SQL Server to Access hopefully taking the load off Access. Is this possible? Would SQL Server prevent the record locks and provide a better multi user environment or is that something that is inherent in OLEDB Jet and linking is not going to circumvent this problem?
hi, A and B are different asp.net projects. Each has its own sql database, and is linked to each other through socket/TCPListener.how can page B access the data in sql of A through this socket?thanks!
I have a SQL 2K database on a named instance with tables populated with data and they have no relations between them. I have a MS Access 2000 database. I have a system ODBC connection on the client computer to the SQL 2K using trusted connection. I linked the tables into MS Access 2000 to SQL 2K and I can read the data without any problem. When I try to update the data on the table, I get the message : The recordset is not updatable. I am the DBO. So I am supposed to have all rights. All the select, update, insert and DRI rights are enabled. I tried it with another user and it does not work either.
Hi All, I have recently migrated from Access to SQL Server. I have come across a strange problem. I have got a table in my database whihc is not linked to any other table, but does include data and is used from time to time for reports. It is more used as a sort of lookup table. Now I had the frontend in Access and I have retained it. So I connect all the SQL Server tables via ODBC to Access. The problem with this table is for some reason it wont allow to add new records on Access side. You can just view the contents, but cannot add anything to it e.g a new record, etc. I tried giving explicit permissions of Select, Insert, update, etc. but still no result. There are other look up tables as well, that have the same problem. Can anybody tell me why this is so and is there any way to fix it?
I'm trying to find how to link to an Access table from within SQL Server. I know I have seen it once, but can not remember where I saw it. I'm using SQL Server 2005. TIA,
I am getting an error trying to select data from a Linked Server that is connected to a secured MS Access database. I have entered the login and password for an admin in the sytem but I am still getting the error below. It seems that all of the examples shown on the Online help are for unsecured databases. Can anyone help me with this issue?
Thanks
Will
SELECT * FROM TMS_SECURED...Assignments
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMS_SECURED" returned message "You do not have the necessary permissions to use the '\FileSrv-05ProductionTMSTMS-DATA.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMS_SECURED".
My manager told me to link SQL Server database tables to access so that he can access the tables in MSAccess to do his SQL queries. I am thinking of linking server but I am not sure about that. Is someone can tell me what to do and explain me how. Thanks in advance Sincerely. David
How can make link to a table stored in an sql express 2005 database in access 2003 ? the classic method doesen't work. i tried to use odbc databases as file type to link, then build a data source using SQL native clint driver, but in the combo for default database i don't have the database created before, only master,msdb, model, tempdb. If i try to use the attach database filename text box i receive an error "the datadase entered is not valid". Any suggestions ?
i'm trying to set a data source in Access 2000 to link to SQL Server express..I have mixed mode set..what user/password do I put in? I tried sa, but get error server does not exist, or access denied.. thanks!
Hi All, I have recently moved jobs. From my last job I created a holiday database for the organisation, than I copied it on a storage device. Now, in my new job I would like to use same database. But the problem is most of the tables were linked. I know I can convert linked tables to local tables and I have tried it but it asks me for the new location with the same table names. Can some one please helpppppppppppppppppppppppppppppppppp I as I am really very desperate.
I'm not sure if this is the proper place to post this question but thought I would start here.
I have an Access link to live SQL data. We have since migrated to a new physical server and new logical server name.
My question then is, how can I edit the pre-existing Access link to the live SQL data/database and make changes so that the new server is taken into consideration?
I have upsized an Access database into SQL Server and manged to getthe data in place ok. The wizard created an Access Project which Ihave started to modify.However, I am also trying to get data from an AS/400. Specifically fora currency/exchange rate file. I only want ot copy the records sincethe last copy otherwise there are a vast number of records.I have created a linked server to the AS/400 within SQL Server, andcreated a view, within my specific database which allows me to look atall the data in the table.However, my problem is that I want a VB routine, in the AccessProject, which lets me copy out specic records from the view into atable within the SQL Server database. Any clues?????My oroginal code used a link to the AS/400 and the folowing code:-s = "INSERT into zacjdf00 "s = s + "select CJCNCD, CJD5E9, CJCUCD, CJD5FF, CJD5FG, CJD5FH,CJD5FI, CJD5FJ, CJD5FK "s = s + "from XGHLDTM_ZACJDF00 "s = s + "where "s = s + "CJD5E9 = '" & group & "'"DoCmd.RunSQL (s)group is preset in the VB code.
I'm a long-time Access developer who is looking to migrate his approach to SQL Server CE 3.5 instead of having all these MDBs. One thing that I do like is using Access to surf through databases; it's a lightweight way to see the data without having to fire up the overhead of Visual Studio etc. Plus there's the QBE grid for easy query design for those of us whose tool-less SQL coding is a bit rusty...
Anyway, I was wondering whether it was possible to "attach" to a SSCE database so you can see it in Access. I've tried but haven't found a way of doing it. Any thoughts? Or is this an intentional lack of capability so we have to use a more robust tool such as Management Studio or Visual Studio?
Hi, not sure if this is the correct forum to post in?
I am trying to connect to a csv file to import into a table to process thru my vb.net coded application.
I see from BOL that I should not allow ad ho distributed queries and should create a linked server to the data I require.
I am trying to create a linked server to the csv file selected by the user but am coming unstuck as I do not know the correct info to put in the connection settings etc.
Code Snippet
Dim srvAdminServer As Server = Nothing
Dim cnSQLConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection(My.Settings.MMConnectionString)
Dim scnServerConnection As ServerConnection = Nothing
Dim lsrv As LinkedServer
cnSQLConnection.Open()
scnServerConnection = New Microsoft.SqlServer.Management.Common.ServerConnection(cnSQLConnection)
srvAdminServer = New Server(scnServerConnection)
lsrv = New LinkedServer(srvAdminServer, "CSV-IMPORT")
lsrv.ProductName = "MSDASQL"
lsrv.Create()
The code above does not error until I call the create method when I get an unknown product or provider error?
This is all new to and I have searched and searched without success!
Hi,SQL Server 2000 SP3Windos 2000 Server SP4I have a DTS package that imports data from a dBase IV databse withfiles located in two folders (dBF1 and dBF2). I use a transform datatask to transform the data.They were running properly, but last week we installed W2K SP4, andnow the transform task for files from dBF2 are not working properly.I have two tranform tasks to extract data from files in dBF2 folder.If I double click to open the transform data task of either of them,Enterprise Manager crashes with the errrormmc.exe applicatio ErrorThe instruction "xxxx" referenced memory at "xxx". The memory couldnot be read.Althoug the transform task for one of the files will run, the otherwill not run giving the messageError Source: DTS packageCatastrophic failureAlso, I have an Access database that has links to the same dBasefiles. For files from dBF2 folder, I'm able to see the data from oneof the files, but if I double click to see the data from the other,access crashes with no specific error message. Nothing has changed ondBase related files (permission wise).The transform tasks to extract data from the other dBase folder (dBF1)files are working fine, and data is accesible from Access.Any advice how to tackle this one?
I have just downloaded and installed the SQL Server 2005 Express version, enabled TCIP and Named pipes but when I try to link to the tables with Access 2003 or try to create a database connection I get an error 17 "connection failed - SQL Server does not exist or access is denied".
I am able to open Management Studio Express and see all of the databases, including another SQL Server 2005 server that I have. I am able to Link to my other server but I can't get see my local install.
If I define a table-valued function in a SQL Server 2005 database, can I link to it from Access 2003 using ODBC?
I've defined the function successfully, and I can link from Access to tables in the database (so my ODBC link is basically functioning), but I can't see the table-valued function in the Linked Table Manager in Access.
I can define a pass-through query to grab the table, but with a pass-through query I have to provide the ODBC password every time.
I initially created an Access application within Access 2003 which I subsequently migrated to SQLExpress 2005 (Tables only) using Microsoft SQL Migration Assistance for Access 2003 (SSMAA) and continue to use Access 2003 as a front end, this really was easy and worked perfect. Now I added a new table to my SQLExpress DB and need to link to it from my Access application but can not find a way to do so in the same way that the SSMAA does. I need to run the Access 2003 application in share mode from multiple PC in the LAN. If I try linking to the table using an ODBC connection I can only access from the PC where the link was done! Any ideas? THanks in advance.
I have a report that returns a field with the location of a .csv file on the network. The value of the field looks like this:
\ServerNamedatafile.csv
I need to let the user click a link to open the file. Simply making the Jump To Url under navigation the field value doesn't work; it's not clickable. I've tried a javascript new window command, but I'm no good at javascript.
All my google results turn up unrelated items because I'm searching "ssrs open file" or "ssrs open file in windows explorer".
